{"id":11880,"date":"2022-11-20T22:07:34","date_gmt":"2022-11-20T15:07:34","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11880"},"modified":"2022-12-06T14:28:23","modified_gmt":"2022-12-06T07:28:23","slug":"loi-na-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/","title":{"rendered":"L\u1ed7i N\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11880&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;11&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.1&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.1\\\/5 - (11 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;L\u1ed7i N\\\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3&quot;,&quot;width&quot;:&quot;116.4&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 116.4px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.1\/5 - (11 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400;\">Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi ph\u1ea7n m\u1ec1m excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady \u0111\u00e2y l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 r\u00f5 h\u01a1n v\u1ec1 <\/span><b>l\u1ed7i na trong excel<\/b><span style=\"font-weight: 400;\"> th\u00ec h\u00e3y theo d\u00f5i th\u00f4ng tin b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a <strong><a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a><\/strong>.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\" style=\"cursor:inherit\">N\u1ed9i dung <\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Dinh_nghia_loi_NA_la_gi\" >\u0110\u1ecbnh ngh\u0129a l\u1ed7i #N\/A l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Tim_hieu_chi_tiet_ve_nguyen_nhan_dan_toi_loi_na_trong_excel_cua_mot_so_ham\" >T\u00ecm hi\u1ec3u chi ti\u1ebft v\u1ec1 nguy\u00ean nh\u00e2n d\u1eabn t\u1edbi l\u1ed7i na trong excel c\u1ee7a m\u1ed9t s\u1ed1 h\u00e0m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Huong_dan_cach_khac_phuc_loi_NA_trong_excel_cuc_don_gian_cho_ban\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i\u00a0 #N\/A trong excel c\u1ef1c \u0111\u01a1n gi\u1ea3n cho b\u1ea1n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Huong_dan_chi_tiet_cach_an_loi_NA_trong_excel_nhanh_chong_cho_ban\" >H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u1ea9n l\u1ed7i #N\/A trong excel nhanh ch\u00f3ng cho b\u1ea1n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Tai_sao_van_xuat_hien_loi_NA_khi_nhin_thay_vung_du_lieu_tham_chieu_trong_dieu_kien_tham_chieu\" >T\u1ea1i sao v\u1eabn xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A khi nh\u00ecn th\u1ea5y v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu trong \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#Loi_ket\" >L\u1eddi k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_nghia_loi_NA_la_gi\"><\/span><b>\u0110\u1ecbnh ngh\u0129a l\u1ed7i #N\/A l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #N\/A ch\u00ednh l\u00e0 l\u1ed7i b\u1ecb tr\u1ea3 v\u1ec1 trong c\u00f4ng th\u1ee9c excel khi kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u y\u00eau c\u1ea7u. Th\u01b0\u1eddng th\u00ec l\u1ed7i #N\/A hay xu\u1ea5t hi\u1ec7n trong h\u00e0m <\/span><span style=\"font-weight: 400;\">vlookup v\u00e0 h\u00e0m hlookup. C\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft, <\/span><span style=\"font-weight: 400;\">N\/A trong ti\u1ebfng anh ch\u00ednh l\u00e0 t\u1eeb vi\u1ebft t\u1eaft c\u1ee7a Not Available t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 s\u1eb5n, kh\u00f4ng t\u1ed3n t\u1ea1i. Do \u0111\u00f3 n\u00ean <\/span><span style=\"font-weight: 400;\">khi b\u1ea1n th\u1ef1c hi\u1ec7n d\u00f2 t\u00ecm, tham chi\u1ebfu, trong \u0111\u00f3 \u0111\u1ed1i t\u01b0\u1ee3ng d\u00f2 t\u00ecm tham chi\u1ebfu kh\u00f4ng c\u00f3 s\u1eb5n trong v\u00f9ng d\u1eef li\u1ec7u tra c\u1ee9u th\u00ec s\u1ebd x\u1ea3y t\u1edbi l\u1ed7i<\/span><span style=\"font-weight: 400;\"> #N\/A n\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n khi\u1ebfn excel tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A c\u0169ng ch\u00ednh l\u00e0 do d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 s\u1eb5n, d\u1eef li\u1ec7u kh\u00f4ng t\u1ed3n t\u1ea1i.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11886\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-2.jpg\" alt=\"\" width=\"600\" height=\"222\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-2-400x148.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tim_hieu_chi_tiet_ve_nguyen_nhan_dan_toi_loi_na_trong_excel_cua_mot_so_ham\"><\/span><b>T\u00ecm hi\u1ec3u chi ti\u1ebft v\u1ec1 nguy\u00ean nh\u00e2n d\u1eabn t\u1edbi l\u1ed7i na trong excel <\/b><b>c\u1ee7a m\u1ed9t s\u1ed1 h\u00e0m<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi excel th\u01b0\u1eddng x\u1ea3y ra l\u1ed7i #N\/A t\u1ea1i m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0: h\u00e0m Vlookup, h\u00e0m Hlookup, h\u00e0m if, h\u00e0m Match,&#8230;V\u1eady nguy\u00ean nh\u00e2n g\u00ec khi\u1ebfn cho excel tr\u1ea3 v\u1ec1 l\u1ed7i\u00a0 #N\/A n\u00e0y. Chi ti\u1ebft th\u00f4ng tin s\u1ebd \u0111\u01b0\u1ee3c Teky ch\u00fang t\u00f4i gi\u1ea3i \u0111\u00e1p d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n \u0111\u1ea7u ti\u00ean \u0111\u00f3 ch\u00ednh l\u00e0 khi s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y trong excel kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u tham chi\u1ebfu. Do nh\u1eefng n\u1ed9i dung d\u1eef li\u1ec7u b\u1ea1n tham chi\u1ebfu n\u00e0y kh\u00f4ng c\u00f3 trong v\u00f9ng d\u1eef li\u1ec7u khi\u1ebfn b\u1ea1n kh\u00f4ng th\u1ec3 tham chi\u1ebfu, so s\u00e1nh v\u00e0 t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n ti\u1ebfp theo c\u00f3 th\u1ec3 do xu\u1ea5t hi\u1ec7n kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u00f4 tham chi\u1ebfu. \u0110i\u1ec1u n\u00e0y c\u0169ng s\u1ebd khi\u1ebfn cho h\u00e0m b\u1ea1n nh\u1eadp b\u1ecb tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng cho h\u00e0m Vlookup b\u1ea1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p ch\u1ecdn t\u01b0\u01a1ng \u0111\u01b0\u01a1ng thay v\u00ec ph\u01b0\u01a1ng ph\u00e1p t\u00ecm ch\u00ednh x\u00e1c. \u0110\u00e2y c\u0169ng ch\u00ednh l\u00e0 m\u1ed9t trong nh\u1eefng nguy\u00ean do xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A trong excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n l\u00e0 do c\u00f4ng th\u1ee9c m\u1ea3ng tham chi\u1ebfu c\u1ee7a m\u1ed9t d\u00e3y \u00f4 kh\u00f4ng c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng ho\u1eb7c s\u1ed1 c\u1ed9t v\u1edbi d\u1ea3i \u00f4 ch\u1ee9a m\u1ea3ng c\u00f4ng th\u1ee9c. Do \u0111\u00f3 m\u1edbi g\u00e2y ra l\u1ed7i #N\/A trong excel khi\u1ebfn b\u1ea1n c\u1ea3m th\u1ea5y \u0111au \u0111\u1ea7u.\u00a0<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"L\u1ed7i #N\/A khi d\u00f9ng h\u00e0m VLookup v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KMyB0IgFZgs?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_khac_phuc_loi_NA_trong_excel_cuc_don_gian_cho_ban\"><\/span><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i\u00a0 #N\/A trong excel c\u1ef1c \u0111\u01a1n gi\u1ea3n cho b\u1ea1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u1edfi nguy\u00ean do d\u1eabn t\u1edbi l\u1ed7i #N\/A kh\u00f4ng ph\u1ea3i do b\u1ea1n nh\u1eadp sai c\u00f4ng th\u1ee9c m\u00e0 l\u00e0 do kh\u00f4ng t\u00ecm th\u1ea5y th\u00f4ng tin d\u1eef li\u1ec7u, d\u1eef li\u1ec7u kh\u00f4ng t\u1ed3n t\u1ea1i. Do \u0111\u00f3, tr\u01b0\u1eddng h\u1ee3p b\u1ea1n g\u1eb7p ph\u1ea3i l\u1ed7i #N\/A trong excel th\u00ec c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i th\u00f4ng th\u01b0\u1eddng \u0111\u00f3 ch\u00ednh l\u00e0 th\u1ef1c hi\u1ec7n bi\u1ec7n lu\u1eadn tr\u01b0\u1edbc tr\u01b0\u1edbc c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng t\u00ecm gi\u1ea5y gi\u00e1 tr\u1ecb. M\u1ed9t trong nh\u1eefng c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A nhanh \u0111\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IF. S\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng ho\u1eb7c th\u00f4ng b\u00e1o kh\u00f4ng t\u1ed3n t\u1ea1i ch\u1ee9 kh\u00f4ng th\u1ef1c hi\u1ec7n.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3 tr\u01b0\u1eddng h\u1ee3p m\u00e0 lookup_value kh\u00f4ng t\u1ed3n t\u1ea1i ( \u0111\u00e2y l\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng). L\u00fac n\u00e0y b\u1ea1n kh\u00f4ng c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u1ebfn c\u00f4ng th\u1ee9c m\u00e0 k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 r\u1ed7ng ngay.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ki\u1ec3m tra s\u1ef1 t\u1ed3n t\u1ea1i c\u1ee7a lookup_value n\u1ebfu kh\u00f4ng t\u1ed3n t\u1ea1i th\u00ec k\u1ebft qu\u1ea3 hi\u1ec7n ra s\u1ebd l\u00e0 kh\u00f4ng t\u1ed3n t\u1ea1i thay v\u00ec xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A th\u00ec b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00f4ng th\u1ee9c m\u1eabu d\u01b0\u1edbi \u0111\u00e2y;<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3 v\u1ec1 c\u00f4ng th\u1ee9c s\u1eeda l\u1ed7i l\u00e0: =IF(COUNTIF(B2:B15,E9)=0,&#8221;Kh\u00f4ng t\u1ed3n t\u1ea1i&#8221;,MATCH(E2, B2:C15, 0))<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11887\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\" alt=\"\" width=\"600\" height=\"302\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3-400x201.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra c\u00f3 m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u kh\u00f4ng gi\u1ed1ng nhau m\u00e0 \u00edt ai \u0111\u1ec3 \u00fd t\u1edbi. Ch\u1eb3ng h\u1ea1n vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m \u1edf m\u1ed9t v\u1ecb tr\u00ed n\u00e0o \u0111\u00f3 l\u00e0 d\u1ea1ng text nh\u01b0ng c\u0169ng l\u00e0 d\u1eef li\u1ec7u t\u01b0\u01a1ng t\u1ef1 \u0111\u00f3 \u1edf v\u1ecb tr\u00ed kh\u00e1c l\u1ea1i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng date time. Do v\u1eady n\u00ean khi th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng cho Value b\u1ea1n ch\u1ec9 nh\u1eadn l\u1ea1i \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 l\u1ed7i #N\/A. Do \u0111\u00f3, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n x\u00e1c nh\u1eadn v\u00e0 \u0111\u1ecbnh d\u1ea1ng th\u1ed1ng nh\u1ea5t c\u00e1c d\u1eef li\u1ec7u trong b\u1ea3ng c\u0169ng nh\u01b0 c\u00e1c k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_chi_tiet_cach_an_loi_NA_trong_excel_nhanh_chong_cho_ban\"><\/span><b>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u1ea9n l\u1ed7i #N\/A trong excel nhanh ch\u00f3ng cho b\u1ea1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng excel v\u00e0 g\u1eb7p ph\u1ea3i l\u1ed7i #N\/A n\u1ebfu b\u1ea1n mu\u1ed1n \u1ea9n \u0111i l\u1ed7i n\u00e0y th\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 c\u00f3 th\u1ec3 \u1ea9n \u0111i l\u1ed7i #N\/A. Chi ti\u1ebft c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng \u0111\u1ec3 \u1ea9n l\u1ed7i l\u00e0: =IFERROR(value,value_if_error) trong \u0111\u00f3 th\u00ec:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Value ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n nh\u1eadn x\u00e9t trong h\u00e0m<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Value_if_error ch\u00ednh l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi m\u00e0 value b\u00e1o c\u00f3 l\u1ed7i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Th\u01b0\u1eddng khi s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y ng\u01b0\u1eddi ta b\u1eaft l\u1ed7i tr\u1ef1c ti\u1ebfp trong h\u00e0m Vlookup \u0111\u1ed3ng th\u1eddi tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb mong mu\u1ed1n.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11885\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-1.jpg\" alt=\"loi-na-trong-excel (1)\" width=\"600\" height=\"302\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-1-400x201.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_van_xuat_hien_loi_NA_khi_nhin_thay_vung_du_lieu_tham_chieu_trong_dieu_kien_tham_chieu\"><\/span><b>T\u1ea1i sao v\u1eabn xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A khi nh\u00ecn th\u1ea5y v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu trong \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y \u0111\u00e2y ch\u00ednh l\u00e0 m\u1ed9t l\u1ed7i o\u00e1i o\u0103m, kh\u00f3 nh\u1eb1n b\u1edfi r\u00f5 r\u00e0ng b\u1ea1n nh\u00ecn th\u1ea5y d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n trong b\u1ea3ng d\u1eef li\u1ec7u. Th\u1ebf nh\u01b0ng kh\u00f4ng hi\u1ec3u t\u1ea1i sao l\u1ea1i v\u1eabn xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A. V\u1edbi vi\u1ec7c l\u1ed7i #N\/A xu\u1ea5t hi\u1ec7n trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 do \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm hay gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm th\u1eeba m\u1ed9t hay m\u1ed9t s\u1ed1 d\u1ea5u c\u00e1ch \u0111\u1eb1ng sau \u0111\u00f3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t t\u1eebng gi\u00e1 tr\u1ecb. T\u1eeb gi\u00e1 tr\u1ecb gi\u00e1 tr\u1ecb d\u00f9ng l\u00e0m \u0111i\u1ec1u ki\u1ec7n t\u1edbi gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n. Th\u1ef1c hi\u1ec7n nh\u1ea5n ph\u00edm F2, n\u1ebfu b\u1ea1n th\u1ea5y xu\u1ea5t hi\u1ec7n d\u1ea5u nh\u00e1y chu\u1ed9t n\u1eb1m c\u00e1ch xa k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng m\u1ed9t ho\u1eb7c m\u1ed9t v\u00e0i d\u1ea5u c\u00e1ch. Th\u00ec l\u00fac n\u00e0y h\u00e3y th\u1ef1c hi\u1ec7n x\u00f3a h\u1ebft nh\u1eefng d\u1ea5u c\u00e1ch, kho\u1ea3ng tr\u1ed1ng n\u00e0y \u0111i. Th\u1ef1c hi\u1ec7n theo c\u00e1ch n\u00e0y s\u1ebd gi\u00fap b\u1ea1n kh\u1eafc ph\u1ee5c ho\u00e0n to\u00e0n \u0111\u01b0\u1ee3c l\u1ed7i #N\/A x\u1ea3y ra.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span><b>L\u1eddi k\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 nh\u1eefng th\u00f4ng tin ph\u00e2n t\u00edch v\u1ec1 <\/span><b>l\u1ed7i na trong excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 Teky mu\u1ed1n chia s\u1ebb t\u1edbi qu\u00fd b\u1ea1n. Hy v\u1ecdng v\u1edbi nh\u1eefng th\u00f4ng tin ph\u00e2n t\u00edch tr\u00ean s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n c\u0169ng nh\u01b0 c\u00e1ch kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y. \u0110\u1ec3 t\u1eeb \u0111\u00f3 th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh tr\u00ean excel thu\u1eadn l\u1ee3i h\u01a1n.<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/loi-mat-chu-trong-word-nguyen-nhan-thuong-gap-va-cach-xu-ly\/\" target=\"_blank\" rel=\"noopener\">L\u1ed7i m\u1ea5t ch\u1eef trong word: Nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch x\u1eed l\u00fd<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi ph\u1ea7n m\u1ec1m excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady \u0111\u00e2y l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o? \u0110\u1ec3 r\u00f5 h\u01a1n v\u1ec1 l\u1ed7i na trong excel th\u00ec h\u00e3y theo d\u00f5i th\u00f4ng tin b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Teky. \u0110\u1ecbnh ngh\u0129a l\u1ed7i &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11887,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-20T15:07:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:28:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"302\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"L\u1ed7i N\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2022-11-20T15:07:34+00:00\",\"dateModified\":\"2022-12-06T07:28:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\"},\"wordCount\":1775,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\",\"name\":\"L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\",\"datePublished\":\"2022-11-20T15:07:34+00:00\",\"dateModified\":\"2022-12-06T07:28:23+00:00\",\"description\":\"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg\",\"width\":600,\"height\":302},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"L\u1ed7i N\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3","description":"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?","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:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3","og_description":"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?","og_url":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-20T15:07:34+00:00","article_modified_time":"2022-12-06T07:28:23+00:00","og_image":[{"width":600,"height":302,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"L\u1ed7i N\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3","datePublished":"2022-11-20T15:07:34+00:00","dateModified":"2022-12-06T07:28:23+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/"},"wordCount":1775,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/","name":"L\u1ed7i na trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg","datePublished":"2022-11-20T15:07:34+00:00","dateModified":"2022-12-06T07:28:23+00:00","description":"Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u00f4i khi b\u1ea1n s\u1ebd th\u1ea5y l\u1ed7i #N\/A. V\u1eady l\u1ed7i na trong excel l\u00e0 l\u1ed7i g\u00ec, nguy\u00ean nh\u00e2n c\u00f9ng c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/loi-na-trong-excel-3.jpg","width":600,"height":302},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/loi-na-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"L\u1ed7i N\/A trong excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11880"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11880\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11887"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}