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!