FormulaCraft

ISFORMULA

ISFORMULA inspects whether the referenced cell contains a formula rather than a static value or blank, returning TRUE or FALSE accordingly. It is useful for auditing spreadsheets to find cells that should be formulas but were accidentally overwritten with constants.

Excel
=ISFORMULA(A2)
Google Sheets
=ISFORMULA(A2)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Cell DescriptionHasFormula?
Hard-coded 42FALSE
Formula =SUM()TRUE
Text labelFALSE

=ISFORMULA(A2)→FALSE

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Reference the cell you want to inspect (e.g., =ISFORMULA(A2)).
  2. 2Returns TRUE if the cell contains any formula (beginning with =) and FALSE for hard-coded values or blank cells.
  3. 3Use SUMPRODUCT with ISFORMULA over a range to count how many cells contain formulas: =SUMPRODUCT(ISFORMULA(A2:A10)*1).

Need a version for your data?

Try: “Find out which cells in my spreadsheet contain formulas versus hard-coded values”

Related

ISBLANKISTEXTISERROR

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: