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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m
 
Line 2: Line 2:
 
{{Documentation/CalcFunc InformationTOC
 
{{Documentation/CalcFunc InformationTOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
|PrevPage=Documentation/How_Tos/Calc:_CURRENT_functions
+
|PrevPage=Documentation/How_Tos/Calc:_CURRENT_function
 
|NextPage=Documentation/How_Tos/Calc:_ISBLANK_function
 
|NextPage=Documentation/How_Tos/Calc:_ISBLANK_function
 
}}__NOTOC__
 
}}__NOTOC__

Latest revision as of 13:14, 31 January 2024

FORMULA

Returns the formula used in a cell as a text string.

Syntax:

FORMULA(cell)

Returns the formula that is entered in the cell cell as a text string.

Example:

FORMULA(A8)

where A8 contains the formula =SQRT(4), returns the text "=SQRT(4)".



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_FORMULA_function&oldid=259805"
Views
Personal tools
Navigation
Tools
In other languages