Using the Excel ISREF Function


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.


=ISREF (value)

Syntax Breakdown

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.