FUNCTION CATALOGUE / LOGICAL
IFS Excel function
Tests conditions and returns the first matching result.
Correct sentence to use
Return [result 1] if [condition 1], and [result 2] if [condition 2].
Modify this query in PlainFormula →Example formula
=IFS(A2>=90,"A",A2>=80,"B",TRUE,"Other")
Tests conditions in order.
Syntax
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], …)
Argument signature: logical_test1, value_if_true1, [logical_test2, value_if_true2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.