ISREF Function (Functions in Excel)
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. |
0 comments:
Post a Comment