ISFORMULA (is a formula?)

<< Click to Display Table of Contents >>

ISFORMULA (is a formula?)

Syntax:

ISFORMULA(Cell)

Description:

This returns TRUE if the given cell contains a formula.

Compatibility notes:

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

Example:

If A1 contains a formula and C7 contains a fixed number or plain text, the following applies:

ISFORMULA(A1) returns TRUE

ISFORMULA(C7) returns FALSE

See also:

ISREF, FORMULATEXT