blog home

GP6 and GP7 - IF Statements - Simple and Nested

Subject: Business, Information Systems
Courses: K201
Posted by: Dalia

Our last video for GP6 covers Excel's IF formula. We go over some simple use cases (for GP6), as well as some more complicated applications. We'll talk about how IF formulas can be used inside another IF formula ("nested IFs") along with the AND and OR boolean functions to build decision trees.

Nested IF statements tend to give K201 students a lot of trouble, so we hope this video can help clear things up a bit!

Download the exercise files