Syntax
=IFS(condition1, value1, [condition2, value2, ...])
condition1- The first test.
value1- Returned if condition1 is TRUE.
condition2, value2, ...- Optional. More test/result pairs, checked in order.
IFS function in Google Sheets
IFS tests a list of conditions in order and returns the value paired with the first one that's TRUE. It replaces long chains of nested IFs for grades, tiers and brackets.
Practice IFS
Task 1 of 2
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.
IFS examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Class | Score | Passed |
| 2 | Priya | A | 92 | TRUE |
| 3 | Leo | B | 67 | FALSE |
| 4 | Chloe | A | 48 | FALSE |
| 5 | Mateo | B | 81 | TRUE |
| 6 | Ines | C | FALSE | |
| 7 | Kai | C | 75 | TRUE |
| Formula | Result | What it shows |
|---|---|---|
=IFS(C2>=90,"A", C2>=80,"B", C2>=70,"C", TRUE,"F") | A | Priya scores 92. |
=IFS(C3>=90,"A", C3>=80,"B", C3>=70,"C", TRUE,"F") | F | Leo falls through to the TRUE catch-all. |
=IFS(C3>=90,"A", C3>=80,"B") | #N/A | No condition matches and there is no catch-all, so the result is #N/A. |
Tips and common mistakes
- Order matters. Test the strictest condition first, or every score ≥ 70 would get a "C".
- End with TRUE, value as a catch-all "otherwise".
Related functions
Learning step by step? IFS is covered in Lesson 8: IFS Function of the free course.