{"id":9173,"date":"2025-01-01T20:22:39","date_gmt":"2025-01-01T20:22:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-n-a-trong-excel\/"},"modified":"2025-01-01T20:22:39","modified_gmt":"2025-01-01T20:22:39","slug":"huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-n-a-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-n-a-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFNA \u0111\u1ec3 tr\u00e1nh l\u1ed7i #N\/A trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m\u00a0IFNA l\u00e0 m\u1ed9t h\u00e0m r\u00fat g\u1ecdn c\u1ee7a c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0ISNA. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng nhau t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i #N\/A trong Excel nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775a40ee3ae5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-na-trong-excel.html#Cau_truc_cua_ham_IFNA\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\u00a0IFNA\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\u00a0IFNA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-na-trong-excel.html#Su_dung_ham_IFNA_thay_the_cho_cach_su_dung_ham_IF_ket_hop_ham_ISNA\" title=\"S\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA thay th\u1ebf cho c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IF k\u1ebft h\u1ee3p h\u00e0m\u00a0ISNA\">S\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA thay th\u1ebf cho c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IF k\u1ebft h\u1ee3p h\u00e0m\u00a0ISNA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham_IFNA\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\u00a0IFNA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>L\u01b0u\u00a0\u00fd: H\u00e0m n\u00e0y ch\u1ec9\u00a0\u00e1p d\u1ee5ng trong phi\u00ean b\u1ea3n\u00a0Excel 2013 tr\u1edf v\u1ec1 sau.<\/em><\/p>\n<p>H\u00e0m c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=IFNA(value, value_if_na)<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Value: l\u00e0 gi\u00e1 tr\u1ecb, k\u1ebft qu\u1ea3 c\u1ee7a 1 c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i #N\/A<\/li>\n<li>Value_if_na: l\u00e0 gi\u00e1 tr\u1ecb thay th\u1ebf cho th\u00f4ng b\u00e1o l\u1ed7i #N\/A n\u1ebfu c\u00f3 x\u1ea3y ra l\u1ed7i n\u00e0y<\/li>\n<\/ul>\n<p>H\u00e0m\u00a0IFNA ch\u1ec9 mang m\u1ee5c\u00a0\u0111\u00edch ph\u00e1t hi\u1ec7n, thay th\u1ebf l\u1ed7i #N\/A (hay c\u00f2n g\u1ecdi l\u00e0 b\u1eaby l\u1ed7i #N\/A). B\u1edfi v\u1eady n\u00ean\u00a0c\u00e1c tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m n\u00e0y c\u0169ng r\u1ea5t r\u00f5 r\u00e0ng, c\u1ee5 th\u1ec3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_IFNA_thay_the_cho_cach_su_dung_ham_IF_ket_hop_ham_ISNA\"><\/span>S\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA thay th\u1ebf cho c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IF k\u1ebft h\u1ee3p h\u00e0m\u00a0ISNA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong b\u00e0i vi\u1ebft v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m ISNA trong Excel th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5<\/a> ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0ISNA\u00a0\u0111\u1ec3 thay th\u1ebf l\u1ed7i #N\/A c\u00f3 th\u1ec3 x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bay-loi-na-bang-ham-if-isna.png\" width=\"812\" height=\"323\" title=\"bay-loi-na-bang-ham-if-isna\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-17.gif\" title=\"ex101_92019-nho-17\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">=IF(ISNA(VLOOKUP(B2,$G$3:$H$5,2,0)),\u201dKh\u00f4ng c\u00f3 m\u00e3 h\u00e0ng\u201d,VLOOKUP(B2,$G$3:$H$5,2,0))<\/p>\n<p>C\u00e2u l\u1ec7nh tr\u00ean c\u00f3\u00a0\u00fd ngh\u0129a:<\/p>\n<ul>\n<li>X\u00e9t l\u1ed7i #N\/A c\u1ee7a h\u00e0m VLOOKUP:\u00a0ISNA(VLOOKUP(B2,$G$3:$H$5,2,0))<\/li>\n<li>N\u1ebfu c\u00f3 l\u1ed7i, s\u1ebd tr\u1ea3 v\u1ec1\u00a0\u0111o\u1ea1n text \u201cKh\u00f4ng c\u00f3 m\u00e3 h\u00e0ng\u201d<\/li>\n<li>N\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m VLOOKUP<\/li>\n<\/ul>\n<p>\u1ede\u00a0\u0111\u00e2y ta th\u1ea5y h\u00e0m VLOOKUP l\u1eb7p l\u1ea1i 2 l\u1ea7n:<\/p>\n<ul>\n<li>1 l\u1ea7n trong m\u1ec7nh\u00a0\u0111\u1ec1 ki\u1ec3m tra l\u1ed7i #N\/A v\u1edbi h\u00e0m\u00a0ISNA<\/li>\n<li>1 l\u1ea7n trong m\u1ec7nh\u00a0\u0111\u1ec1 value_if_false, t\u1ee9c l\u00e0 kh\u00f4ng x\u1ea3y ra l\u1ed7i #N\/A<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 r\u00fat g\u1ecdn l\u1ea1i nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=IFNA(VLOOKUP(B2,$G$3:$H$5,2,0),\u201dKh\u00f4ng c\u00f3 m\u00e3 h\u00e0ng\u201d)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25360\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bay-loi-na-bang-ham-ifna.png\" width=\"786\" height=\"254\" title=\"bay-loi-na-bang-ham-ifna\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c ng\u1eafn h\u01a1n r\u1ea5t nhi\u1ec1u, trong khi k\u1ebft qu\u1ea3 v\u1eabn\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c nh\u01b0\u00a0\u00fd mu\u1ed1n.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u m\u1ed9t\u00a0b\u00e0i vi\u1ebft v\u1ec1 vi\u1ec7c t\u1eadn d\u1ee5ng l\u1ed7i #N\/A trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0h\u1ed7 tr\u1ee3 tr\u00e1nh l\u1ed7i bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng\u00a0\u0111\u01b0\u1eddng th\u1eb3ng ch\u1ea1y v\u1ec1 gi\u00e1 tr\u1ecb = 0<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-khac-phuc-loi-chay-ve-0-khi-ve-bieu-do-dang-duong-thang-trong-excel.html\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i ch\u1ea1y v\u1ec1 0 khi v\u1ebd bi\u1ec3u \u0111\u1ed3 d\u1ea1ng \u0111\u01b0\u1eddng th\u1eb3ng trong Excel<\/a><\/p>\n<p>v\u00e0 k\u1ebft h\u1ee3p v\u1edbi\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-an-loi-na-bang-conditional-formatting-trong-excel.html\">c\u00e1ch\u00a0\u1ea9n l\u1ed7i #N\/A b\u1eb1ng Conditional Formatting trong Excel<\/a><\/p>\n<p>\u0110\u1ed1i v\u1edbi nh\u1eefng l\u1ed7i kh\u00e1c kh\u00f4ng ph\u1ea3i #N\/A, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\">Ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-17.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9174,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9173"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9173\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9174"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}