The ISREF function shows if the given value inside the function is a cell address. It returns TRUE if the value is a cell address and FALSE if it is any other content. Note: The function is mostly used in macros than in worksheet.
= ISREF(Cell to be tested)
Let us find if the given value is a cell address or not, using the ISREF function, with the help of the below video