Site icon ExcelNotes

How to Whether a Value is a Reference

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.

Download ISREF Function

Exit mobile version