ISREF function
ISREF returns TRUE if a value is a cell reference rather than a plain value. A text address such as "A1" is not a reference.
Example
Read it as a sentence: check whether B1, the Item heading, is a cell reference, which gives TRUE.
Excel shows TRUE
B
1
Item
Items
Syntax
ISREF(value)
-
value(required) - The item to check.
Returns: TRUE if the value is a cell reference.
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 |
|---|---|---|
=ISREF("A1") | FALSE | Text |
=ISREF(5) | FALSE | Number |
=ISREF(Items!B1) | TRUE | Reference |
=ISREF(INDIRECT("Items!B1")) | TRUE | INDIRECT |
=ISREF(Items!B1:C2) | TRUE | Range |
=ISREF(INDIRECT("Nope!A1")) | FALSE | Bad INDIRECT |
=ISREF((Items!B1,Items!C2)) | TRUE | Union |
=ISREF(Items!B1:B2 Items!D1:D2) | FALSE | Empty intersection |
The Items sheet these formulas read
B
C
D
1
Item
Category
Qty
2
Boxer cartridge
Tools
12
Items
Watch out for
- A text address like "A1" is not a reference; use INDIRECT first.
Where it works
- Excel
- ISREF is in every version of Excel from 2007 on.
- 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 .