OpenOffice3.org Calc 3. Information Functions

FORMULA(Reference) Function

Returns a text data type. Returns the formula in the cell indicated by the argument of “reference”. If the cell contains a formula not specified, the function returns the error value #N/A. The argument “reference” contains the reference to the cell to be evaluated. The function is used as indicated below.

=FORMULA(A4) Returns the formula found in the cell A4.

 

Back to the list of information functions