{"id":2945,"date":"2021-06-15T02:25:25","date_gmt":"2021-06-14T20:55:25","guid":{"rendered":"https:\/\/exceltrick.com\/?p=2945"},"modified":"2023-11-08T18:35:49","modified_gmt":"2023-11-08T13:05:49","slug":"excel-isna-function","status":"publish","type":"post","link":"https:\/\/exceltrick.com\/functions\/excel-isna-function\/","title":{"rendered":"Excel ISNA Function \u2013 How To Use"},"content":{"rendered":"<p>The Excel ISNA function checks whether a value is #N\/A or not. The function only returns TRUE upon finding the #N\/A error. It returns FALSE for all other values or errors. The objective of the ISNA function is to solely recognize and handle <a href=\"https:\/\/exceltrick.com\/functions\/na-error-excel\/\">#N\/A errors<\/a> and return TRUE when an #N\/A error is found and FALSE for everything else.<\/p>\n<p>By #N\/A here, we mean &#39;not available&#39; and ISNA literally means &#39;Is not available?&#39;. Now with the emergence of newer functions, there are more refined ways of dealing with #N\/A errors but since the ISNA function has been around since Excel 2003, it has served as a decent method of identified #N\/A errors.<\/p>\n<p>In this tutorial we will show you how the ISNA function works, its synergy effects with other functions, and where it stands against similar error handling functions.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-2952\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function.png\" alt=\"Excel ISNA Function\" width=\"753\" height=\"396\" title=\"\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_53 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-69f449065673c\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-69f449065673c\"  type=\"checkbox\" id=\"item-69f449065673c\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#Syntax\" title=\"Syntax\">Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#Important_Characteristics_of_ISNA_Function_in_Excel\" title=\"Important Characteristics of ISNA Function in Excel\">Important Characteristics of ISNA Function in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#Examples_of_ISNA_Function\" title=\"Examples of ISNA Function\">Examples of ISNA Function<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#Example_1_%E2%80%93_Simple_ISNA_function\" title=\"Example 1 \u2013 Simple ISNA function\">Example 1 \u2013 Simple ISNA function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#Example_2_%E2%80%93_ISNA_function_with_VLOOKUP_function\" title=\"Example 2 \u2013 ISNA function with VLOOKUP function\">Example 2 \u2013 ISNA function with VLOOKUP function<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#ISNA_vs_IFNA_Function\" title=\"ISNA vs IFNA Function\">ISNA vs IFNA Function<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#How_to_Choose_Between_ISNA_IFNA\" title=\"How to Choose Between ISNA &amp; IFNA\">How to Choose Between ISNA &amp; IFNA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#ISNA_vs_ISERROR_Function\" title=\"ISNA vs ISERROR Function\">ISNA vs ISERROR Function<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#How_to_Choose_Between_ISNA_ISERROR\" title=\"How to Choose Between ISNA &amp; ISERROR\">How to Choose Between ISNA &amp; ISERROR<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#ISNA_vs_ISERR_Function\" title=\"ISNA vs ISERR Function\">ISNA vs ISERR Function<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/exceltrick.com\/functions\/excel-isna-function\/#How_to_Choose_Between_ISNA_ISERR\" title=\"How to Choose Between ISNA &amp; ISERR\">How to Choose Between ISNA &amp; ISERR<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Syntax\"><\/span>Syntax<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax of the ISNA function is as follows:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">ISNA<\/span>(value)<\/code><\/div>\n<p style=\"margin: 0px;\"><strong>Arguments:<\/strong><\/p>\n<p style=\"padding-left: 30px;\"><code>value<\/code> &#8211; The value or expression to be tested for #N\/A error.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Important_Characteristics_of_ISNA_Function_in_Excel\"><\/span>Important Characteristics of ISNA Function in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>The ISNA function only deals with #N\/A errors<\/li>\n<li>When the function comes across an #N\/A error it returns TRUE otherwise it returns FALSE<\/li>\n<li>ISNA is generally used along with the IF function to handle #N\/A errors<\/li>\n<li>If the formula has any typos or misspelling, the function returns a #NAME?<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Examples_of_ISNA_Function\"><\/span>Examples of ISNA Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now would be a good time to look into some examples to understand the ISNA function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_1_%E2%80%93_Simple_ISNA_function\"><\/span>Example 1 \u2013 Simple ISNA function<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Let\u2019s take a look at ISNA in its simplest form.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2953 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-01.png\" alt=\"Simple ISNA function\" width=\"362\" height=\"297\" title=\"\">\n<p>We are checking column A for #N\/A errors using the ISNA function in its simplest form:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">ISNA<\/span>(A2)<\/code><\/div>\n<p>The ISNA function finds an #N\/A error in &quot;A2&quot; and hence returns a &quot;TRUE&quot;. For all other errors and values, ISNA returns &quot;FALSE&quot;. This implies that the ISNA function only singles out #N\/A errors.<\/p>\n<p>This is a very basic application of the ISNA function. Let\u2019s move onto more practical examples.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_2_%E2%80%93_ISNA_function_with_VLOOKUP_function\"><\/span>Example 2 \u2013 ISNA function with VLOOKUP function<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>While looking up a value from a set of data, there is of course the possibility of not finding it. When trying to find that missing value using a lookup function (including <a href=\"https:\/\/exceltrick.com\/functions\/vlookup-in-excel\/\"  rel=\"noopener noreferrer\">VLOOKUP<\/a>, <a href=\"https:\/\/exceltrick.com\/functions\/hlookup-in-excel-with-examples\/\"  rel=\"noopener noreferrer\">HLOOKUP<\/a>, XLOOKUP), the result is #N\/A since the value is not available.<\/p>\n<p>For example, we have a list of dry cake mixes used for baking and their prices.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2954 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-02.png\" alt=\"ISNA function with VLOOKUP function\" width=\"758\" height=\"384\" title=\"\">\n<p>We are trying to find the prices of a chocolate cake mix and a marble cake mix. Let\u2019s use the VLOOKUP function to find them:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">VLOOKUP<\/span>(E6,$B$2:$C$11,2,0)<\/code><\/div>\n<p>The list of cake mixes doesn\u2019t have &quot;Marble cake&quot; which is why VLOOKUP has returned an &quot;#N\/A&quot; error.<\/p>\n<p>Let\u2019s have a look at the results after adding the ISNA function.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2955 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-03.png\" alt=\"results after adding the ISNA function\" width=\"758\" height=\"384\" title=\"\">\n<p>We have added the ISNA function to the VLOOKUP function:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">ISNA<\/span>(<span class=\"function\">VLOOKUP<\/span>(E6,$B$2:$C$11,2,0))<\/code><\/div>\n<p>All this is doing right now is telling us whether there was an #N\/A error while finding the mentioned cake mixes or not.<\/p>\n<p>Was there a &#39;not available&#39; error finding &quot;Chocolate cake&quot; mix? <strong>\u2013 <\/strong>FALSE. Chocolate cake mix is present in our dataset.<\/p>\n<p>Was there a &#39;not available&#39; error finding &quot;Marble cake&quot; mix? <strong>\u2013 <\/strong>TRUE. Marble cake mix is not present in our dataset.<\/p>\n<p>Our objective here is to find the prices of the cake mixes which the ISNA function isn\u2019t doing alone. We will have to add the <a href=\"https:\/\/exceltrick.com\/functions\/excel-if-statement\/\"  rel=\"noopener noreferrer\">IF function<\/a> to get the desired results. Let us do that for you.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2956 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-04.png\" alt=\"add the IF function to get the desired results\" width=\"862\" height=\"387\" title=\"\">\n<p>We have nested the ISNA and VLOOKUP functions in the IF function like so:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IF<\/span>(<span class=\"function\">ISNA<\/span>(<span class=\"function\">VLOOKUP<\/span>(E6,$B$2:$C$11,2,0)), \"<span class=\"string\">Not Available!<\/span>\", (<span class=\"function\">VLOOKUP<\/span>(E6,$B$2:$C$11,2,0)))<\/code><\/div>\n<p>This formula works as follows:<\/p>\n<p>VLOOKUP is told to find the data mentioned in cell &quot;E6&quot; which is &quot;Chocolate cake&quot;. The table given to VLOOKUP for searching is within the cell range &quot;B2:C11&quot;; VLOOKUP must find &quot;E6&quot; in the 1<sup>st<\/sup> column (column B) of the given table and return the corresponding value from the 2<sup>nd<\/sup> column (column C). &quot;0&quot; indicates that VLOOKUP must find an exact match.<\/p>\n<p>Since &quot;Chocolate cake&quot; is enlisted in the range of cake mixes, VLOOKUP finds it, picks up the corresponding price from the 2<sup>nd<\/sup> column, and returns the value &quot;$3.21&quot;.<\/p>\n<p>The result &quot;$3.21&quot; is passed to ISNA where ISNA checks it for an #N\/A error. It doesn\u2019t find an #N\/A error and results in &quot;FALSE&quot;. The result FALSE is passed to the IF function, which then displays the original result of the VLOOKUP function and so the result &quot;$3.21&quot; is displayed.<\/p>\n<p>In the next case, we will now try to find the price of a &quot;Marble cake&quot; mix. Since the &quot;Marble cake&quot; mix is not listed in our data set so the VLOOKUP is not able to find it in column B and results in an #N\/A error. The result is handed over to ISNA and it turns &quot;#N\/A&quot; into TRUE. The result TRUE is passed to the IF function, which shows the message &quot;Not Available!&quot; as the final output of the formula.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ISNA_vs_IFNA_Function\"><\/span>ISNA vs IFNA Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Stepping out of the IS functions family a bit, the <a href=\"https:\/\/exceltrick.com\/functions\/excel-ifna-function\/\"  rel=\"noopener noreferrer\">IFNA function<\/a> returns the value specified if the expression resolves to #N\/A, otherwise it returns the result of the expression. This would be particularly useful against the ISNA function as we get the same result from IFNA without having to nest ISNA and VLOOKUP functions into the IF function.<\/p>\n<p>Let us show you how the same outcome can be easily achieved by the IFNA function.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2957 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-05.png\" alt=\"ISNA vs IFNA Function\" width=\"792\" height=\"385\" title=\"\">\n<p>Take note that we have attained the exact same results as in the previous example by lesser work using the formula:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IFNA<\/span>(<span class=\"function\">VLOOKUP<\/span>(E6,$B$2:$C$11,2,0),\"<span class=\"string\">Not Available!<\/span>\")<\/code><\/div>\n<p>Since &quot;Chocolate cake&quot; was available in our set of data, the VLOOKUP function did its work and returned the value &quot;$3.21&quot;. No work for IFNA here.<\/p>\n<p>For the next instance, VLOOKUP could not find &quot;Marble cake&quot; in column B and results in an #N\/A error. The result is handed over to IFNA and it turns &quot;#N\/A&quot; into &quot;Not available&quot; and returns that as the result.<\/p>\n<p>That was fairly uncomplicated compared to using IF, ISNA, and VLOOKUP functions together.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Choose_Between_ISNA_IFNA\"><\/span>How to Choose Between ISNA &amp; IFNA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The ISNA function may be a suitable tool where the results are needed as TRUE\/FALSE but if you\u2019re going for a specified result where you want to have control over the outcome, ISNA will have to be used with the IF function whereas IFNA alone would do the same thing.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ISNA_vs_ISERROR_Function\"><\/span>ISNA vs ISERROR Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Quite like ISNA but as the name suggests, ISERROR (is error?) deals with a larger amount of Excel errors and returns TRUE if any error is detected and FALSE otherwise. While this may seem to be the answer to more problems, it will be hard to pinpoint what error has been detected by the function. Upon using ISERROR with VLOOKUP and IF, ISERROR will cover up the underlying problem and return the custom result instead.<\/p>\n<p>Let\u2019s refer to the previous example and see how this applies.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2958 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-06.png\" alt=\"ISNA vs ISERROR Function\" width=\"866\" height=\"385\" title=\"\">\n<p>If you notice, &quot;Chocolate cake&quot; is available in the dataset. Here, we have used the ISERROR function instead of the ISNA function and made a spelling error in the name of the formula (VLOOKUP is misspelled as VLOOKP). The formula:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IF<\/span>(<span class=\"function\">ISERROR<\/span>(<span class=\"function\">VLOOKP<\/span>(E6,$B$2:$C$11,2,0)), \"<span class=\"string\">Not Available!<\/span>\", (<span class=\"function\">VLOOKP<\/span>(E6,$B$2:$C$11,2,0))) <span class=\"comment\">\/\/Incorrect Formula<\/span><\/code><\/div>\n<p>The result of the VLOOKUP function results in a #NAME? error due to incorrect spelling. The result is passed onto the ISERROR function which results in TRUE as it has found a #NAME? error. IF function is commanded to return the custom text &quot;Not available&quot; which has covered up the #NAME? error and it appears as if the chocolate cake mix data is not available.<\/p>\n<p>This doesn&#39;t truly reflect the scenario since the chocolate cake mix and its price is listed in the table. Let&#39;s see what happens when we try to pass the same error through the ISNA function.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2959 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-07.png\" alt=\"ISNA would result in a #NAME? error\" width=\"869\" height=\"386\" title=\"\">\n<p>Making the same typo with ISNA would result in a #NAME? error. Hence, a truer representation comes from the ISNA function here which only works for #N\/A errors and shows the underlying problem which is the #NAME? error, indicating a spelling error.<\/p>\n<p>Quite useful, ISERROR best serves the need to cover up more errors, affirming whether there are any errors or not.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Choose_Between_ISNA_ISERROR\"><\/span>How to Choose Between ISNA &amp; ISERROR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In most cases, it would be more prudent to use the ISNA function as it would display other errors indicating the relevant issue with the data or formula.<\/p>\n<p>On the other hand, the <a href=\"https:\/\/exceltrick.com\/functions\/excel-iserror-function\/\"  rel=\"noopener\">ISERROR function<\/a> would work better where more errors need to be handled. \u00a0It will deal with a greater number of errors including the #N\/A error and will confirm whether there are any errors in the data or not.<\/p>\n<p><em>Recommended Reading<\/em>: <a href=\"https:\/\/exceltrick.com\/functions\/excel-iferror-function\/\"  rel=\"noopener noreferrer\">IFERROR Function In Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"ISNA_vs_ISERR_Function\"><\/span>ISNA vs ISERR Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The <a href=\"https:\/\/exceltrick.com\/functions\/excel-iserr-function\/\"  rel=\"noopener noreferrer\">ISERR function<\/a> is the same as its ISERROR brother but it returns TRUE for all errors other than the #N\/A error and FALSE otherwise. While it will be helpful using ISERR so there is one less error to think about, it will not work for #N\/A errors like in the previous example. Let us demonstrate:<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-2960 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/06\/Excel-ISNA-Function-Example-08.png\" alt=\"ISNA vs ISERR Function\" width=\"869\" height=\"386\" title=\"\">\n<p>It&#39;s nearly the end of the tutorial and we are well aware that there&#39;s going to be no marble cake tonight. As apparent, the ISERR function has resulted in an #N\/A error as VLOOKUP could not find &quot;Marble cake&quot; in the dataset despite the command to return &quot;Not Available!&quot;.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Choose_Between_ISNA_ISERR\"><\/span>How to Choose Between ISNA &amp; ISERR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When in need of narrowing down the errors to be checked, ISERR will work for covering up all errors excluding the #N\/A error. It is the exact flip of the ISNA function which will be convenient to deal only with #N\/A errors. Both result in TRUE\/FALSE upon finding the respective errors.<\/p>\n<p>That&#39;s all ISNA has to say about itself but we still have a little riddle for you:<\/p>\n<p>What kind of career would a spider excel in?<\/p>\n<p>.<\/p>\n<p>.<\/p>\n<p>.<\/p>\n<p>.<\/p>\n<p>.<\/p>\n<p>Web design<\/p>\n<p>See you with another chip from the Excel block!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel ISNA function checks whether a value is #N\/A or not. The function only returns TRUE upon finding the #N\/A error. It returns FALSE for all other values or errors. The objective of the ISNA function is to solely recognize and handle #N\/A errors and return TRUE when an #N\/A error is found and [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":2952,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[34],"_links":{"self":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/2945"}],"collection":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/comments?post=2945"}],"version-history":[{"count":0,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/2945\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media\/2952"}],"wp:attachment":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media?parent=2945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/categories?post=2945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/tags?post=2945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}