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.
Syntax
=ISREF (value)
Arguments
| Arguments | Description | Remarks |
| value | The value to check | Mandatory |
Usage notes
- ISREF is part of a group of functions called the IS functions that all return the logical values TRUE or FALSE.
Availability
Since 2007 for Windows.
Since 2011 for Mac.