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

Syntax  Copy Code
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  Copy Code
=ISFORMULA(A1)

See Also

Function Reference
ISTEXT Function
ISNUMBER Function