From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Finding table-like information within a function using the CHOOSE function

Finding table-like information within a function using the CHOOSE function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Finding table-like information within a function using the CHOOSE function

“

- In this worksheet, called Choose we're seeing some dates in column A and in column B is a calculation calculating the quarter, the quarter of the year. It's done by way of a ROUNDUP function and nothing wrong with that. If, however, we were to change quarterly system, somehow. Begin in October, maybe the way the federal government does for fiscal years or something like that. You'd have to rework this in different way. Now, another way to do this is by way of a function called CHOOSE. It isn't necessarily better and it is sometimes compared with the VLOOKUP function except rather than referring to an external table of data, the CHOOSE function has all the data embedded within it. Let's begin with the idea how CHOOSE works, =choose. CHOOSE begins with some value. It can be a formula, it can be a calculation, it can be pure number. Suppose we were to consider the month of each one of these. That's how we, ultimately, will determine a quarter. So what's the month of that first date?…

Contents