{"id":96488,"date":"2021-06-18T09:00:17","date_gmt":"2021-06-18T03:30:17","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=96488"},"modified":"2021-06-14T12:35:52","modified_gmt":"2021-06-14T07:05:52","slug":"isna-in-excel","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/","title":{"rendered":"ISNA in Excel"},"content":{"rendered":"

What is ISNA in Excel?<\/h3>\n

ISNA is one of the built-in excel functions, which returns true when there is a #N\/A error in the cell. ISNA function is also known as information function. <\/span>You can utilize the ISNA function along with the IF function test to display a message when the error appears in those cells.\u00a0<\/span><\/p>\n

Syntax of Excel ISNA<\/h3>\n

ISNA (value)<\/span><\/p>\n

Value<\/strong> – This is an expression where you enter the cell value that needs to be evaluated and tested. This is a required parameter.<\/span><\/p>\n

If the value that you enter is #N\/A error value, then it returns true or else it returns false.<\/span><\/p>\n

Let\u2019s look at a sample:<\/span><\/p>\n

\"ISNA<\/a><\/p>\n

The G2 cells return true because the value in the F2 cell is #N\/A error. <\/span>The formula applied in the G2 cell is shown in the formula bar.<\/span><\/p>\n

Understanding ISNA in Excel<\/h3>\n\n\n\n\n\n\n\n\n\n
Error<\/b><\/td>\nResult<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
#N\/A<\/span><\/td>\nTrue<\/span><\/td>\nIf the cell contains #N\/A error, then the formula returns true.<\/span><\/td>\n<\/tr>\n
#DIV\/0!<\/span><\/td>\nFalse<\/span><\/td>\nIf the cell contains #DIV\/0! error, then the formula returns false.<\/span><\/td>\n<\/tr>\n
#NAME?<\/span><\/td>\nFalse<\/span><\/td>\nIf the cell contains #Name? error, then the formula returns false.<\/span><\/td>\n<\/tr>\n
#NUM!<\/span><\/td>\nFalse<\/span><\/td>\nIf the cell contains #NUM! error, then the formula returns false.<\/span><\/td>\n<\/tr>\n
#REF!<\/span><\/td>\nFalse<\/span><\/td>\nIf the cell contains #REF! error, then the formula returns false.<\/span><\/td>\n<\/tr>\n
#NULL!<\/span><\/td>\nFalse<\/span><\/td>\nIf the cell contains #NULL! error, then the formula returns false.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"isna<\/a><\/p>\n

From this, we can conclude that the ISNA function returns true only when the cells hold #N\/A error.<\/span><\/p>\n

ISNA is one of the inbuilt functions and it is applicable in all versions of excel. (Excel 2011 for Mac, Excel for Office 365, Excel XP, Excel 2000, Excel 2003, Excel 2007, Excel 2013, Excel 2016, Excel 2019)<\/span><\/p>\n

Excel ISNA Function<\/h3>\n

ISNA function is one of the worksheet functions (WS). <\/span>Follow the steps to implement the ISNA function from the Formulas tab:<\/span><\/p>\n

1: Go to the Formulas tab\u00a0<\/span><\/p>\n

2: Click on the insert function icon.<\/span><\/p>\n

\"insert<\/a><\/p>\n

Note<\/strong>: A dialog box appears, type the keyword \u201cISNA\u201d in the search for a function box. Choose Information from the drop-down list under select a category. The ISNA function appears in the select a Function box.\u00a0<\/span><\/p>\n

3: Click on ISNA Function.<\/span><\/p>\n

4: Press OK.<\/span><\/p>\n

Note<\/strong>: Another dialog box appears asking for the cell value.<\/span><\/p>\n

\"isna<\/a><\/p>\n

5: Fill the cell reference in the value and press ok.<\/span><\/p>\n

Value<\/strong>: Here, the user wants to check whether the value in cell F2 contains the #N\/A error or not. Hence, the cell reference is \u201cF2\u201d, i.e. =ISNA(F2).<\/span><\/p>\n

\"value<\/a><\/p>\n

Here, =ISNA(F2) will return true if the value is an #N\/A error or else it returns false.<\/span><\/p>\n

\"ISNA<\/a><\/p>\n

Cell F2 contains the #N\/A error, hence it will return \u2018true\u2019 as an output in the F4 cell.<\/span><\/p>\n

ISNA function along with IF, Vlookup function<\/h4>\n

Formula<\/strong>:\u00a0<\/span><\/p>\n

\u201cIF(ISNA(VLOOKUP(D3,A1:B5,2,FALSE)),”no data available”,VLOOKUP(D3,A1:B5,2,FALSE))\u201d<\/span><\/p>\n

This function has three parts:<\/span><\/p>\n

1. IF(ISNA(VLOOKUP(D3,A1:B5,2,FALSE))<\/strong><\/p>\n

It means if the function doesn’t find the value of cell D3 in the cells A1:B5 then display the second part.<\/span><\/p>\n

2. “no data available “<\/strong><\/p>\n

It instructs the cell to fill with \u2018no data available\u2019. The user can write anything between quotation marks to display it instead of a blank cell.<\/span><\/p>\n

3. VLOOKUP(D3,A1:B5,2,FALSE))<\/strong><\/p>\n

It means if the function finds the value then it can perform the vlookup activity.\u00a0<\/span><\/p>\n

\"if<\/a><\/p>\n

Observe the formula of the E3 cell in the formula bar. The formula means that if the function doesn’t find the value of cell D3 in the table array, then display \u201cno data available\u201d.<\/span><\/p>\n

Note<\/strong>: You have to enter the vlookup content twice for IF- ISNA formula to work.<\/span><\/p>\n

Things to Remember:<\/h3>\n

1. The ISNA function is one among the IS functions.<\/span><\/p>\n

2. \u2018ISNA\u2019 function verifies the results of the formula in a cell for errors.\u00a0<\/span><\/p>\n

3. The function helps in identifying and handling #N\/A! errors.<\/span><\/p>\n

Summary<\/h3>\n

1. ISNA function helps in identifying the #N\/A error in the cells of the spreadsheet.<\/span><\/p>\n

2. ISNA function is also a part of IS functions.<\/span><\/p>\n

3. It is more or less an elegant way to handle the error.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

What is ISNA in Excel? ISNA is one of the built-in excel functions, which returns true when there is a #N\/A error in the cell. ISNA function is also known as information function. You...<\/p>\n","protected":false},"author":7,"featured_media":96738,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24129],"tags":[24515,24516,24514],"class_list":["post-96488","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-excel","tag-excel-isna","tag-excel-isna-function","tag-isna-in-excel"],"yoast_head":"\nISNA in Excel - DataFlair<\/title>\n<meta name=\"description\" content=\"ISNA function is also known as information function. It is a built-in excel function, which returns true when #N\/A error in the cell is shown.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/isna-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ISNA in Excel - DataFlair\" \/>\n<meta property=\"og:description\" content=\"ISNA function is also known as information function. It is a built-in excel function, which returns true when #N\/A error in the cell is shown.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/isna-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-18T03:30:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ISNA in Excel - DataFlair","description":"ISNA function is also known as information function. It is a built-in excel function, which returns true when #N\/A error in the cell is shown.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"ISNA in Excel - DataFlair","og_description":"ISNA function is also known as information function. It is a built-in excel function, which returns true when #N\/A error in the cell is shown.","og_url":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-06-18T03:30:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"ISNA in Excel","datePublished":"2021-06-18T03:30:17+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/"},"wordCount":675,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg","keywords":["Excel ISNA","Excel ISNA Function","ISNA in Excel"],"articleSection":["MS Excel Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/isna-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/","url":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/","name":"ISNA in Excel - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg","datePublished":"2021-06-18T03:30:17+00:00","description":"ISNA function is also known as information function. It is a built-in excel function, which returns true when #N\/A error in the cell is shown.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/isna-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/06\/ISNA-in-MS-Excel.jpg","width":1200,"height":628,"caption":"ISNA in MS Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/isna-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MS Excel Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/ms-excel\/"},{"@type":"ListItem","position":3,"name":"ISNA in Excel"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/96488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=96488"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/96488\/revisions"}],"predecessor-version":[{"id":96746,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/96488\/revisions\/96746"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/96738"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=96488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=96488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=96488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}