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 following spreadsheet shows examples of the Excel Isref function:

 Formulas:
 AB
1=ISREF( B1 ) 
2=ISREF( B1:B2 ) 
3=ISREF( B1:D4 C1:C5 ) 
4=ISREF( "text" ) 
5=ISREF( B1 * B2 ) 
 Results:
 AB
1TRUE 
2TRUE 
3TRUE 
4FALSE 
5FALSE 

Note that, in cell A5, the expression B1 * B2 returns a value (the product of the values in two cells), and so in this case, the Isref function returns FALSE.


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