ISFORMULA in Excel: Detect Formulas Even When Their Results Look Like Constants

=ISFORMULA(reference)

The reference is required. Microsoft permits a cell reference, a formula that supplies a suitable reference, or a name referring to a cell. The examples use simple direct cell references so the target is unambiguous.

A defined name representing a non-reference value is a documented #VALUE! case. A name that happens to look like a cell label is not automatically a reference.

Enter =2+3 in A2 and numeric 5 in A3. Fill down =ISFORMULA(A2) in B2:B3.

Expected results are TRUE and FALSE, although both A cells display 5. ISFORMULA can distinguish a calculation from a manually entered result without relying on the displayed number.

This is useful after copying and pasting values: a value may look unchanged while its formula has been replaced. The function does not restore the original formula or prove that the replacement was unauthorized.

Enter =1/0 in A6, ="" in A7, and leave A8 physically empty. Test each with ISFORMULA in the adjacent column.

Expected flags are TRUE, TRUE and FALSE. A6 contains a formula even though it evaluates to an error. A7 also contains a formula despite its empty-text display. The truly empty A8 has no formula.

Do not interpret TRUE as “healthy calculation” or FALSE as “bad cell.” Some columns are intentionally constants or input fields. The audit rule depends on what each location is meant to contain.

Suppose B12:B15 are intended to contain calculations. In C12 enter and fill down:

=IF(ISFORMULA(B12),"Formula present","Check constant or blank")

For formulas in B12, B13 and B15 with a typed number in B14, the expected labels are Formula present, Formula present, Check constant or blank, and Formula present.

The report points to a structural difference worth inspecting. It does not say which formula should be present, whether the current formula references the correct data, or whether a legitimate manual override was documented elsewhere.

Enter =2+3 in D12 and =2+4 in D13. ISFORMULA returns TRUE for both. If the intended answer is five, only the first is correct, but formula presence cannot make that judgment.

Combine presence checks with expected-value tests, range checks and reference inspection when auditing an important workbook. A workbook can contain formulas in every expected cell and still calculate the wrong result.

In a disposable example, enter =10*2 in F12 and place =ISFORMULA(F12) in G12. Its expected flag is TRUE. Replace F12 with the typed value 20; G12’s expected flag becomes FALSE while the displayed amount stays 20.

This illustrates the distinction without making changes to a real user’s workbook. A persistent change log requires a separate audit mechanism; ISFORMULA shows current state and does not record past edits or who made them.

Microsoft documents #VALUE! when the reference argument has an invalid type, such as a defined name that does not refer to a cell. Keep the target reference explicit and verify name scope if a name-based check fails.

This guide does not claim per-cell behavior for every multi-cell or spilled-array reference, external workbook state, or closed-workbook link. The examples are single-cell controls. Native execution, recalculation timing and platform-specific behavior remain unverified.

• Current documentation: the dedicated Microsoft reference lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Introduced: Microsoft’s alphabetical catalog marks ISFORMULA as introduced in Excel 2013. Exact first build and platform-specific introduction dates remain unverified.
• Last functioning version: unknown; a current help listing is not a last-working-build test.
• Evidence checked: October 15, 2026. Official documentation was freshly retrieved; examples were independently calculated. No native Excel, Mac or web-client execution was performed.

• Microsoft ISFORMULA reference.
• Microsoft function catalog and introduction-marker explanation.
• Editorial testing standards.

Examples use English function names and comma separators. Expected numbers are rounded independent mathematical calculations; documented error expectations are labeled as such. They are not captured Excel output. All illustrative data and policies are fictional.