Excel functions / Information

ISFORMULA function

TRUE if the cell holds a formula.

Syntax

=ISFORMULA(reference)

Arguments

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

  1. A formula

    ABCDE
    1QtyPriceTotal
    225=A2*B2TRUE

    In E2: =ISFORMULA(C2) → TRUE

    Try this example

  2. A typed number where a formula should be

    ABCDE
    1QtyPriceTotal
    22510FALSE

    In E2: =ISFORMULA(C2) → FALSE

    Try this example

Common mistakes

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.

Translate a whole formula

Try ISFORMULA in the playground

Related functions