Logical
IFS function playground
Checks several conditions in order and returns the value for the first TRUE one.
The playground runs in your browser. Nothing you type is sent anywhere.
How IFS works
IFS checks the first condition; if it is TRUE it returns the matching value and stops. Otherwise it moves to the next pair.
Order matters: put the strictest test first (>=90 before >=80). If no condition is TRUE the result is #N/A, so finish with TRUE as a catch-all.
Syntax
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)| Argument | What it means |
|---|---|
logical_test1required | The first condition to check. |
value_if_true1required | What to return if it is TRUE. |
logical_test2, value_if_true2, ...optional | More condition/value pairs, checked in order. |
Examples
| Formula | What it does | Result |
|---|---|---|
=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",TRUE,"F") | Letter grade for Test 1. | A · D · C · F … |
=IFS(D2>=0.95,"Excellent",D2>=0.85,"Good",TRUE,"Needs work") | Attendance rating. | Excellent · Good · Good · Needs work … |
=IFS(B2>=90,"A",B2>=80,"B") | Without a catch-all, low scores give #N/A. | A · #N/A · #N/A · #N/A … |
Common mistakes
Tests in the wrong orderIf >=60 comes before >=90, a 95 gets the >=60 result. Put the highest threshold first.
No defaultEnd with TRUE,"value" so every row gets a result.
Related functions
Learn more
Download the example workbook (.xlsx)
The workbook has the same sample data and formulas, plus a practice sheet.