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

Syntax:

ISREF(Reference)

Description:

Returns TRUE if the specified value is a valid reference.

Example:

ISREF(A1) returns TRUE

ISREF($A$1) returns TRUE

ISREF(A1:C7) returns TRUE

ISREF("some text") returns FALSE

ISREF(FirstQuarter) returns FALSE, as long as the name "FirstQuarter" does not exist. As soon as you assign the name "FirstQuarter" to a range of cells, the calculation will return TRUE.

See also:

ISFORMULA, ISERROR, ISLOGICAL, ISNUMBER, ISTEXT