Difference between revisions of "Documentation/How Tos/Calc: ISFORMULA function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Bot: Adding Category: Documentation)
 
(2 intermediate revisions by 2 users not shown)
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|
+
{{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]]
Line 27: Line 27:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
[[Category: Documentation]]
+
[[Category: Documentation/Reference/Calc/Information functions]]

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.



{{#switch:EN

| RU = Смотрите также: | UA = Дивіться також: | EN = See Also | PT = Ver também | #default = See Also }}

Personal tools