ISREF Function in Excel – Test if the value is reference

ISREF Function in Excel tests if a supplied value is a reference. If the supplied value is reference then ISREF Function returns TRUE, if not the function returns FALSE.

Syntax of ISREF Function in Excel:

ISREF(value)

Where value argument is the value or expression to be tested.

 

Example of ISREF Function in Excel:

Formula

ISREF Function in Excel 1

  • The above example takes up values as input and returns TRUE only if the supplied value is reference, otherwise the function returns FALSE

Result:

ISREF Function in Excel 2

previous-small ISREF Function in Excel                                                                                                                next_small ISREF Function in Excel