CHOOSE can often be a simpler solution in Excel than multiple IF functions.
Sometimes there's a better way than using multiple IF statements.
CHOOSE can often be a simpler solution in Excel than multiple IF functions, especially if you have to select from many different options. The CHOOSE function is typically used to select individual cells, but it can also be used to select a range from a list of ranges.
Want to learn more? Download this sample Excel file and check out our video tutorial.
Neale Blackwood CPA runs A4 Accounting, providing Excel training, webinars and consulting services.