January 22, 2022

How to use ISREF Function in Excel

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:

1. 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.
2. The function returns TRUE when the reference is inside the inner functions.
3. The function returns TRUE when it is used with INDIRECT function as INDIRECT function itself is reference function.
READ:  How to use ISEVEN Function in Excel 