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 is the value or expression to be tested.


Isref Function Examples

The spreadsheets below show several examples of the Excel Isref function:

 Formulas:
 AB
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:
 AB
1TRUE 
2TRUE 
3TRUE 
4FALSE 
5TRUE 
6FALSE 

Note that, in the above examples:


Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.