Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Indicates whether the referenced cell contains a local formula.
Syntax
LOCALFORMULAEXISTS (cellref )
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| cellref |
Required |
String |
The cell that you want to check for the presence of a formula. |
Return value
Boolean
Remarks
The LOCALFORMULAEXISTS function returns 1 if the cell contains a local formula; if there is no formula, or if the formula is inherited, it returns 0 (zero).