ISFORMULA Function

Excel Functions › Information

Excel 2013+ Information

The Excel ISFORMULA function tests whether a cell contains a formula. It returns TRUE or FALSE, making it the building block of error-proof formulas, validation, and conditional logic.

Quick answer: test a cell:
=ISFORMULA(A2) // TRUE when the cell contains a formula

Syntax

=ISFORMULA(value)
ArgumentDescription
valueRequiredThe value, cell, or expression to test.

How to use it

ISFORMULA returns TRUE when the cell contains a formula, and FALSE otherwise. Wrap it in IF to act on the result, or sum it with SUMPRODUCT to count matches: =SUMPRODUCT(--ISFORMULA(A2:A100)).

The IS family: ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR, ISERROR, ISNA, ISREF, ISFORMULA, ISEVEN, and ISODD each return TRUE or FALSE so you can branch with IF, count with SUMPRODUCT, or drive conditional formatting.

Try it: interactive demo

Live demo

Pick an input and watch the formula and result update.

Result:

Practice workbook

📊
Download the free ISFORMULA practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

What is ISFORMULA good for?
Auditing — highlight every formula cell with conditional formatting =ISFORMULA(A1), or flag where someone typed a number over a formula.
How do I act on the TRUE/FALSE result?
Wrap it in IF: =IF(ISFORMULA(A2), "yes", "no").
Can I count how many cells pass?
Yes: =SUMPRODUCT(--ISFORMULA(range)) counts the TRUEs.

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: ISERROR · ISNUMBER · ISBLANK · IFERROR · NA