Exceljet

Quick, clean, and to the point

Excel ISFORMULA Function

Excel ISFORMULA function
Summary 

The Excel ISFORMULA function returns TRUE when a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions.

Purpose 
Test if cell contains a formula
Return value 
TRUE or FALSE
Syntax 
=ISFORMULA (reference)
Arguments 
  • reference - Reference to cell or cell range.
Version 
Usage notes 

You can use the ISFORMULA function to test a cell to see if it contains a formula. ISFORMULA returns TRUE when a cell contains a formula and FALSE if not.

Remember that you can temporarily display all formulas in a worksheet with a keyboard shortcut.

To extract and display a formula, use the FORMULATEXT function.

Notes:

  • ISFORMULA was introduced in Excel 2013.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas