Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / ISBLANK
In This Topic
    ISBLANK
    In This Topic

    Summary

    This function tests whether a value, an expression, or contents of a referenced cell is empty.

    Syntax

    ISBLANK(cellreference)

    ISBLANK(value)

    ISBLANK(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.

    This function returns TRUE if the value refers to an empty cell or to no data.

    Note: Function implementation generally tries to follow the behavior found in popular spreadsheet applications; however, not all these applications agree whether the empty string "" should be treated the same as an empty cell. In GcSpread, both the COUNTBLANK and ISBLANK functions consistently treat the empty string "" differently than an empty cell.

    Data Types

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

    Examples

    ISBLANK(B1)

    ISBLANK(A4)

    ISBLANK(A4-52)

    ISBLANK(4) gives the result FALSE

    See Also