Articles with the tag:
Articles with the tag:
Try in the cloud

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.


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.


How to apply the IFS function.


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.

IFS Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action