ISFORMULA

Checks whether the cell identified by the specified reference contains a formula.

Syntax

ISFORMULA( Reference r ) → Logical

Parameters

r

Required. The reference to the cell to test.

Remarks

If r references a cell containing a formula, the function returns TRUE; otherwise, FALSE. If r is not a valid cell reference, the function returns the #VALUE! error value.

Example

Formula

=ISFORMULA(A1)

See Also

Function Reference
ISTEXT Function
ISNUMBER Function