ISREF
Returns TRUE if the value is a reference.
InformationInformation & Auditing
What it does
Checks if a value is a valid cell reference.
Syntax
ISREF(value)
Arguments
value(value) — Value to check.
Examples
Check Reference
Check if A1 is a ref.
FORMULA
=ISREF(A1)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 |