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