Using the Excel ISFORMULA Function


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.


=ISFORMULA (reference)

Syntax Breakdown

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.