IFS Function
The IFS function is one of the logical functions. It checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
Syntax
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
The IFS function has the following arguments:
Argument |
Description |
logical_test1 |
The first condition to be evaluated to TRUE or FALSE. |
value_if_true1 |
The value that returns if the logical_test1 is TRUE. |
logical_test2, value_if_true2, ... |
Additional conditions and values to return. These arguments are optional. You can check up to 127 conditions. |
Notes
How to apply the IFS function.
Examples
There are the following arguments: logical_test1 = A1<100, value_if_true1 = 1, logical_test2 = A1>100, value_if_true2 = 2, where A1 is 120. The second logical expression is TRUE. So the function returns 2.
Return to previous page