Evaluates multiple conditions and returns a value that corresponds to the first true condition.
Sample Usage
IFS(A1>90, "A", A1>80, "B", A1>70, "C")
Returns the letter grade of A1 depending on its score. For instance, a 92 would be an "A".
Syntax
IFS(condition1, value1, [condition2, value2, …])
-
condition1 - The first condition to be evaluated. This can be a boolean, a number, an array, or a reference to any of those.
-
value1 - The returned value if condition1 is TRUE.
-
condition2, value2, … - Additional conditions and values if the first one is evaluated to be false.
Notes
- If all conditions are FALSE, #N/A is returned.