ISREF

Returns TRUE if a value is the value is a valid cell reference, and FALSE otherwise.


Sample Usage

ISREF(C5)

Syntax

ISREF(value)

  • value - The value to be checked.

Examples

ISREF(C5) evaluates to TRUE if the cell C5 is a valid cell reference.

 

Notes

  • Providing a string containing a valid cell reference such as ISREF("C5") returns FALSE as the input is a string, and not a reference.