The ISREF function tests if a supplied value is a reference. If so, the function returns TRUE; Otherwise it returns FALSE.

Syntax

=ISREF(value)

Arguments

Argument Description
value The value argument can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.

Examples

  A B C
1 Formula Result Notes
2 =ISREF(B1) TRUE  
3 =ISREF(B2:B12) TRUE  
4 =ISREF(B2:B12,D4:D20) TRUE  
5 =ISREF(“B6”) FALSE The argument in cell A5 is a text value, not a reference
6 =ISREF(INDIRECT(“B6”)) TRUE Text value can be converted to a reference, using the INDIRECT function
7 =ISREF(B1*B2) FALSE