Roadmap
Day 9 · Formulas 40 min 30 XP
🔀IF, IFS & making decisions in cells
IF lets a cell choose between answers. It is how you label rows, flag problems and build simple rules without any code.
What you'll learn
- Write an IF with a test, a result for true and a result for false
- Combine tests with AND and OR
- Replace long nested IFs with IFS
A peek inside
The shape of IF
The rest of Day 9 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Label rows automatically
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 30 XP + streak tracking
Already Pro? Sign in