Excel functions / Information
ISFORMULA function
TRUE if the cell holds a formula.
Syntax
=ISFORMULA(reference)
Arguments
reference: The cell to check.
When to use it
ISFORMULA is TRUE when a cell holds a formula and FALSE when it holds a typed value. In a model, it is the quick way to find a hard-coded number where a formula should be, often with conditional formatting.
Examples
A formula
A B C D E 1 Qty Price Total 2 2 5 =A2*B2 TRUE In E2:
=ISFORMULA(C2)→ TRUEA typed number where a formula should be
A B C D E 1 Qty Price Total 2 2 5 10 FALSE In E2:
=ISFORMULA(C2)→ FALSE
Common mistakes
- A value, not a reference. ISFORMULA needs a cell: ISFORMULA(A2*2) is #VALUE!.
ISFORMULA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ISFORMULA
- Danish: ER.FORMEL
- Dutch: ISFORMULE
- Finnish: ONKAAVA
- French: ESTFORMULE
- German: ISTFORMEL
- Hungarian: KÉPLET
- Italian: VAL.FORMULA
- Norwegian: ERFORMEL
- Polish: CZY.FORMUŁA
- Portuguese (Brazil): ÉFÓRMULA
- Portuguese (Portugal): É.FORMULA
- Russian: ЕФОРМУЛА
- Spanish: ESFORMULA
- Swedish: ÄRFORMEL
- Turkish: EFORMÜLSE
Try ISFORMULA in the playground
Related functions
- FORMULATEXT: Shows the formula in a cell as text.
- ISNUMBER: TRUE if the value is a number (dates count too).
- CELL: Tells you something about a cell: its address, row, column, contents, number format or the type of value in it.