Excel Yourself: CHOOSE your coding weapons

Excel Yourself

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.


How-to articles, sample spreadsheets and more

Excel yourself

Combine annual and monthly data in Excel with these simple steps


Making data relationships work

Easy steps to make data Relationships work in Excel


Excel Yourself

Easy tips for matching salary to job class in Excel