Documentation/Calc Functions/FORMULA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

FORMULA

Category:

Information

Summary:

Displays the formula of a formula cell as a text string.

Syntax:

FORMULA(Reference)

Returns:

An invalid reference or a reference to a cell with no formula results in the error value #N/A.

Arguments:

Reference is a reference to a cell containing a formula.

Additional details:

Examples:

If cell A8 contains the formula =SUM(1;2;3) then

=FORMULA(A8) returns the text =SUM(1;2;3).

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: