Spread Formula Reference
Formula Functions / Functions H to L / IFS
In This Topic
    IFS
    In This Topic

    This function performs a comparison and returns the specified associated value if comparision is TRUE.

    Syntax

    IFS(condition,value1, [condition2,value2],...)

    Arguments

    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).

    Remarks

    This function allows users to test upto 127 different conditions.

    Data Types

    Accepts numeric (boolean) data for both arguments. Returns any data type.

    Examples

    IFS(A2 89,"A",A2 79,"B") gives the result B.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.