MS Excel: ISNA Function (WS)
In Microsoft Excel, the ISNA function can be used to check for a #N/A (value not available) error.
Syntax
The syntax for the ISNA function is:
ISNA( value )
value is the value that you want to test. If value is a #N/A error value , this function will return TRUE. Otherwise, it will return FALSE.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the ISNA function in a worksheet:
Based on the Excel spreadsheet above, the ISNA function would return the following:
| =ISNA(A1) | would return FALSE |
| =ISNA(A2) | would return TRUE |
| =ISNA(A3) | would return FALSE |
| =ISNA(A4) | would return FALSE |
| =ISNA("www.techonthenet.com") | would return FALSE |
| =ISNA(3/0) | would return FALSE |