The Excel ISREF Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isref-Function Search this site: Custom Search

Related Functions:  ISERROR Function ISLOGICAL Function ISNUMBER Function ISTEXT 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:

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. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the results:

Note that, in the above examples:

• The text value "B1", supplied as the argument in cell A4 is a text value, not a reference. However, this text value can be converted to a reference, using the Indirect function, as shown in cell A5.
• In cell A6, 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