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
ReferenceRequired. 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.