ISFORMULA Function in Google Sheets: Formula, Examples & Troubleshooting

=ISFORMULA(cell)

The argument is required. Google allows a cell reference, a name associated with a cell, or a range. For a range, the documented result concerns its first cell, not whether any or all cells contain formulas. Other values return FALSE under the reference’s description. Google ISFORMULA documentation.

For an audit, pass an actual reference such as B2 rather than the text "B2". A quoted address is a text value, not the referenced cell.

Create this table, entering the formula expressions as formulas:

1. Put Has formula? in C1.
2. Put =ISFORMULA(B2) in C2 and fill down through C4.
3. Compare C2:C4 with the expected results TRUE, FALSE, TRUE.
4. Inspect B3 if this particular model requires every amount row to contain a calculation.

All three amounts display 200 under ordinary numeric formatting. That equality does not make their definitions equivalent. If upstream inputs change later, the typed constant has no formula to recompute.

The test is evidence for review, not proof that a constant is wrong. A model can legitimately contain manually entered amounts. Decide which cells are expected to be formulas before flagging exceptions.

With the same setup:

=ISFORMULA(B2:B4)

The expected result is TRUE because B2, the first cell, contains a formula. The FALSE case at B3 is not summarized by this call. Likewise, =ISFORMULA(B3:B4) is expected to return FALSE even though B4 contains a formula.

For a row-by-row audit, use individual references and fill down as shown above. To count the TRUE flags after calculating C2:C4, use =COUNTIF(C2:C4,TRUE), with expected result 2. This makes the inspected cells visible and avoids mistaking one range-level Boolean for a full inventory.

Google also supplies a MAP/LAMBDA-based formula-count example in its named-functions guide. A helper column is often easier to review when the goal is to find the particular exception rather than only obtain a count.

Put this in D2 and fill down:

=IF(ISFORMULA(B2),"Calculated","Review constant")

The expected labels are Calculated, Review constant, and Calculated. Rename the second label to match your policy; “Entered value” may be more appropriate when constants are expected.

For visual highlighting, select B2:B4, open Format → Conditional formatting, choose Custom formula is, and use =ISFORMULA(B2). Apply a restrained fill color. The reference starts at the top-left cell of the selected range and remains relative, so each row checks its corresponding amount. Google’s conditional-formatting instructions explain custom formulas and relative versus absolute references.

Highlighting formulas identifies where calculation logic lives. It does not lock those cells, protect a file, or authorize anybody to edit it.

A genuinely empty cell contains no formula and is expected to return FALSE. A cell deliberately entered as ="" contains a formula even though its displayed output is empty; it is expected to return TRUE from the formula-presence contract.

Similarly, =0 is a formula while a typed 0 is a constant. Comparing only visible values cannot distinguish those definitions. If a formula’s result is copied and pasted as a value, the destination definition is a value rather than the original formula; Google documents the distinction in its paste-special options.

For outputs that spill from array formulas, inspect the actual formula location and do not use this guide as a claim that every generated output cell has an independently stored formula. Spill-cell behavior was not tested here.

• TRUE does not mean correct: A formula may use the wrong range or compute the wrong business rule. ISFORMULA checks presence, not correctness.
• An entire range returns one Boolean: Only the first cell is inspected under Google’s documented range rule.
• A numeric amount returns FALSE: A typed number is not a formula merely because it is numeric.
• A blank-looking cell returns TRUE: Inspect its definition; a formula can produce an empty-looking result.
• You need the actual expression: Use FORMULATEXT under its own contract, rather than treating this Boolean as the expression itself.

Google currently documents ISFORMULA. Its first introduction and retirement or last-working version were not established. The guide does not assert another spreadsheet engine’s range behavior, exact invalid-reference error tokens, or native array-spill detection results.

See IF for review labels, COUNTIF for counting the helper flags, FORMULATEXT for inspecting expressions, and ISBLANK for the separate question of blankness.

First-party references reviewed October 17, 2026: ISFORMULA, named-function examples, conditional formatting, and paste special.