Difference between revisions of "Documentation/How Tos/Calc: ISFORMULA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
| Line 16: | Line 16: | ||
: where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | : where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] | * [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] | ||
* [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]] | * [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]] | ||
Latest revision as of 19:12, 16 July 2018
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
