Excel ISREF Function
Syntax
=ISREF(value)
Checks if the value, cell reference or formula returns a cell reference .
Returns TRUE or FALSE
Returns TRUE if the result is a cell reference (cell address).
Surprisingly: Some results that reference invalid cell addresses return a TRUE Value.
Rows 6 and 7 below reference invalid cell or range names but return TRUE.
But cell reference XY13 (below) is recognized as invalid (columns only go up to IV).
Examples
| A | B | C | D | E | F | G |
| 2 | Cell references | Returned Values | ||||
| 3 | cell D3 is blank | =ISREF(D3) | TRUE | |||
| 4 | 100 | 100 | =+B4=C4 | =ISREF(D4) | TRUE | |
| 5 | ||||||
| 6 | =BogusRangeNme | =ISREF(D6) | TRUE | |||
| 7 | =B7*#REF! | =ISREF(D7) | TRUE | |||
| 8 | ||||||
| 9 | Formulas | |||||
| 10 | 12 | 2 | =ISREF(B10/D10) | FALSE | ||
| 11 | y13 | =ISREF(INDIRECT(B11)) | TRUE | |||
| 12 | xy13 | =ISREF(INDIRECT(B12)) | FALSE | |||
| 12 | ||||||
| 14 | Value | |||||
| 15 | =ISREF("a12") | FALSE | ||||
| 16 | =ISREF(A12) | TRUE |