ISREF

Using the Excel ISREF Function

Summary

The Excel ISREF function returns TRUE when a cell contains a reference, and FALSE in all other cases. The function is useful to check if a cell contains a valid reference.

Syntax

=ISREF (value)

Syntax Breakdown

Value
Required. A value that will be tested to determine if it contains a reference.


Usage Notes

ISREF checks if a cell contains a valid reference. If it does, the function returns TRUE and if it does not, the function returns FALSE.

This function is part of a group of Excel functions called IS functions. IS functions return the logical values TRUE or FALSE.