Excel functions / Information

ISREF function

TRUE if the value is a reference to a cell or range.

Syntax

=ISREF(value)

Arguments

When to use it

ISREF is TRUE when its argument is a cell or range reference and FALSE for anything else. Its main use is to check, with INDIRECT, whether text names a real range.

Examples

  1. A cell

    ABC
    1Value
    242TRUE

    In C2: =ISREF(A2) → TRUE

    Try this example

  2. Does this text name a range?

    ABC
    1Range
    2'B9:B12TRUE

    In C2: =ISREF(INDIRECT(A2)) → TRUE

    Try this example

Common mistakes

ISREF 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 ISREF in the playground

Related functions