Use ISREF to look at the specified reference and return a logical value of TRUE if it is a reference to another cell; otherwise, the function returns a value of FALSE.

To Calculate



Figure 20-3 illustrates how to use ISREF. You will notice that the function returned a value of TRUE for all cells in the column. This is due to the fact that the value of the argument Value was a reference to a cell within column A.

Get Excel 2000 in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.