ISREF Function
Tests whether a value is a reference.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| value | The value, cell reference, or formula result to test. | Required |
Basic Example
Test a direct cell reference
=ISREF(A1)A1 is a cell reference, so ISREF returns TRUE.
Advanced Examples
Example 1: A text address is not a reference
Passing the string "A1".Show that text naming a cell is not a reference
=ISREF("A1")Example 2: Reference-returning functions
Convert a text address into a real reference.INDIRECT returns a reference, so ISREF is TRUE
=ISREF(INDIRECT("B2"))How ISREF Works
ISREF returns TRUE if the value is a cell or range reference, or the result of a function that returns a reference such as INDIRECT or OFFSET. Plain values, text, and most value-returning functions return FALSE.
Important Notes & Limitations
A text string like "A1" is not a reference even though it names one.
Most functions return values, not references, so ISREF returns FALSE for them.
Rarely needed outside advanced formula validation.
Common Errors & Fixes
FALSE for a text address'A1' is text, not a reference.Fix: Use INDIRECT to turn a text address into a real reference.
Unexpected TRUEA function like OFFSET returns a reference.Fix: Expected behavior; ISREF detects reference-returning functions.
Download Practice File
ISREF
isrefPractice ISREF with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the ISREF function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps