IFS

Implements multiple if-then statements simultaneously

IFS( condition, then, [condition2, then2, ...], else )

Tests multiple if-then statements, returning specified then values for each pair and the else value if no condition is met.

Arguments

Argument	Description
condition(s)	Boolean expression to test
then(s)	What to return if true
else	What to return if no condition is met

Output

Outputs specified then value for each condition that is true and else if all conditions are false.

Example