ISREF

Definition: ISREF is a function that returns TRUE if a value is a reference, and FALSE if it is not.

Syntax: =ISREF(value)

Situation: This formula is appropriate when you need to check if a value is a reference.

Example: If you want to check if cell A1 contains a reference, the formula =ISREF(A1) will return TRUE if it contains a reference, and FALSE if it does not.