ISFORMULA function
ISFORMULA returns TRUE if a cell contains a formula rather than a typed value, and FALSE otherwise. It needs a cell reference, not a plain value.
Example
Read it as a sentence: check whether F5 contains a formula, which gives TRUE.
Excel shows TRUE
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Syntax
ISFORMULA(reference)
-
reference(required) - The cell to check.
Returns: TRUE if the cell holds a formula.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISFORMULA(A1) | TRUE | Own cell |
=ISFORMULA(Data!F5) | TRUE | Formula |
=ISFORMULA(Data!F8) | TRUE | Formula "" |
=ISFORMULA(Items!B1) | FALSE | Constant |
=ISFORMULA(Data!F1) | FALSE | Blank |
=ISFORMULA(Data!F5:F6) | TRUE | Range |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
6
Hello World
7
0
8
=""
Data
The Items sheet these formulas read
B
1
Item
Items
Watch out for
- Needs a cell reference, not a value.
Where it works
- Excel
- ISFORMULA arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .