ISREF(value)

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

valueThe value you want to test.

Remarks

* The "value" can refer to a value, cell reference, formula or a named range.
* You can use the ISFORMULA function to return True or False depending if the cell contains a formula.
* For the Microsoft documentation refer to support.office.com

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


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top