<< Click to Display Table of Contents >> ISREF (is a valid reference?)

Syntax:

ISREF(Value)

Description:

This returns TRUE if the specified value is a valid cell reference.

Example:

ISREF(A1) returns TRUE

ISREF($A$1) returns TRUE

ISREF(A1:C7) returns TRUE

ISREF("any text") returns FALSE

ISREF(FirstQuarter) returns FALSE until you assign the name "FirstQuarter" to a cell range – from then on, this calculation will also return TRUE.

See also:

ISFORMULA, ISERROR, ISLOGICAL, ISNUMBER, ISTEXT