# Excel ISNA Function

This post will guide you how to use Excel ISNA function with syntax and examples in Microsoft excel.

### Description

The Excel ISNA function used to check if a cell contains the #N/A error, if so, returns TRUE; otherwise, the ISNA function returns FALSE. The #N/A error will be returned when a value is not available to your Excel formula.

The ISNA function is a build-in function in Microsoft Excel and it is categorized as an Information Function.

The ISNA function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

### Syntax

The syntax of the ISNA function is as below:

`=ISNA(value)`

Where the ISNA function argument is:

• Value – This is a required argument. The value that you want to test.

### Excel ISNA Function Example

The below examples will show you how to use Excel ISNA Function to text if a cell contain the #N/A error. For examples, if the Cell B1 contains #N/A error, the following ISNA formula will return TRUE.

`= ISNA(B1)`

### Related Functions

• Excel ISNUMBER Function
The Excel ISNUMBER function returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE.The syntax of the ISNUMBER function is as below:=ISNUMBER (value)
• Excel ISERR Function
The Excel ISERR function returns TRUE if the value is any error value except #N/A.The syntax of the ISERR function is as below:= ISERR (value)…
• Excel ISError Function
The Excel ISERROR function used to check for any error type that excel generates and it returns TRUE for any error type, such as: #N/A, #VALUE!,#REF!,#DIV0!, #NAME?, etc. The syntax of the ISERROR function is as below:= ISERROR (value)…
• Excel ISBlank Function
The Excel ISBLANK function returns TRUE if the value is blank or null.The syntax of the ISBLANK function is as below:=ISBLANK (value)…
• Excel ISTEXT Function
The Excel ISTEXT function used to check if a value is text. If so, returns TRUE; if the text is not text, the function will return FALSE. The syntax of the ISTEXT function is as below:=ISTEXT(value)…
• Excel ISNONTEXT Function
The Excel ISNONTEXT function used to check if a value is text. If so, returns FALSE; if the text is not text, the function will return TRUE. The syntax of the ISNONTEXT function is as below:=ISNONTEXT (value)…
• Excel ISREF Function
The Excel ISREF function used to check if a value is a valid reference. If so, returns TRUE; if the value is not a reference, the function will return FALSE. The syntax of the ISREF function is as below:=ISREF(value)…

### More Excel ISNA Function Examples

• Excel Vlookup Return True or False
you can use the VLOOKUP function to look for a value in a column in a table and then returns TRUE from a given column in that table if it finds something. If it doesn’t, it returns FALSE …
Related Posts

How to Count Cells Not Equal to One of Many Things in Excel

This post will guide you how to count the number of cells that are not equal to many things in a given range cells using a formula in Excel 2013/2016. You can easily to count cells not equal to a ...

How To Align Duplicate Values within Two Columns in Excel

This post will guide you how to align duplicate values within two columns based on the first column in your worksheet in Excel. How do I use an formula to align two columns duplicate values in Excel. Aligning Duplicate Values ...

How to Highlight Cell if Same Value Exists in Another Column in Excel

This post will guide you how to highlight cell if same value exists in another column in Excel. How do I highlight cell if value is present in any cell in another column in Excel 2013/2016. Highlight Cell If Same ...

Find Unique Values in Two Columns

This post will guide you how to find unique values in two columns in Excel. How do I find unique values between two columns with a formula in Excel. How to display only unique values from two columns in Excel. ...

Find Missing Numbers in a Sequence in Excel

This post will guide you how to find missing numbers in a sequence with a formula in Excel. How do I identify missing numbers in a consecutive series in Excel. How to find missing serial number in Excel 2013/2016. Find ...

Sidebar