Advanced Decision Making using CHOOSE in Excel
How to make decisions in Excel without using an IF statement; here, we use the CHOOSE() function to make dynamic and advanced logical tests that eliminate the need for nested IF functions, in many cases.
The CHOOSE() function is a really helpful and powerful function that allows you to return a value or perform an action based on an index number that you supply the function. The cool thing is that you can return range references as well as text or number values - this allows you to make complex dynamic formulas.
This feature is also one of the building blocks for large complex Excel models and scenario analysis techniques because it allows you to build a worksheet that can completely change with the adjustment of a single cell.
I hope you find this tutorial helpful!)
Question? Ask it in our Excel Forum
- Skill Level: All Levels
- |
- 5 hours+
How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.
- Skill Level: All Levels
- |
- 2 hours
Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
Tutorial: How to make professional looking rounded buttons in Excel. This allows you to avoid using ...
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Tutorial: A UserForm is basically a pop-up window that you can use to create a custom interface for ...
Tutorial: View the Full VBA/Macro Course How to have a user confirm their input using vba - this fe...
Tutorial: How to use parentheses in Excel in order to create more powerful formulas and functions. S...
