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

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.