Rows has joined Superhuman. Learn more. The Superhuman Privacy Policy and Terms will apply as of June 16.

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