{"id":9178,"date":"2025-01-01T20:45:56","date_gmt":"2025-01-01T20:45:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du\/"},"modified":"2025-01-01T20:45:56","modified_gmt":"2025-01-01T20:45:56","slug":"huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m ISNA trong Excel th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u1ed7i #N\/A l\u00e0 m\u1ed9t l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong\u00a0Excel. Nh\u01b0ng trong m\u1ed9t s\u1ed1\u00a0tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng bi\u1ebft r\u00f5 c\u00f4ng th\u1ee9c c\u00f3 x\u1ea3y ra l\u1ed7i #N\/A hay kh\u00f4ng. B\u1edfi v\u1eady ch\u00fang ta c\u1ea7n m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p gi\u00fap ki\u1ec3m tra l\u1ed7i\u00a0\u0111\u00f3, ch\u00ednh l\u00e0 h\u00e0m\u00a0ISNA. Trong b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch d\u00f9ng h\u00e0m ISNA trong Excel th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 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-6775a9837e59c\" 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-dung-ham-isna-trong-excel-thong-qua-cac-vi-du.html#Cu_pham_ham_ISNA\" title=\"C\u00fa ph\u00e0m h\u00e0m\u00a0ISNA\">C\u00fa ph\u00e0m h\u00e0m\u00a0ISNA<\/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-dung-ham-isna-trong-excel-thong-qua-cac-vi-du.html#Cach_su_dung_ham_ISNA\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0ISNA\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0ISNA<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dung-ham-isna-trong-excel-thong-qua-cac-vi-du.html#Nhan_biet_loi_NA_cua_ham_VLOOKUP\" title=\"Nh\u1eadn bi\u1ebft l\u1ed7i #N\/A c\u1ee7a h\u00e0m VLOOKUP\">Nh\u1eadn bi\u1ebft l\u1ed7i #N\/A c\u1ee7a h\u00e0m VLOOKUP<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_pham_ham_ISNA\"><\/span>C\u00fa ph\u00e0m h\u00e0m\u00a0ISNA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong t\u00ean h\u00e0m g\u1ed3m 2 ph\u1ea7n:<\/p>\n<ul>\n<li>IS l\u00e0 ch\u1ee9c n\u0103ng ki\u1ec3m tra, tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\u00a0\u0111\u00fang\/sai (t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi c\u00e2u h\u1ecfi <strong>C\u00f3 ph\u1ea3i l\u00e0<\/strong>)<\/li>\n<li>NA ch\u00ednh l\u00e0 l\u1ed7i #N\/A<\/li>\n<\/ul>\n<p>C\u00e1ch vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=ISNA(value)<\/p>\n<\/blockquote>\n<p>Tham s\u1ed1\u00a0b\u00ean trong h\u00e0m\u00a0ISNA l\u00e0 Value, t\u1ee9c l\u00e0 1 gi\u00e1 tr\u1ecb. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a 1 c\u00f4ng th\u1ee9c, 1 h\u00e0m.<\/p>\n<p>H\u00e0m\u00a0ISNA s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c k\u1ebft qu\u1ea3:<\/p>\n<ul>\n<li>TRUE: n\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n ki\u1ec3m tra c\u00f3 k\u1ebft qu\u1ea3 \u0111\u00fang l\u00e0 l\u1ed7i #N\/A<\/li>\n<li>FALSE: n\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n ki\u1ec3m tra kh\u00f4ng ph\u1ea3i l\u1ed7i #N\/A<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_ISNA\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0ISNA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1edfi v\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m\u00a0ISNA l\u00e0 True \/ False n\u00ean th\u00f4ng th\u01b0\u1eddng n\u00f3 kh\u00f4ng\u00a0\u0111\u1ee9ng 1 m\u00ecnh m\u00e0 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0IF.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_biet_loi_NA_cua_ham_VLOOKUP\"><\/span>Nh\u1eadn bi\u1ebft l\u1ed7i #N\/A c\u1ee7a h\u00e0m VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/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-18.gif\" title=\"ex101_92019-nho-18\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25347\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-vlookup-voi-loi-na-01.png\" width=\"600\" height=\"250\" title=\"ham-vlookup-voi-loi-na-01\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean,\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 c\u00e1c s\u1ea3n ph\u1ea9m, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">h\u00e0m VLOOKUP<\/a>:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm: M\u00e3 h\u00e0ng t\u1ea1i c\u1ed9t B, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb\u00a0\u00f4 B2<\/li>\n<li>V\u00f9ng tham chi\u1ebfu: B\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 G3:H5<\/li>\n<li>C\u1ed9t k\u1ebft qu\u1ea3: c\u1ed9t th\u1ee9 2<\/li>\n<li>Ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm: ch\u00ednh x\u00e1c theo m\u00e3 h\u00e0ng, s\u1eed d\u1ee5ng s\u1ed1 0<\/li>\n<\/ul>\n<p>=VLOOKUP(B2,$G$3:$H$5,2,0)<\/p>\n<p>Tuy nhi\u00ean k\u1ebft qu\u1ea3 ch\u1ec9\u00a0\u0111\u00fang v\u1edbi nh\u1eefng m\u00e3 h\u00e0ng\u00a0c\u00f3 t\u00ean trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1. C\u00f2n nh\u1eefng h\u00e0ng kh\u00f4ng c\u00f3 t\u00ean s\u1ebd xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A.<\/p>\n<p>Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0ISNA\u00a0\u0111\u1ec3 nh\u1eadn bi\u1ebft l\u1ed7i n\u00e0y, k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">h\u00e0m\u00a0IF<\/a>\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb, v\u00ed d\u1ee5 l\u00e0 hi\u1ec3n th\u1ecb d\u00f2ng ch\u1eef \u201cKh\u00f4ng c\u00f3 m\u00e3 h\u00e0ng\u201d<\/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-1.png\" width=\"812\" height=\"323\" title=\"bay-loi-na-bang-ham-if-isna-1\"><\/p>\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>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 thay th\u1ebf l\u1ed7i #N\/A th\u00e0nh\u00a0\u0111o\u1ea1n th\u00f4ng b\u00e1o theo\u00a0\u00fd mu\u1ed1n\u00a0\u0111\u01b0\u1ee3c r\u1ed3i.\u00a0\u0110i\u1ec1u n\u00e0y gi\u00fap nh\u1eadn bi\u1ebft\u00a0\u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n x\u1ea3y ra l\u1ed7i, t\u1eeb\u00a0\u0111\u00f3 kh\u1eafc ph\u1ee5c l\u1ed7i d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n<p>Tuy nhi\u00ean c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c kh\u00e1 d\u00e0i d\u00f2ng ph\u1ea3i kh\u00f4ng n\u00e0o? Trong phi\u00ean b\u1ea3n\u00a0Excel 2016 ho\u1eb7c Office 365, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA\u00a0\u0111\u1ec3 r\u00fat ng\u1eafn c\u00f4ng th\u1ee9c tr\u00ean.<\/p>\n<p>Xem chi ti\u1ebft:<\/p>\n<p style=\"padding-left: 30px\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m\u00a0IFNA\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i #N\/A trong\u00a0Excel<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html\">T\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #N\/A trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/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-18.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9179,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9178","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\/9178","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=9178"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9178\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9179"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}