{"id":7858,"date":"2024-12-21T18:39:42","date_gmt":"2024-12-21T18:39:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-error-type\/"},"modified":"2024-12-21T18:39:42","modified_gmt":"2024-12-21T18:39:42","slug":"phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-error-type","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-error-type\/","title":{"rendered":"Ph\u00e2n lo\u1ea1i c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Excel v\u1edbi h\u00e0m ERROR.TYPE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><a href=\"http:\/\/blog.ezworkapp.com\/ham-error-type.html\"><strong>H\u00e0m ERROR.TYPE<\/strong><\/a> s\u1ebd gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng ki\u1ec3m tra l\u1ed7i v\u00e0 lo\u1ea1i l\u1ed7i trong Excel. C\u1ee5 th\u1ec3<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/em><\/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-67670b6d31158\" 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-error-type.html#Ham_ERRORTYPE\" title=\"H\u00e0m ERROR.TYPE\">H\u00e0m ERROR.TYPE<\/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-error-type.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-error-type.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-error-type.html#Su_dung_ERRORTYPE_phan_loai_loi\" title=\"S\u1eed d\u1ee5ng ERROR.TYPE ph\u00e2n lo\u1ea1i l\u1ed7i\">S\u1eed d\u1ee5ng ERROR.TYPE ph\u00e2n lo\u1ea1i l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-error-type.html#Su_dung_ERRORTYPE_dua_ra_thong_bao_loi\" title=\"S\u1eed d\u1ee5ng ERROR.TYPE \u0111\u01b0a ra th\u00f4ng b\u00e1o l\u1ed7i\">S\u1eed d\u1ee5ng ERROR.TYPE \u0111\u01b0a ra th\u00f4ng b\u00e1o l\u1ed7i<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_ERRORTYPE\"><\/span>H\u00e0m ERROR.TYPE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m ERROR.TYPE trong Excel s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1eebng lo\u1ea1i l\u1ed7i. Trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 l\u1ed7i n\u00e0o t\u1ea1i c\u00f4ng th\u1ee9c, h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0<strong>#N\/A<\/strong>.<\/p>\n<p>B\u1ea3ng gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30431 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-error-type-1.png\" alt=\"phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-ERROR.TYPE-1\" width=\"334\" height=\"343\" title=\"ham-error-type-1\"><\/p>\n<p>Trong phi\u00ean b\u1ea3n Excel 365, Excel \u0111\u00e3 b\u1ed5 sung th\u00eam c\u00e1c l\u1ed7i m\u1edbi li\u00ean quan t\u1edbi <strong><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-mang-dong-vung-tran-trong-excel.html\">M\u1ea3ng \u0111\u1ed9ng \u2013 Dynamic Array Range<\/a>\u00a0<\/strong>c\u00f3 th\u1ec3 ki\u1ec3m tra b\u1eb1ng h\u00e0m <strong>ERROR.TYPE\u00a0<\/strong>bao g\u1ed3m:<\/p>\n<p><strong>#SPILL! \u2013 9<\/strong><\/p>\n<p>#<strong>UNKNOWN! \u2013 10<\/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-706.gif\" title=\"ex101_92019-nho-706\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>#<strong>FIELD! \u2013 11<\/strong><\/p>\n<p><strong>#CALC! \u2013 12<\/strong><\/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 \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ERROR.TYPE(gi\u00e1 tr\u1ecb l\u1ed7i)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3 gi\u00e1 tr\u1ecb l\u1ed7i c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp tr\u1ef1c ti\u1ebfp ho\u1eb7c l\u00e0 m\u1ed9t tham chi\u1ebfu.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ERRORTYPE_phan_loai_loi\"><\/span>S\u1eed d\u1ee5ng ERROR.TYPE ph\u00e2n lo\u1ea1i l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng ph\u00e2n lo\u1ea1i c\u00e1c l\u1ed7i v\u1edbi h\u00e0m ERROR.TYPE, qua \u0111\u00f3 tr\u00e1nh \u0111\u01b0\u1ee3c vi\u1ec7c l\u1eb7p l\u1ea1i sai s\u00f3t v\u00e0 c\u00f3 gi\u1ea3i ph\u00e1p s\u1eeda ch\u1eefa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30435 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-error-type-2.png\" alt=\"phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-ERROR.TYPE-2\" width=\"708\" height=\"379\" title=\"ham-error-type-2\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ERRORTYPE_dua_ra_thong_bao_loi\"><\/span>S\u1eed d\u1ee5ng ERROR.TYPE \u0111\u01b0a ra th\u00f4ng b\u00e1o l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1eb1ng vi\u1ec7c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ERROR.TYPE \u0111\u01b0a ra th\u00f4ng b\u00e1o l\u1ed7i c\u1ee5 th\u1ec3 trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p, ch\u1eb3ng h\u1ea1n:<\/p>\n<p><em><strong>=IF(ERROR.TYPE(E2\/F2)&lt;&gt;2,\u201dB\u00ecnh th\u01b0\u1eddng\u201d,\u201dL\u1ed7i chia cho 0\u2033)<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30436 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-error-type-3.png\" alt=\"phan-loai-cac-loi-thuong-gap-trong-excel-voi-ham-ERROR.TYPE-3\" width=\"546\" height=\"302\" title=\"ham-error-type-3\"><\/p>\n<hr>\n<p>Ngo\u00e0i vi\u1ec7c ph\u00e2n lo\u1ea1i hay \u0111\u01b0a ra th\u00f4ng b\u00e1o, Excel c\u00f2n cung c\u1ea5p cho ta nh\u1eefng h\u00e0m v\u00e0 c\u00e1ch \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i. Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\">C\u00e1c l\u1ed7i trong Excel v\u00e0 c\u00e1ch s\u1eeda<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\"><strong>X\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\"><strong>Nh\u1eadn bi\u1ebft v\u00e0 b\u1eaby l\u1ed7i trong Excel<\/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-706.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7859,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7858","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\/7858","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=7858"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7858\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7859"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}