ISREF

Checks whether the specified value is a cell reference.

Syntax

ISREF( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is a cell reference, returns TRUE. If x is not a cell reference, including when x is an error, returns FALSE. Note that this function does not propagate error values. Also note, that unlike most other functions, when given a cell reference this function does not examine the value of the referenced cell.

Example

Formula

=ISREF(A1)
=ISREF("A1")

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISNA Function
ISNONTEXT Function
TYPE Function