Get startedGet started for free

Nesting logical functions

In the last exercise, we combined functions with SWITCH() to find the Total Upsell $, which found how much money Bananas could have made had all their customers been paying. While this is a good theoretical exercise, it does not address which accounts our customer success team should target for upsell opportunities.

Let's continue to build out some helpful functions with IF(), IFS(), and CONCAT().

If you've lost progress, open up 2_1_switch.xlsx from the Workbooks folder.

This exercise is part of the course

Data Analysis in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise