The Excel ISREF Function

Basic Description

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

The syntax of the function is:

ISREF( value )

Where the supplied 'value' argument can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.


Isref Function Examples

The spreadsheets below show examples of the Excel Isref function.

 Formulas:
  A B
1 =ISREF( B1 )  
2 =ISREF( B1:B2 )  
3 =ISREF( B1:D4 C1:C5 )  
4 =ISREF( "B1" )  
5 =ISREF( INDIRECT( "B1" ) )  
6 =ISREF( B1 * B2 )  
 Results:
  A B
1 TRUE  
2 TRUE  
3 TRUE  
4 FALSE  
5 TRUE  
6 FALSE  

Note that, in the above examples: