The ISREF Function is to check whether a value is a reference. The result returns TRUE when it is a reference and returns FALSE when it is not a reference.
Formula:
=ISREF(value)
Explanations:
Value is required, the result returns TRUE when the value is a reference and returns False when it is not a reference.
Example:
=ISREF(A2)
Cell A2 is a reference, so ISREF(A2) returns True.
=ISREF(6)
Number 6 is not a reference, so ISREF(6) returns False.