IFS Function in Google Sheets
IFS checks several conditions in order and returns the value for the first one that is TRUE — cleaner than stacking IF inside IF.
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", TRUE,"F")
Checks each condition left to right; the first TRUE wins. TRUE at the end is the catch-all "else".
How it works
IFS takes pairs of condition, value. It evaluates the conditions from left to right and returns the value paired with the first condition that is TRUE. Because there is no built-in "else", a final TRUE, default pair acts as the fallback. If nothing matches and there is no TRUE fallback, IFS returns #N/A.
Variations
With a cell reference as the result
=IFS(B2="US",C2, B2="EU",D2, TRUE,0)
Returns a different column depending on region, 0 otherwise.
Nested IF equivalent (older sheets)
=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","F")))
Same result if IFS is unavailable.
Examples
| Scenario | Formula |
|---|---|
| Bucket a score into Low/Med/High | =IFS(A2<50,"Low", A2<80,"Med", TRUE,"High") |
| Guard against #N/A | =IFERROR(IFS(A2>0,"pos", A2<0,"neg"),"zero") |
FAQ
Why does IFS return #N/A?
None of the conditions were TRUE and there was no TRUE catch-all. Add a final TRUE, default pair.
Does the order of conditions matter?
Yes. IFS stops at the first TRUE, so put the most specific or narrowest ranges first.