ISNA function in Excel

Using Excel documents shared from friends or on the internet, you sometimes come across ISNA () combined with other functions like VLOOKUP () and IF (). You wonder why they use ISNA () function so?

ISNA function in Excel Picture 1

The following article will guide the syntax and usage of the ISNA () function in Excel.

Description

The ISNA () function helps you identify if the value is # N / A (the value is not available).

The ISNA () function returns TRUE if the cell contains # N / A values. Returns FALSE if the cell does not contain the value # N / A.

This function is often used in conjunction with VLOOKUP () and IF () functions.

Syntax

= ISNA (value)

With value as the value of the cell, the expression you need to check.

For example

Simple example is as follows: You have cell B6 with a value of 35, cell B7 has the value # N / A, so when testing cell B6 and cell B7 with the ISNA function will have different results:

ISNA function in Excel Picture 2

You can use the value as an expression, for example VLOOKUP expression as the example below:

ISNA function in Excel Picture 3

Explain the above example:

1. The VLOOKUP () function did not find the value of L11 in the Price Code table, so the result is # N / A so the ISNA () function will return TRUE.

2. VLOOKUP () finds the value of L13 in the Price Code table so the result returned will be the value corresponding to the L13 code. So the ISNA () function will return the FALSE value because its value is different from # N / A.

In addition to combining with VLOOUP function, you can combine with IF function to get more complete results.

Kareem Winters

Update 19 May 2020

You should read it

May be interested

Instructions on how to draw organizational structure diagram in Word
to draw an organization chart in word you can use one of two ways: using smartart and using the shapes tool. using smartart will help you draw an organization chart faster than using the shapes tool.
How to write vertically, rotate text vertically in Word
according to some requirements, you need to write vertical letters in word, but you do not know how to write vertical letters? to be able to write vertically in word, there are many ways, you can refer to the ways guided in this article.
How to delete the underlined red mark in Word
the red, blue lines under the words in a word document are features to detect spelling and grammatical errors. but this feature does not apply to vietnamese, so when you type vietnamese with diacritics, a red dot will appear.
Warning of duplicate values in Excel - Warning of data duplication
microsoft excel gives you lots of useful features to help your data entry work best. one of those features is the duplicate value warning feature.
Save, work and share files online in Excel 2013
with excel 2013 you can quickly save and share files online with onedrive or office 365 sharepoint services. people can work together on spreadsheets easily without sending back and forth to summarize and edit.
Instructions to delete blank lines (blank lines) in Excel
the data in the excel document file that you are referencing has many blank cells and blank lines that cause the excel file to reverse the data position. you want to delete all the empty cells in that data file but if you delete each cell one by one, it will take a lot of time.