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).