Quick Navigation

ISFORMULA Function

Excel 2013+

Summary

The ISFORMULA function determines if a cell contains a formula rather than a static value. It returns TRUE for cells with formulas (including error-producing formulas) and FALSE for cells with direct values, text, or numbers.

Syntax

ISFORMULA(reference)

Parameters

Parameter	Type	Required	Description
reference	`Reference`	Yes	The cell, range, or named range to check if it contains a formula

Using the ISFORMULA Function

ISFORMULA is perfect for creating dynamic dashboards, validating formula usage, and building self-auditing spreadsheets. Use it to highlight formula cells, count formulas in ranges, or create conditional formatting rules that respond to formula presence.

Common ISFORMULA Examples

Basic Formula Detection

=ISFORMULA(A1)

Returns TRUE if A1 contains any formula, FALSE if it contains a static value.

Count Formulas in Range

=SUMPRODUCT(--ISFORMULA(B1:B10))

Counts how many cells in B1:B10 contain formulas.

Highlight Formula Cells

=ISFORMULA(C1)

Use in Conditional Formatting to highlight cells containing formulas.

Error Formula Detection

=ISFORMULA(D1)

Returns TRUE even if D1 shows #DIV/0! but contains =1/0 formula.

Frequently Asked Questions

Yes, ISFORMULA returns TRUE for any cell containing a formula, even if it displays an error like #DIV/0! or #VALUE!.

Yes, it works with ranges. Array formulas or SUMPRODUCT can aggregate results across ranges.

ISFORMULA returns #VALUE! error if the reference is invalid (like a named range that doesn't reference a cell).

Common Errors and Solutions

#VALUE! error

Cause: Reference argument is not a valid cell reference or named range

Solution: Ensure reference points to actual cells or valid named ranges

FALSE for error cells

Cause: Cell appears to show error but actually contains static error text

Solution: Verify cell truly contains formula by editing (F2)

Notes

ISFORMULA distinguishes formulas (=TODAY()) from values (5, 'text')
Available only in Excel 2013 and later versions
Does NOT check formula results, only formula presence
Perfect for Data Validation rules and dynamic dashboards

Compatibility

Available in: Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365, Excel Online

Not available in: Excel 2010, Excel 2007, Excel 2003, Earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2013+