ISFORMULA function

Returns TRUE if a cell contains a formula, FALSE if it's a static value; use it to audit which cells drive calculations versus hard-coded data.

=ISFORMULA(reference)

Generate a ISFORMULA formula

Describe what you need. The generator will reach for ISFORMULA where ISFORMULA is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How ISFORMULA reads its arguments
referencerequiredISFORMULA →
ArgumentRequiredDescription
referenceRequiredA cell or cell range reference to check. Must be a valid cell address; using a text string like "A1" instead of a cell reference will produce #VALUE!.

Returns

Boolean: TRUE if the cell contains a formula, FALSE if it contains only a static value.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Check if a billing rate is hardcoded or calculated

CustomerPlanMRRSignup DateChurn Date
AlicePro992024-01-15
BobBasic292024-02-202024-08-10
CarolPro992024-01-01
=ISFORMULA(C2)

Result: FALSE

Cell C2 contains the numeric value 99 entered directly—no formula. ISFORMULA returns FALSE because the cell holds only static data. This is typical for manually entered subscription rates that don't change based on other values.

2. Verify that an annual revenue calculation uses a formula

CustomerPlanMRRAnnual RevenueSignup Date
AlicePro9911882024-01-15
BobBasic293482024-02-20
CarolPro9911882024-01-01
=ISFORMULA(D2)

Result: TRUE

Cell D2 contains the formula =C2*12 (displaying as 1188). Since a formula is present, ISFORMULA returns TRUE. Use this to verify that derived metrics like annual revenue are calculated, not manually typed, which ensures consistency when source values change.

3. Create an audit column to identify formula-based vs. hardcoded rows

CustomerPlanMRRAuditSignup Date
AlicePro99Hardcoded2024-01-15
BobBasic29Hardcoded2024-02-20
CarolPro99Hardcoded2024-01-01
=IF(ISFORMULA(C2),"Formula-based","Hardcoded")

Result: Hardcoded

This combines ISFORMULA with IF to create an audit trail showing which MRR entries are static values versus formulas. Useful for billing teams managing mixed scenarios: some plans with fixed rates (hardcoded) and others with tiered pricing (formula-based).

Common errors

Which ISFORMULA error are you seeing?
ISFORMULA returned an error#VALUE!
Remove the quotes. Use =ISFORMULA(C2) to reference the cell directly, not =ISFORMULA("C2") which passes a text string.
#REF!
Restore the deleted row or column, or update the formula to reference a valid cell that still exists in the sheet.
#NAME?
Check the spelling: it should be exactly =ISFORMULA, not ISFORMULA2. If unavailable, confirm your application supports it; ISFORMULA is standard in Excel 2013+ and Google Sheets.
ErrorWhy it happensHow to fix it
#VALUE!Passing a text string literal instead of a cell reference, such as =ISFORMULA("C2") instead of =ISFORMULA(C2).Remove the quotes. Use =ISFORMULA(C2) to reference the cell directly, not =ISFORMULA("C2") which passes a text string.
#REF!The referenced cell's row or column has been deleted, breaking the reference (e.g., deleting column C when your formula was =ISFORMULA(C2)).Restore the deleted row or column, or update the formula to reference a valid cell that still exists in the sheet.
#NAME?The function name is misspelled (e.g., =ISFORMULA2(C2) or =ISFORMULAS(C2)), or ISFORMULA is not available in your spreadsheet version.Check the spelling: it should be exactly =ISFORMULA, not ISFORMULA2. If unavailable, confirm your application supports it; ISFORMULA is standard in Excel 2013+ and Google Sheets.

Tips and when to use something else

  • ISFORMULA returns TRUE for any formula, from simple (=5+5) to complex (=IF(ISNUMBER...)). It doesn't distinguish complexity—only presence. Use TYPE() if you need information about what value the formula produces.
  • Combine ISFORMULA with IF() to create audit columns: =IF(ISFORMULA(A1),"Auto-calculated","Manual entry") helps track data integrity across your billing records.
  • When you need to see what formula is in a cell, not just whether one exists, use FORMULATEXT() instead of ISFORMULA: =FORMULATEXT(C2) displays the actual formula text.
  • ISFORMULA is unaffected by row/column visibility or filters. Even if rows are hidden, ISFORMULA returns the same result, making it reliable for audits on filtered datasets.

Related functions

FORMULATEXTFORMULATEXT returns the exact formula text from a referenced cell, allowing you to view or audit spreadsheet logic as a plain-text string.ISBLANKISBLANK returns TRUE if a cell is completely empty, FALSE if it contains any value or formula, and propagates errors.ISERRORISERROR returns TRUE if a value is an error like #N/A or #REF!, FALSE otherwise, enabling error detection and handling.TYPEReturns a number indicating the data type of a value: 1 for numbers, 2 for text, 4 for logical values, 16 for errors, and 64 for arrays.

Frequently asked questions

Can ISFORMULA tell me what formula is actually in the cell?
No, ISFORMULA only returns TRUE or FALSE. Use FORMULATEXT(reference) to retrieve the actual formula text as a string. For example, =FORMULATEXT(C2) returns "=C1*12" if that's what C2 contains.
Does ISFORMULA work with references to other sheets?
Yes, you can use ISFORMULA with sheet references like =ISFORMULA(Sheet2!A1). This is useful when auditing formulas across multiple sheets in the same workbook.
If a formula produces an error like #DIV/0!, will ISFORMULA still return TRUE?
Yes. ISFORMULA returns TRUE if the cell contains a formula, regardless of whether that formula evaluates to an error, a number, or text. The formula's result doesn't matter—only its presence.
What's the difference between ISFORMULA and ISBLANK?
ISFORMULA checks whether a cell contains a formula (returns TRUE/FALSE). ISBLANK checks whether a cell is empty (returns TRUE/FALSE). They answer different questions: ISFORMULA detects formulas, while ISBLANK detects empty cells.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17