Lesson 8 · Logic
IFS Function
Replace messy nested IFs with the IFS function in Google Sheets. Practice grading scales and pricing tiers.
Assign a letter grade in C2: 90+ → A, 80–89 → B, 70–79 → C, anything lower → F.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Many outcomes without nesting: IFS
=IFS(condition1, value1, [condition2, value2, ...])
IFS checks conditions in order and returns the value for the first one that's TRUE. Order matters: test the highest threshold first.
=IFS(B2>=90,"A", B2>=80,"B", B2>=70,"C", TRUE,"F")
The final TRUE, "F" pair acts as a catch-all "otherwise". Without it, a value that matches nothing returns #N/A.