# How to use ISNA Function in Excel

The Excel ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. You can use the ISNA function with the IF function test for an error and display a friendly message when it appears.

Syntax:= ISNA (value)

The ISNA function syntax has the following arguments:

• Value (required argument) – This is the expression or value that needs to be tested. It is generally provided as a cell address.

Example: Let’s look at some Excel ISNA function examples and explore how to use the ISNA function as a worksheet function in Microsoft Excel:

Example 1:

Syntax:  =ISNA(A2)

Result:

Based on the Excel spreadsheet above, the following ISNA examples would return:

Syntax: =ISNA(A3)
Result: TRUE

Syntax: =ISNA(A4)
Result: FALSE

Syntax: =ISNA(A5)
Result: FALSE

Syntax: =ISNA(A6)
Result: FALSE

Syntax: =ISNA(A7)
Result: FALSE

Syntax: =ISNA(A8)
Result: FALSE

Syntax: =ISNA(A9)
Result: FALSE

Syntax: =ISNA(A10)
Result: FALSE

Example 2:

Suppose we are given the data below:

When we did a VLOOKUP for the given list of fruits, we got the list below:

Syntax: =VLOOKUP(D1,A2:B7,2,0)
Result: #N/A

Syntax: =VLOOKUP(D2,A2:B7,2,0)
Result: 12

Syntax: =VLOOKUP(D3,A2:B7,2,0)
Result: 5

The formula to use will be: