OpenOffice3.org Calc 3. Information Functions

ISFORMULA(reference) Function

Returns a logical value. If the cell indicated by the argument “reference” contains a formula, the function returns TRUE, otherwise returns FALSE. The argument “reference” contains the reference to the cell you want to evaluate. For example:

=ISFORMULA(A10) Returns TRUE if contents of cell A10 is a formula.
=ISFORMULA(AMG4) Returns TRUE if contents of cell AMG4 is a formula.

Back to the list of information functions