ISREF

Name

Is reference

Description

Tests whether a value is a cell reference.

Syntax

ISREF(value)

Remarks

Returns 1 (True) if the value argument refers to a cell reference. Returns 0 (False) if the value argument refers to a value that is not a cell reference.

Use the ISREF function to determine whether a value contains a reference to a cell.

Data Type

Accepts any data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

ISREF(R1C2) = 1 (True)
ISREF(A3) = 1 (True)
ISREF(12) = 0 (False)