The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check if a cell contains a valid reference.

**Syntax**:= ISREF (value)

The ISREF function syntax has the following arguments:

**Values**(required argument) – This is the given value or expression that we wish to test

**Example**: Let’s look at some Excel ISREF function examples and explore how to use the ISREF function as a worksheet function in Microsoft Excel:

**Syntax**: =ISREF(A2)

**Result**:

Based on the Excel spreadsheet above, the following ISREF examples would return:

**Syntax**: =ISREF(“yes”)**Result**: FALSE

**Syntax**: =ISREF(A4)**Result**: TRUE

**Syntax**: =ISREF(Sheet1!A5)**Result**: TRUE

**Syntax**: =ISREF(INDEX(A:A,10))**Result**: TRUE

**Syntax**: =ISREF(“text”)**Result**: FALSE

**Syntax**: =ISREF(A8*A1)**Result**: FALSE

**Syntax**: =ISREF(100)**Result**: FALSE

**Note**:

- When range of cells given as argument, the function only checks the first cell of the array as returns TRUE or FALSE based only on the first cell.
- The function returns TRUE when the reference is inside the inner functions.
- The function returns TRUE when it is used with INDIRECT function as INDIRECT function itself is reference function.