IFS

Evaluates multiple conditions and returns the value that corresponds to the first true condition.

Parameter List

Syntax
IFS(condition1value1
[condition2value2]
)
condition1

The first condition to be evaluated. For example: A1>10

value1

The returned value if condition1 is TRUE. For example: `"Pass"

[optional] condition2

The second condition to be evaluated. For example: A1<9

Examples

IFS(A1<15, "Low", A2>15, "High") returns Low