ISFORMULA Function

Summary

ISFORMULA checks whether a referenced cell contains a formula. If the cell holds a formula, the result is TRUE. If it holds a typed number, text value, or blank, the result is FALSE.

This is especially useful in templates where some columns should always stay automatic. It helps you catch manual overwrites without needing to inspect every cell by hand.

ISFORMULA is especially useful in auditing and template checks. It lets the workbook distinguish between a value that was typed directly and a value produced by logic, which helps when consistency matters across a report or model.

Syntax

=ISFORMULA(reference)

The argument should point to a cell you want to test.

Arguments

• reference - [required] A cell reference, formula, or name that refers to a cell.

ISFORMULA vs Other Functions

Using ISFORMULA

This function is mostly about trust. If a workbook is supposed to calculate a value automatically, ISFORMULA lets you verify that the cell is still formula-driven instead of manually typed over.

Microsoft also notes one useful detail here. A cell can return an error and still count as a formula cell. So if a formula produces #DIV/0!, ISFORMULA still returns TRUE. That helps you separate “the formula is missing” from “the formula exists but is failing.”

Example 1 - Check a formula cell

This is the standard audit check. If A1 contains a formula, ISFORMULA returns TRUE.

That makes the example useful for template reviews, because it helps confirm that a result is still being calculated automatically instead of being typed over manually.

=ISFORMULA(A1)

Example 2 - Catch a hardcoded value

If the cell was typed manually, the result is FALSE. The displayed value might look correct, but ISFORMULA is checking how the cell is built, not only what it shows.

This is what makes the example practical. It can catch manual overrides that are easy to miss if you only look at the numbers.

=ISFORMULA(B2)

Example 3 - Show AUTO or MANUAL

This makes the check easier to read in a working sheet. Instead of TRUE or FALSE, the formula returns a simple label like AUTO or MANUAL.

That helps when the workbook is shared with users who do not want to read raw logical results. The meaning becomes obvious at a glance.

=IF(ISFORMULA(C3),"AUTO","MANUAL")

Example 4 - Keep broken formulas separate from typed values

A broken formula is still a formula. So even if A1 shows an error, ISFORMULA can still return TRUE if the cell contains a formula.

This is important because it separates two different problems: a missing formula and a formula that exists but is failing. Those need different fixes.

=ISFORMULA(A1) // Can return TRUE even if A1 shows an error.

Conclusion Recap

ISFORMULA checks whether a cell contains a formula instead of a hard-typed value. In this lesson, it helped spot manual overrides, formula-driven cells, and cases where a formula still counts as a formula even if it returns an error.

That makes it useful for audits and workbook checks. It helps you see how a sheet is built, not just what value happens to be showing right now.

• Main job: ISFORMULA checks whether a cell contains a formula.
• Best use: Catch manual overrides in calculated ranges.
• Important nuance: A formula that returns an error still counts as a formula.
• Helpful pair: Use FORMULATEXT if you need to inspect the formula itself.