Documentation/Calc Functions/ISFORMULA

    From The Document Foundation Wiki
    Other languages:


    Function name:

    ISFORMULA

    Category:

    Information

    Summary:

    Determines whether a specified cell contains a formula.

    Syntax:

    ISFORMULA(Reference)

    Returns:

    Returns TRUE if the specified cell contains a formula and returns FALSE otherwise.

    Arguments:

    Reference is a reference to the cell that is to be tested to determine if it contains a formula.

    • If Reference is not a cell reference but is an expression that evaluates to a number, a Boolean value, a date, or a string, then ISFORMULA returns the value FALSE.

    Additional details:

    • ISFORMULA does not propagate errors. If Reference corresponds to a formula cell, ISFORMULA returns TRUE whatever the result of that formula (even if it is an error value).

    Examples:

    Formula Description Returns
    =ISFORMULA(5) Here the function returns the logical value FALSE. FALSE
    =ISFORMULA(2022-01-06) Here the function returns the logical value FALSE. FALSE
    =ISFORMULA(C4) where cell C4 contains the number 5. Here the function returns the logical value FALSE. FALSE
    =ISFORMULA(C5) where cell C5 contains the formula =5. Here the function returns the logical value TRUE. Note that there may be no visual difference between the content of this cell and that used in the previous example. TRUE
    =ISFORMULA(C6) where cell C6 contains the formula =PI()*POWER(3; 2). Here the function returns the logical value TRUE. TRUE
    =ISFORMULA(C7) where cell C7 contains the formula =1/0. Here the function returns the logical value TRUE, even though cell C7 contains an error value (#DIV/0!). TRUE

    Related LibreOffice functions:

    ISTEXT

    ISNUMBER

    ODF standard:

    Section 6.13.18, part 2

    Related (or similar) Excel functions:

    ISFORMULA since v.2013.