O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing the CHOOSE function

Let's assume that you are tracking the financial records of your company and your boss wants you to deliver two reports every week, containing the total amount of sales that you made for a particular week and the total amount of purchases you made toward the company's stores. How would you go about it? 

You can always select all of the instances of sales and then calculate the sum of them. Once that is done, you have to again select all instances of purchases made and find the sum of purchases too. Having to do so frequently would be really time-consuming and boring. Here's where the CHOOSE function comes into play! We can implement a simple model that does everything for you in one click, using the following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required