BizInsight Time Saver Tip – The Choose Function

How to: Use the CHOOSE function to assist in Creating Dynamic BizInsight Column Headers for the Month

1.      Enter your company, fiscal year and fiscal period into your worksheet, as required.  For this example, our fiscal period reference is located in cell B3

2.      In the cell where you want to note your current month, use the following CHOOSE function:

=CHOOSE($B$3,”January”,”February”,”March”,”April”,”May”,”June”,”July”,”August”,”September”,”October”,”November”,”December”)

 

This expression works if your fiscal year is the calendar year.  It takes the period number listed in B3, then finds that position in the list and returns that value.  So for period 11, it would look for the 11th value listed, and it would subsequently return “November”.

If your fiscal year started in month other than January, your list would begin with that month’s name.  If they fiscal year begins in June, for example, your CHOOSE function would look like this:

=CHOOSE($B$3,”June”,”July”,”August”,”September”,”October”,”November”,”December”,”January”,”February”,”March”,”April”,”May”)

 

Need help? Contact Us 

You may also like

5 Advantages to choosing Oasis Solutions as your NetSuite Solution Provider  NetSuite is considered the #1 cloud ERP in the ...

In 2024, we’re living in the future. Pocket-sized AI and portable workspaces have shown us that finding balance at work is as ...

Stay tuned on our ERP path!

Subscribe to our newsletter and get the latest news