Documentation/How Tos/Calc: ISFORMULA function

ISFORMULA

Tests if a cell contains a formula.

Syntax:

ISFORMULA(cell)

Returns TRUE if cell contains a formula and FALSE otherwise.

Example:

ISFORMULA(C4)

where C4 contains =SQRT(4) returns TRUE.

ISFORMULA(C5)

where C5 contains 2 returns FALSE.

---

See Also

• ISTEXT
• ISNUMBER
• ISLOGICAL
• ISBLANK
• ISERROR

• Information functions

• Functions listed alphabetically
• Functions listed by category