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

    This function, Is Reference, tests whether a value, an expression, or contents of a referenced cell is a reference to another cell.

    Syntax

    ISREF(cellreference)

    ISREF(value)

    ISREF(expression)

    Arguments

    Specify a cell reference, a numeric or text value, or an expression for the argument.

    Remarks

    Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

    If the argument is a reference, this function returns TRUE. If the argument is not a reference, this function returns FALSE.

    Data Types

    Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

    Examples

    ISREF(B3) gives the result TRUE

    ISREF(R1C2) gives the result TRUE

    ISREF(12) gives the result FALSE

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ISBLANK | Information Functions