Difference between revisions of "Documentation/How Tos/Calc: ISFORMULA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
|||
Line 16: | Line 16: | ||
: where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | : where C5 contains <tt>'''2'''</tt> returns <tt>'''FALSE'''</tt>. | ||
− | + | {{Documentation/SeeAlso| | |
− | + | * [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]] | |
− | + | * [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]] | |
− | + | * [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]] | |
− | + | * [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]] | |
− | + | * [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]]''' | |
− | + | * [[Documentation/How_Tos/Calc: Information functions|Information functions]]''' | |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 13:58, 25 February 2009
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.