The ISREF function is one of the information functions. It is used to verify if the value is a valid cell reference.
Syntax
ISREF(value)
The ISREF function has the following argument:
Argument | Description |
---|
value | The value that you want to test. The value can be an empty cell, error, logical value, text, number, reference value, or a name referring to any of these. |
Notes
How to apply the ISREF function.
Examples
If the value is a valid reference, the function returns TRUE.

Otherwise the function returns FALSE.
