Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isref-Function

The Excel ISREF Function

Related Functions:
ISERROR
ISLOGICAL
ISNUMBER
ISTEXT
ISFORMULA

Function 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:
  A B
1 =ISREF( B1 )  
2 =ISREF( B1:B2 )  
3 =ISREF( B1:D4 C1:C5 )  
4 =ISREF( "text" )  
5 =ISREF( B1 * B2 )  
 Results:
  A B
1 TRUE  
2 TRUE  
3 TRUE  
4 FALSE  
5 FALSE  

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.


For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions