{"id":8638,"date":"2024-12-23T12:51:52","date_gmt":"2024-12-23T12:51:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/n-a-la-gi-gioi-thieu-ham-na-trong-excel\/"},"modified":"2024-12-23T12:51:52","modified_gmt":"2024-12-23T12:51:52","slug":"n-a-la-gi-gioi-thieu-ham-na-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/n-a-la-gi-gioi-thieu-ham-na-trong-excel\/","title":{"rendered":"N\/A l\u00e0 g\u00ec? Gi\u1edbi thi\u1ec7u h\u00e0m NA trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u201cN\/A l\u00e0 g\u00ec?\u201d \u2013 ch\u1eafc h\u1eb3n \u0111\u00e2y l\u00e0 c\u00e2u h\u1ecfi nhi\u1ec1u b\u1ea1n \u0111\u00e3 th\u1eafc m\u1eafc khi g\u1eb7p l\u1ed7i n\u00e0y trong Excel. Tuy nhi\u00ean th\u00ec \u0111\u00e2y kh\u00f4ng h\u1eb3n l\u00e0 l\u1ed7i \u2013 m\u00e0 \u0111\u00e2y l\u00e0 m\u1ed9t t\u00ednh n\u0103ng. Ta c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb \u201ct\u00ednh n\u0103ng\u201d n\u00e0y qua h\u00e0m NA. V\u1eady h\u00e0m\u00a0<strong>NA<\/strong> l\u00e0 g\u00ec? H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/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-67695ce75bd67\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-na-trong-excel.html#NA_la_gi_Ham_NA_tra_ve_gia_tri_loi\" title=\"N\/A l\u00e0 g\u00ec? H\u00e0m NA tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i\">N\/A l\u00e0 g\u00ec? H\u00e0m NA tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-na-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-na-trong-excel.html#Ket_hop_ham_NA_voi_ham_IF\" title=\"K\u1ebft h\u1ee3p h\u00e0m NA v\u1edbi h\u00e0m IF\">K\u1ebft h\u1ee3p h\u00e0m NA v\u1edbi h\u00e0m IF<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"NA_la_gi_Ham_NA_tra_ve_gia_tri_loi\"><\/span>N\/A l\u00e0 g\u00ec? H\u00e0m NA tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>NA<\/strong> c\u00f3 ch\u1ee9c n\u0103ng\u00a0<strong>tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #N\/A<\/strong> (<em>not applicable, not available, no value available)<\/em> c\u00f3 ngh\u0129a l\u00e0 \u201ckh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o\u201d.<\/p>\n<p>\u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n\u00a0hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u00ean c\u00e1c \u00f4 \u0111\u1ec3 th\u1ec3 hi\u1ec7n kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3. H\u00e0m c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01a1n l\u1ebb ho\u1eb7c l\u1ed3ng v\u00e0o c\u00e1c h\u00e0m kh\u00e1c. Ch\u1eb3ng h\u1ea1n v\u1edbi h\u00e0m IF.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m NA c\u00f3 c\u00f4ng th\u1ee9c r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<blockquote>\n<p><strong><em>=NA()<\/em><\/strong><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ham_NA_voi_ham_IF\"><\/span>K\u1ebft h\u1ee3p h\u00e0m NA v\u1edbi h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-na-1.png\" width=\"475\" height=\"167\" title=\"ham-na-1\"><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta c\u1ea7n tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb #N\/A v\u1edbi \u00f4 kh\u00f4ng c\u00f3 s\u1ed1 l\u01b0\u1ee3ng. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3, t\u1ea1i \u00f4 C2 ch\u00e8n h\u00e0m NA v\u00e0o trong h\u00e0m IF:<\/p>\n<p><strong><em>=IF(A2=\u201d\u201d,NA(),A2*B2)<\/em><\/strong><\/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\/2024\/12\/ex101_92019-nho-800.gif\" title=\"ex101_92019-nho-800\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng AutoFill cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-na-2.png\" width=\"411\" height=\"167\" title=\"ham-na-2\"><\/p>\n<p>L\u01b0u \u00fd:<\/p>\n<ul>\n<li>Khi m\u1ed9t c\u00f4ng th\u1ee9c li\u00ean quan t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb #N\/A, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 #N\/A<\/li>\n<li>H\u00e0m NA kh\u00f4ng c\u1ea7n \u0111\u1ed1i s\u1ed1 tuy nhi\u00ean b\u1ea1n nh\u1edb \u0111i\u1ec1n c\u1eb7p ngo\u1eb7c \u0111\u01a1n nh\u00e9.<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 g\u00f5 tr\u1ef1c ti\u1ebfp\u00a0<em>#N\/A\u00a0<\/em>v\u00e0o \u00f4 t\u00ednh t\u1eeb b\u00e0n ph\u00edm.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>Xem th\u00eam:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html\"><strong>T\u00ecm hi\u1ec3u #N\/A trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-an-loi-na-bang-conditional-formatting-trong-excel.html\">C\u00e1ch \u1ea9n #N\/A trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-ifna-de-tranh-loi-na-trong-excel.html\"><strong>S\u1eed d\u1ee5ng IFNA \u0111\u1ec3 x\u1eed l\u00fd #N\/A<\/strong><\/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\/2024\/12\/ex101_92019-nho-800.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8639,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8638","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\/8638","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=8638"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8638\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8639"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}