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
- The above example takes up values as input and returns TRUE only if the supplied value is reference, otherwise the function returns FALSE