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

    This function performs a comparison and returns one of two provided values based on that comparison.

    Syntax

    IF(valueTest,valueTrue,valueFalse)

    Arguments

    This function has these arguments:

    Argument Description
    valueTest Value or expression to evaluate
    valueTrue Value to return if the test evaluates to true
    valueFalse Value to return if the test evaluates to false

    Remarks

    The value of valueTest is evaluated. If it is non-zero (or TRUE), then valueTrue is returned. If it is zero (or FALSE), then valueFalse is returned. The value of valueTest must be or evaluate to numeric data, where non-zero values indicate TRUE, and a value of zero indicates FALSE. It may contain one of the relational operators: greater than (>), less than (<), equal to (=), or not equal to (<>).

    Data Types

    Accepts numeric (boolean) data. Returns any data type.

    Example

    IF(A3<>2000,1900,2000)

    IF(R1C2>65,1000,2000)

    IF(C4,B2,B4)

    IF(1>2,5,10) gives the result 10

    IF(1<2,""dogs"",""cats"") gives the result dogs

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    AND | FALSE | Logical Functions