ISREF

Posted on 18-01-2020 , by: admin , in , 0 Comments

isref

TRUE  =ISREF(A1)
FALSE  =ISREF(B99)
FALSE  =ISREF(Hello)
FALSE  =ISREF(10)
FALSE  =ISREF(NOW())
FALSE  =ISREF(“A1”)
FALSE  =ISREF(XX99)

What Does It Do?
This function shows TRUE if given a cell address, or FALSE for any other type of value. Its a bit of an odd one, and is normally used in macros rather than on the worksheet.

Syntax
=ISREF(ValueToTest)
The ValueToTest can be any type of data, but when used on the worksheet, it cannot be a reference to the contents of another cell, as the reference will itself be evaluated by the function.

Formatting
No special formatting is needed.

Leave a comment