Lesson 2: IF, make the sheet decide

SheetDrill Lesson 2 · IF: make the sheet decide

Lesson 2

fx

✓

Lesson 2 done.

Your sheet can now make decisions: compare values, return text or numbers, combine conditions with AND and OR, and chain IFs. Next up: finding things in tables.

Lesson 3: VLOOKUP, find things in tables →

What you're learning

IF asks a yes/no question and gives one answer if yes, another if no: =IF(test, if_true, if_false). The test is a comparison: >, <, >=, <=, = or <> (not equal). Text answers go in quotes; numbers and formulas don't.

AND(a, b) is true only if both are. OR(a, b) is true if either is. Put them inside IF to check two things at once. An IF inside another IF lets you pick between three or more answers; always test the biggest threshold first.