IFS
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
Syntax
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
Parameters
- logical_test1: Required. The first condition that evaluates to TRUE or FALSE
- value_if_true1: Required. Result to return if logical_test1 is TRUE
- logical_test2: Optional. Additional condition
- value_if_true2: Optional. Result to return if logical_test2 is TRUE
Example
=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", TRUE, "F")