FORMULAEXISTS Function

Indicates whether the referenced cell contains a formula.

Syntax

FORMULAEXISTS (cellref )

Parameters

Name Required/Optional Data Type Description
cellref
Required
String
The cell that you want to check for the presence of a formula.

Remarks

The FORMULAEXISTS function returns 1 if the cell contains a formula; if it does not contain a formula, it returns zero (0).