ISREF Function

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)

Video Tutorial:

Let us find if the given value is a cell address or not, using the ISREF function, with the help of the below video

Learn MS Excel

Ask Questions

Ask Question