Logic formula
IFS in Excel and Google Sheets
Test several conditions in order and return the first one that is true.
Syntax
=IFS(test1, value1, test2, value2, ...)- test1
- First condition.
- value1
- Result if test1 is true.
Example
| Row | A | B | C |
|---|---|---|---|
| 1 | Student | Score | Grade |
| 2 | Anna | 92 | |
| 3 | Ben | 78 |
C3 =IFS(B3>=90,"A",B3>=75,"B",TRUE,"C")
Result: B
Checks each threshold in order. TRUE at the end acts as "otherwise".
Ready-to-copy formulas
Commission tiers
=IFS(B2>=100000,10%,B2>=50000,7%,TRUE,5%)
Tips
- End with TRUE to catch everything else.
Need the whole spreadsheet?
Start from a free template with every formula already in place. Opening a template uses no credits.