MS Excel: IsRef Function
In Excel, the IsRef function can be used to check for a reference.
The syntax for the IsRef function is:
IsRef( value )
value is the value that you want to test. If value is a reference, this function will return TRUE. Otherwise, it will return FALSE.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=IsRef(B1) would return TRUE =IsRef(B2) would return TRUE =IsRef(A1+A2) would return FALSE =IsRef(3+4) would return FALSE =IsRef("techonthenet") would return FALSE