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.
This function is available in Spread for Windows Forms 11.0 or later.
