FORMULAEXISTS Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

Indicates whether the referenced cell contains a formula.

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.

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

Show: