ISFORMULA (is a formula?)

<< Click to Display Table of Contents >>

ISFORMULA (is a formula?)

Syntax:

ISFORMULA(Reference)

Description:

Returns TRUE if the specified cell contains a formula.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.

Example:

If A1 contains a formula, and C7 contains a fixed number or text string, then:

ISFORMULA(A1) returns TRUE

ISFORMULA(C7) returns FALSE

See also:

ISREF, FORMULATEXT