Documentation/Calc Functions/ISFORMULA

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).

Related LibreOffice functions:
ISTEXT

ISNUMBER

ODF standard:
Section 6.13.18, part 2

Equivalent Excel functions:
ISFORMULA