Documentation/Calc Functions/ISFORMULA

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎Nederlands



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

Equivalent Excel functions:

ISFORMULA