ISREF

ISREF(value)

Returns the boolean True or False depending if the value is a cell reference.

value

The value you want to test.

REMARKS

* The "value" can refer to a value, cell reference, formula or a named range.
* You can use the IFERROR function to return the value or something else if it evaluates to an error.
* You can use the IFNA function to return the value or something else if it evaluates to #N/A.
* You can use the ISERROR function to return the boolean True or False depending if the value is an error.
* You can use the ISFORMULA function to return True or False depending if the cell contains a formula.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the ERROR.TYPE function to return the number corresponding to a particular error value in a cell.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ISREF(B1) = True	=B2 = 20
2	=ISREF("some text") = False	20
3	=ISREF(4) = False
4	=ISREF(named_range) = True