IFS

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

Use

IFS( condition1, value1, condition2, value2, ... )
Checks whether one or more logical conditions are TRUE and returns a value that corresponds to the first TRUE condition.

Parameter	Required	Description
condition1	Yes	logical condition that evaluates to TRUE or FALSE
value1	Yes	the value to return if the logical condition1 is TRUE
condition2	No	logical condition that evaluates to TRUE or FALSE
value2	No	the value to return if the logical condition2 is TRUE
...	No	more logical conditions and values

Returns

A value with the same type as value1

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.