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.

Formula:


= 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