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:
Based on the Excel spreadsheet above, the following ISREF examples would return:
- 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.