Loading…
Loading…
IFS checks several conditions in order and returns the result for the first one that is TRUE. It replaces long nested IFs. IFS has no "else", so finish with TRUE as the last test to supply a default; otherwise you get #N/A when nothing matches.
Syntax
IFS(test1, value1, [test2, value2], …)
Example: =IFS(B2>=80,"A",B2>=60,"B",B2>=50,"C",TRUE,"F")
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.