Excel: decisions with IF
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: decisions with IF
IF(test, value if true, value if false) makes a decision. Tests use =, <>, <, >, <= and >=. Words go in "quotes". Put an IF inside another, or use IFS, for more than two outcomes.
Key words
- Nested IF
- Test from the highest band down.
- IFS
- test, value, test, value…
🔎 What to look for: Check the edge: is it > or >=?
