Difference between revisions of "Documentation/How Tos/Calc: FORMULA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
Line 3: | Line 3: | ||
== FORMULA == | == FORMULA == | ||
Returns the formula used in a cell as a text string. | Returns the formula used in a cell as a text string. | ||
− | |||
=== Syntax: === | === Syntax: === | ||
Line 9: | Line 8: | ||
:Returns the formula entered in the cell <tt>'''cell'''</tt> as a text string. | :Returns the formula entered in the cell <tt>'''cell'''</tt> as a text string. | ||
− | |||
=== Example: === | === Example: === | ||
<tt>'''FORMULA(A8)'''</tt> | <tt>'''FORMULA(A8)'''</tt> | ||
: where A8 contains the formula <tt>'''=SQRT(4)'''</tt>, returns the text <tt>'''"=SQRT(4)"'''</tt>. | : where A8 contains the formula <tt>'''=SQRT(4)'''</tt>, returns the text <tt>'''"=SQRT(4)"'''</tt>. | ||
− | |||
=== See also: === | === See also: === |
Revision as of 13:06, 19 January 2008
FORMULA
Returns the formula used in a cell as a text string.
Syntax:
FORMULA(cell)
- Returns the formula entered in the cell cell as a text string.
Example:
FORMULA(A8)
- where A8 contains the formula =SQRT(4), returns the text "=SQRT(4)".