How to use the ISFORMULA Function in Excel

Using the Excel ISFORMULA Function

Summary

The Excel ISFORMULA function will return TRUE when a supplied a cell contains a formula and FALSE when it does not. The function will return TRUE as long as a cell contains a formula, regardless of the formula's output or error conditions.

Syntax

=ISFORMULA (reference)

Syntax Breakdown

Reference
Required. A reference to a cell or range of cells.

Usage Notes

ISFORMULA tests a cell to see if it contains a formula. If the cell contains a formula, the function returns TRUE. If a formula is not found, the function returns FALSE.

ISFORMULA can be used to identify if a cell contains a formula. To extract and view a formula, use the FORMULATEXT function.