Checks if a value is a reference.
Syntaxis
ISREF(value)Argumenten
valuevereist
The value you want to test.
The ISREF function returns TRUE if the provided value is a valid cell reference, and FALSE otherwise. It is commonly used to verify if a formula or a named range points to a valid location in the workbook.
=ISREF(A1)→TRUEA1 is a valid cell reference.
=ISREF("Hello")→FALSEThe text string "Hello" is not a cell reference.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISREF(value) and replace 'value' with the cell or expression you want to check.
Yes, if the named range is defined correctly, ISREF will return TRUE.