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 >=?

Zero2Hero — Zéro2Héros