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.
