ISREF returns TRUE if the value is a reference : ISREF « Information functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =ISREF(A1). Press Enter to get the result.
Input the formula: -ISREF(A1)
17.13.ISREF
17.13.1.ISREF returns TRUE if the value is a referenceISREF returns TRUE if the value is a reference