{"id":35746,"date":"2022-04-12T18:24:25","date_gmt":"2022-04-12T11:24:25","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=35746"},"modified":"2022-04-12T18:24:25","modified_gmt":"2022-04-12T11:24:25","slug":"khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/","title":{"rendered":"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc ph\u1ee5c c\u0169ng nh\u01b0 s\u1eeda l\u1ed7i hay kh\u00f4ng?\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd gi\u1ea3i \u0111\u00e1p t\u1ea5t t\u1ea7n t\u1eadt nh\u1eefng th\u1eafc m\u1eafc v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i Not Available trong Excel. H\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i b\u00ean d\u01b0\u1edbi nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-542096\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c5d684d.jpeg\" alt=\"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch n\u00e0y\u00a0\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Loi_NA_trong_Excel_la_gi\"><\/span><span id=\"Loi_NA_trong_Excel_la_gi\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>L\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>L\u1ed7i #N\/A<\/b><span style=\"font-weight: 400\"> l\u00e0 m\u1ed9t l\u1ed7i sai \u0111\u01b0\u1ee3c b\u00e1o trong Excel khi b\u1ea1n mu\u1ed1n t\u00ecm m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng trong v\u00f9ng ch\u1ecdn d\u1eef li\u1ec7u nh\u01b0ng \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u00f3 kh\u00f4ng t\u1ed3n t\u1ea1i, hay n\u00f3i c\u00e1ch kh\u00e1c \u0111\u00f3 l\u00e0 l\u1ed7i <\/span><b>Not Available<\/b><span style=\"font-weight: 400\"> \u2013 Kh\u00f4ng c\u00f3 s\u1eb5n. Do \u0111\u00f3, l\u1ed7i #N\/A c\u01a1 b\u1ea3n kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t l\u1ed7i sai v\u1ec1 h\u00e0m hay c\u00f4ng th\u1ee9c n\u00ean b\u1ea1n c\u0169ng s\u1ebd d\u1ec5 d\u00e0ng kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c ch\u00fang.<\/span><\/p>\n<p><span style=\"font-weight: 400\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-542097\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4ca63c3c.jpeg\" alt=\"L\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?\u00a0\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_nguyen_nhan_dan_den_loi_NA_Not_Available_trong_Excel\"><\/span><span id=\"Mot_so_nguyen_nhan_dan_den_loi_NA_Not_Available_trong_Excel\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>M\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn l\u1ed7i #N\/A Not Available trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec #N\/A l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi thao t\u00e1c c\u00e1c d\u1eef li\u1ec7u trong Excel, n\u00ean Divine Shop s\u1ebd t\u1ed5ng h\u1ee3p gi\u00fap b\u1ea1n m\u1ed9t v\u00e0i nguy\u00ean nh\u00e2n c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn l\u1ed7i #N\/A m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c c\u0169ng nh\u01b0 tr\u00e1nh ph\u1ea3i g\u1eb7p nh\u1eefng l\u1ed7i n\u00e0y:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tham chi\u1ebfu, t\u00ecm ki\u1ebfm nh\u1eefng n\u1ed9i dung kh\u00f4ng c\u00f3 s\u1eb5n trong v\u00f9ng ch\u1ecdn Excel.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eefng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, tham chi\u1ebfu c\u00f3 th\u1ec3 l\u00e0 \u00f4 tr\u1ed1ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u00fd t\u1ef1 trong c\u00e1c \u00f4 tham chi\u1ebfu b\u1ecb th\u1eeba kho\u1ea3ng tr\u1eafng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00f3 s\u1ef1 sai l\u1ec7ch v\u1ec1 s\u1ed1 h\u00e0ng, s\u1ed1 \u00f4 khi tham chi\u1ebfu c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong b\u1ea3ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u1ed9t s\u1ed1 h\u00e0m khi s\u1eed d\u1ee5ng s\u1ebd d\u1ec5 m\u1eafc l\u1ed7i #N\/A: VLOOKUP, HLOOKUP, MATCH,\u2026\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-542094 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4d3821c9.jpeg\" alt=\"M\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn l\u1ed7i #N\/A trong Excel\" width=\"2000\" height=\"1125\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_sua_loi_NA_trong_file_Excel_don_gian_nhanh_chong_nhat\"><\/span><span id=\"Huong_dan_cach_sua_loi_NA_trong_file_Excel_don_gian_nhanh_chong_nhat\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i #N\/A trong file Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng nh\u1ea5t<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c ch\u00fang, ch\u00fang ta s\u1ebd d\u1ef1a tr\u00ean nh\u1eefng nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p \u0111\u1ec3 chia ra c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u00f3 th\u1ec3 g\u1eb7p v\u00e0 v\u00ec h\u00e0m VLOOKUP, HLOOKUP gi\u1ed1ng nhau v\u1ec1 \u00fd ngh\u0129a tham chi\u1ebfu n\u00ean b\u00ean d\u01b0\u1edbi \u0111\u00e2y Divine Shop s\u1ebd l\u1ea5y v\u00ed d\u1ee5 cho h\u00e0m VLOOKUP, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eeda l\u1ed7i t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi HLOOKUP nh\u00e9!\u00a0\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NA_trong_ham_Vlookup_Hlookup_khi_khong_chua_doi_tuong_can_tim\"><\/span><span id=\"Loi_NA_trong_ham_Vlookup_Hlookup_khi_khong_chua_doi_tuong_can_tim\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><b>L\u1ed7i #N\/A trong h\u00e0m Vlookup, Hlookup khi kh\u00f4ng ch\u1ee9a \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea1n c\u1ea7n t\u00ecm kh\u00f4ng t\u1ed3n t\u1ea1i trong v\u00f9ng ch\u1ecdn d\u1eef li\u1ec7u Excel, l\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c #N\/A b\u1eb1ng c\u00e1ch cho k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u201cKh\u00f4ng t\u1ed3n t\u1ea1i\u201d b\u1eb1ng h\u00e0m <\/span><b>COUNTIF<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 bi\u1ec7n lu\u1eadn cho n\u1ed9i dung kh\u00f4ng t\u00ecm th\u1ea5y. <img loading=\"lazy\" class=\"aligncenter wp-image-542091 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4dbaf6bd.jpeg\" alt=\"L\u1ed7i #N\/A trong Excel h\u00e0m Vlookup, Hlookup khi kh\u00f4ng ch\u1ee9a \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm - H\u00ecnh 1\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu n\u1ed9i dung c\u00f3 xu\u1ea5t hi\u1ec7n th\u00ec h\u00e0m COUNTIF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 &gt; 0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu n\u1ed9i dung c\u1ea7n t\u00ecm kh\u00f4ng c\u00f3 th\u00ec h\u00e0m COUNTIF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 =0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Do \u0111\u00f3 c\u00fa ph\u00e1p s\u1eeda l\u1ed7i: <\/span><b>=IF(COUNTIF(B2:B6;F8)=0;\u201dKh\u00f4ng c\u00f3\u201d;VLOOKUP(B1:C6;2;))<\/b><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-542092\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4dfb1772.jpeg\" alt=\"L\u1ed7i #N\/A trong Excel h\u00e0m Vlookup, Hlookup khi kh\u00f4ng ch\u1ee9a \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm - H\u00ecnh 2\" width=\"2000\" height=\"1125\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_bao_loi_NA_ham_VLOOKUP_trong_Excel_voi_IFERROR\"><\/span><span id=\"Cach_bao_loi_NA_ham_VLOOKUP_trong_Excel_voi_IFERROR\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><b>C\u00e1ch b\u00e1o l\u1ed7i #N\/A h\u00e0m VLOOKUP, trong Excel v\u1edbi IFERROR<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, n\u1ebfu nh\u01b0 b\u1ea1n nh\u1eadn ra \u0111\u01b0\u1ee3c c\u00f3 nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng m\u00ecnh c\u1ea7n tham chi\u1ebfu l\u1ea1i kh\u00f4ng c\u00f3 s\u1eb5n trong v\u00f9ng ch\u1ecdn d\u1eef li\u1ec7u ho\u1eb7c d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n sai kh\u00e1c v\u1ec1 m\u1eb7t k\u00fd t\u1ef1 tham chi\u1ebfu th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m<\/span><b> IFERROR(value; value_if_error)<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 \u0111\u01b0a v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u00f4 tr\u1ed1ng ho\u1eb7c b\u00e1o l\u1ed7i \u0111\u1ec3 \u1ea9n \u0111i #N\/A.\u00a0 \u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n nh\u01b0 sau: <\/span><b>=IFERROR(VLOOKUP(F9;B1:C6;2);\u201dl\u1ed7i\u201d)<\/b><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-542093\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4e3db82e.jpeg\" alt=\"C\u00e1ch \u1ea9n l\u1ed7i #N\/A h\u00e0m VLOOKUP, trong Excel\" width=\"2000\" height=\"1125\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>T\u1ea1m k\u1ebft<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y, Divine Shop \u0111\u00e3 ch\u1ec9 cho b\u1ea1n nh\u1eefng nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p c\u1ee7a <strong>l\u1ed7i #N\/A trong Excel<\/strong> v\u00e0 m\u1ed9t v\u00e0i tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 \u0111\u1ec3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n. Hy v\u1ecdng \u0111\u00e2y l\u00e0 ngu\u1ed3n tham kh\u1ea3o b\u1ed5 \u00edch d\u00e0nh cho b\u1ea1n. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/span><\/p>\n<p><em><strong>\u00a0<\/strong><\/em><\/p>\n<p style=\"text-align: center\">\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=h%E1%BB%8Dc+t%E1%BA%ADp\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png\" alt=\"\" class=\"wp-image-285219\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69d2f241c9c5d wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc ph\u1ee5c c\u0169ng nh\u01b0 s\u1eeda l\u1ed7i hay kh\u00f4ng?\u00a0 B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd gi\u1ea3i \u0111\u00e1p t\u1ea5t t\u1ea7n t\u1eadt nh\u1eefng [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":35747,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5\" \/>\n<meta property=\"og:description\" content=\"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T11:24:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1125\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg\",\"width\":2000,\"height\":1125},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/\",\"name\":\"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5 - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage\"},\"datePublished\":\"2022-04-12T11:24:25+00:00\",\"dateModified\":\"2022-04-12T11:24:25+00:00\",\"description\":\"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5\",\"datePublished\":\"2022-04-12T11:24:25+00:00\",\"dateModified\":\"2022-04-12T11:24:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage\"},\"wordCount\":944,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg\",\"keywords\":[\"Th\u1ee7 thu\u1eadt\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc","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:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/","og_locale":"vi_VN","og_type":"article","og_title":"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5","og_description":"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc","og_url":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T11:24:25+00:00","og_image":[{"width":2000,"height":1125,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"5 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg","width":2000,"height":1125},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/","name":"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5 - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage"},"datePublished":"2022-04-12T11:24:25+00:00","dateModified":"2022-04-12T11:24:25+00:00","description":"L\u1ed7i #N\/A c\u00f3 th\u1ec3 n\u00f3i l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t khi b\u1ea1n s\u1eed d\u1ee5ng Excel, v\u1eady th\u00ec l\u1ed7i #N\/A trong Excel l\u00e0 g\u00ec?, c\u00f3 d\u1ec5 d\u00e0ng \u0111\u1ec3 kh\u1eafc","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"Kh\u1eafc ph\u1ee5c ngay l\u1ed7i #N\/A trong Excel \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi nh\u1eefng c\u00e1ch c\u1ef1c d\u1ec5","datePublished":"2022-04-12T11:24:25+00:00","dateModified":"2022-04-12T11:24:25+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#webpage"},"wordCount":944,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/khac-phuc-ngay-loi-n-a-trong-excel-don-gian-hon-bao-gio-het-voi-nhung-cach-cuc-de_6239c4c169e6e.jpeg","keywords":["Th\u1ee7 thu\u1eadt"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35746"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=35746"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35746\/revisions"}],"predecessor-version":[{"id":73487,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/35746\/revisions\/73487"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/35747"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=35746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=35746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=35746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}