Documentation/Calc Functions/ISFORMULA
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
ODF standard:
Related (or similar) Excel functions:
ISFORMULA since v.2013.