This function performs a comparison and returns the specified associated value if comparision is TRUE.
IFS(condition,value1, [condition2,value2],...)
This function has the following arguments:
Argument | Description |
---|---|
condition1 | Refers to a value or expression to evaluate. |
value1 | Refers to a value to return if the test evaluates to true. |
[condition2,value2],... | [Optional] Refers to more conditions to be compared (nested IF statements). |
This function allows users to test upto 127 different conditions.
Accepts numeric (boolean) data for both arguments. Returns any data type.
IFS(A2 89,"A",A2 79,"B") gives the result B.