IF Combinations

Freeintermediate 15 min4 tasks0/48 pts

Combine IF with AND and OR to make richer decisions, or nest one IF inside another for three or more outcomes. Build the test first (AND(...) or OR(...)), then wrap it in IF.

Syntax

IF(AND(test1,test2), yes, no) · IF(OR(test1,test2), yes, no) · IF(test1, a, IF(test2, b, c))

Example: =IF(AND(B2>=100,C2="Yes"),"Free","Pay")

Common mistakes

Closing brackets in the wrong place when nesting.
Testing text without quotes (C2=Yes instead of C2="Yes").

SWITCH Function IFERROR & IFNA Functions