Difference between revisions of "Documentation/How Tos/Calc: ISFORMULA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 3: | Line 3: | ||
== ISFORMULA == | == ISFORMULA == | ||
Tests if a cell contains a formula. | Tests if a cell contains a formula. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 9: | Line 8: | ||
: Returns <tt>'''TRUE'''</tt> if <tt>'''cell'''</tt> contains a formula and <tt>'''FALSE'''</tt> otherwise. | : Returns <tt>'''TRUE'''</tt> if <tt>'''cell'''</tt> contains a formula and <tt>'''FALSE'''</tt> otherwise. | ||
| − | |||
=== Example: === | === Example: === | ||
| Line 17: | Line 15: | ||
<tt>'''ISFORMULA(C5)'''</tt> | <tt>'''ISFORMULA(C5)'''</tt> | ||
: where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | : where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | ||
| − | |||
=== See also: === | === See also: === | ||
Revision as of 13:05, 19 January 2008
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
