How to Use ISFORMULA Function in Excel
The ISFORMULA function checks if a cell contains a formula. It returns TRUE if there is a formula. It returns FALSE if the cell has text, numbers, or is blank.
What ISFORMULA Does
- Returns TRUE when cell has a formula
- Returns FALSE when cell has a value or is blank
- Works even if formula shows an error
Syntax
=ISFORMULA(reference)
reference is the cell you want to check (like A1).
Basic Examples
| Cell Content | Formula | Result |
|---|---|---|
| =TODAY() | =ISFORMULA(A1) | TRUE |
| 7 | =ISFORMULA(A1) | FALSE |
| Hello | =ISFORMULA(A1) | FALSE |
| #DIV/0! | =ISFORMULA(A1) | TRUE |
Using ISFORMULA with IF
Tip: Use ISFORMULA with IF to show custom messages.
Show Formula or Value Message
=IF(ISFORMULA(A1), "Has Formula", "No Formula")
- Cell has formula → “Has Formula”
- Cell has value → “No Formula”
Show the Actual Formula
=IF(ISFORMULA(A1), FORMULATEXT(A1), "No Formula")
- Shows the formula text if cell has one
- Shows “No Formula” if cell has a value
Count Cells with Formulas
Count Formulas in a Range
=SUMPRODUCT(--ISFORMULA(A1:A10))
This counts how many cells in A1:A10 have formulas.
Highlight Formula Cells
Using Conditional Formatting
- Select your range (like A1:D10)
- Go to Home → Conditional Formatting
- Choose New Rule
- Select Use a formula
- Enter:
=ISFORMULA($A1) - Choose formatting (yellow fill, etc.)
- Click OK
All cells with formulas will be highlighted.
When to Use ISFORMULA
- Audit spreadsheets – find all formula cells
- Data validation – ensure users enter data, not formulas
- Documentation – list all formulas in a sheet
- Quality control – verify calculation cells have formulas
Quick Comparison
| Function | What it Checks | Returns |
|---|---|---|
| ISFORMULA | Has formula? | TRUE/FALSE |
| ISERROR | Has error? | TRUE/FALSE |
| FORMULATEXT | Formula text | Formula string |
Best Practice: Use ISFORMULA to quickly audit complex spreadsheets.
Summary
ISFORMULA is simple but very useful. It tells you exactly which cells have formulas. Use it to audit spreadsheets, create documentation, or apply special formatting to calculation cells. Combine it with IF and FORMULATEXT for powerful formula management.
