Excel Functions

Excel ISREF Function

Pinterest LinkedIn Tumblr

ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check if a cell contains a valid reference.

Purpose of Excel ISREF Function

To test for reference

Return value

This function returns TRUE if the value is a reference.
This function returns FALSE if the value is not a reference.


=ISREF (value)


valueThe value to checkMandatory

Usage notes

  • ISREF is part of a group of functions called the IS functions that all return the logical values TRUE or FALSE.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment