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