Checks whether the specified value is a cell reference.

Syntax  Copy Code
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  Copy Code
=ISREF(A1) =ISREF("A1")

See Also

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