Exceljet

Quick, clean, and to the point

Excel ISFORMULA Function

Excel ISFORMULA function
Summary 

The Excel ISFORMULA function returns TRUE if 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 

The ISFORMULA function returns TRUE if 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. The ISFORMULA takes one argument, reference, which must be a cell reference.

Examples

If cell A1 contains the formula =2+2, the ISFORMULA function returns TRUE:

=ISFORMULA(A1) // returns TRUE

If cell A1 contains the text "apple", the ISFORMULA function returns FALSE:

=ISFORMULA(A1) // returns FALSE

Count formulas

To count cells in a range that contain formulas, you can use the SUMPRODUCT function like this:

The double negative coerces the TRUE and FALSE results from ISFORMULA into 1s and 0s and SUMPRODUCT returns the sum.

Notes

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.