IFS Function

Syntax

IFS(condition1, value1, condition2,value2,…condition2, value2, …)

• condition1 - The first condition to evaluate. This can be a boolean value, a number, an array, or a reference to any of these;
• value1 - The value returned if condition1 is TRUE;
• condition2, value2, … - Additional conditions and values if the first is evaluated as false.