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

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(5 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>.
  
=== See also: ===
+
{{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]]
'''[[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]]''',
+
* [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]]
'''[[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]]''',
+
* [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]]
'''[[Documentation/How_Tos/Calc: ISERROR function|ISERROR]]'''
+
* [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]]
  
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]'''
+
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
  
[[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/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