Documentation/How Tos/Calc: ISFORMULA function

From OpenOffice.org Wiki

Jump to: navigation, search


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 function, ISNUMBER function, ISLOGICAL function, ISBLANK function, ISERROR function

Information functions

Personal tools