{"id":4303,"date":"2024-12-04T17:30:10","date_gmt":"2024-12-04T17:30:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/loi-value-ref-num-n-a-div-0-name-null-trong-excel-va-cach-sua\/"},"modified":"2024-12-04T17:30:10","modified_gmt":"2024-12-04T17:30:10","slug":"loi-value-ref-num-n-a-div-0-name-null-trong-excel-va-cach-sua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/loi-value-ref-num-n-a-div-0-name-null-trong-excel-va-cach-sua\/","title":{"rendered":"L\u1ed7i #VALUE!, #REF!, #NUM, #N\/A, #DIV\/0!, #NAME?, #NULL! trong Excel v\u00e0 c\u00e1ch s\u1eeda"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Khi l\u00e0m vi\u1ec7c v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html\">c\u00f4ng th\u1ee9c trong Excel<\/a>, r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n m\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng gi\u00e1 tr\u1ecb nh\u01b0 sau b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u <strong>#<\/strong> nh\u01b0: l\u1ed7i <strong>#VALUE!, l\u1ed7i #REF!, l\u1ed7i #NUM, l\u1ed7i #N\/A, l\u1ed7i #DIV\/0!, l\u1ed7i #NAME? <\/strong>hay<strong> l\u1ed7i#NULL! <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i Excel n\u00e0y<\/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-675091a137b66\" 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\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cac_loi_cong_thuc_hay_gap_trong_Excel_co_ban\" title=\"C\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c hay g\u1eb7p trong Excel c\u01a1 b\u1ea3n\">C\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c hay g\u1eb7p trong Excel c\u01a1 b\u1ea3n<\/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\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_NUM_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #NUM! trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #NUM! trong Excel<\/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\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Nguyen_nhan_gay_loi_NUM_trong_Excel\" title=\"Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i #NUM! trong Excel\">Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i #NUM! trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_VALUE_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #VALUE! trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! trong Excel<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Nguyen_nhan_gay_loi_VALUE_trong_Excel\" title=\"Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i #VALUE!\u00a0trong Excel\">Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i #VALUE!\u00a0trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_NA_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #N\/A\u00a0trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #N\/A\u00a0trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_DIV0_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #DIV\/0! trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #DIV\/0! trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_REF_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_REF_do_xoa_vung_tham_chieu_trong_cong_thuc\" title=\"L\u1ed7i #REF! do xo\u00e1 v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c\">L\u1ed7i #REF! do xo\u00e1 v\u00f9ng tham chi\u1ebfu trong 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-10\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_REF_do_su_dung_gia_tri_cho_tham_so_khong_phu_hop_trong_ham_VLOOKUP\" title=\"L\u1ed7i #REF! do s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb cho tham s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p trong h\u00e0m VLOOKUP\">L\u1ed7i #REF! do s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb cho tham s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p trong h\u00e0m VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_REF_do_su_dung_tham_so_Row_hoac_Column_cua_ham_Index_khong_phu_hop\" title=\"L\u1ed7i #REF! do s\u1eed d\u1ee5ng tham s\u1ed1 Row ho\u1eb7c Column c\u1ee7a h\u00e0m Index kh\u00f4ng ph\u00f9 h\u1ee3p\">L\u1ed7i #REF! do s\u1eed d\u1ee5ng tham s\u1ed1 Row ho\u1eb7c Column c\u1ee7a h\u00e0m Index kh\u00f4ng ph\u00f9 h\u1ee3p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_REF_khi_su_dung_ham_Indirect_tham_chieu_toi_file_excel_dong\" title=\"L\u1ed7i #REF! khi s\u1eed d\u1ee5ng h\u00e0m Indirect tham chi\u1ebfu t\u1edbi file excel \u0111\u00f3ng\">L\u1ed7i #REF! khi s\u1eed d\u1ee5ng h\u00e0m Indirect tham chi\u1ebfu t\u1edbi file excel \u0111\u00f3ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_NAME_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #NAME?\u00a0trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #NAME?\u00a0trong Excel<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_do_viet_sai_ten_ham\" title=\"L\u1ed7i #NAME? do vi\u1ebft sai t\u00ean h\u00e0m\">L\u1ed7i #NAME? do vi\u1ebft sai t\u00ean h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_khi_name_su_dung_chua_duoc_khai_bao_trong_Excel\" title=\"L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng ch\u01b0a \u0111\u01b0\u1ee3c khai b\u00e1o trong Excel\">L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng ch\u01b0a \u0111\u01b0\u1ee3c khai b\u00e1o trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_khi_name_su_dung_bi_viet_sai_trong_Excel\" title=\"L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng b\u1ecb vi\u1ebft sai trong Excel\">L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng b\u1ecb vi\u1ebft sai trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_do_du_lieu_kieu_chu_khong_co_dau_ngoac_kep_bao_quanh\" title=\"L\u1ed7i #NAME! do d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef kh\u00f4ng c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p bao quanh\">L\u1ed7i #NAME! do d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef kh\u00f4ng c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p bao quanh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_do_thieu_dau_ngan_cach_giua_dia_chi_vung_trong_Excel\" title=\"L\u1ed7i #NAME! do thi\u1ebfu d\u1ea5u : ng\u0103n c\u00e1ch gi\u1eefa \u0111\u1ecba ch\u1ec9 v\u00f9ng trong Excel\">L\u1ed7i #NAME! do thi\u1ebfu d\u1ea5u : ng\u0103n c\u00e1ch gi\u1eefa \u0111\u1ecba ch\u1ec9 v\u00f9ng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Loi_NAME_do_su_dung_1_ham_ho_tro_boi_Addin_nhung_Addin_chua_duoc_cai_dat\" title=\"L\u1ed7i #NAME! do s\u1eed d\u1ee5ng 1 h\u00e0m h\u1ed7 tr\u1ee3 b\u1edfi Addin nh\u01b0ng Addin ch\u01b0a \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t\">L\u1ed7i #NAME! do s\u1eed d\u1ee5ng 1 h\u00e0m h\u1ed7 tr\u1ee3 b\u1edfi Addin nh\u01b0ng Addin ch\u01b0a \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html#Cach_sua_loi_NULL_trong_Excel\" title=\"C\u00e1ch s\u1eeda l\u1ed7i #NULL! trong Excel\">C\u00e1ch s\u1eeda l\u1ed7i #NULL! trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_loi_cong_thuc_hay_gap_trong_Excel_co_ban\"><\/span>C\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c hay g\u1eb7p trong Excel c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00a0<\/p>\n<p>L\u01b0u \u00fd: N\u1ebfu n\u1ed9i dung trong 1 \u00f4 Excel sau khi th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c l\u00e0 ####, th\u00ec nhi\u1ec1u kh\u1ea3 n\u0103ng \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t l\u1ed7i c\u00f4ng th\u1ee9c m\u00e0 \u0111\u01a1n gi\u1ea3n l\u00e0 chi\u1ec1u r\u1ed9ng c\u1ee7a c\u1ed9t c\u00f3 ch\u1ee9a \u00f4 \u0111\u00f3 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 n\u1ed9i dung, \u0111\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o th\u1ebb <strong>Home &gt; Format &gt; AutoFit Column Width<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/chinh-do-rong-cua-o-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chinh-do-rong-cua-o-trong-excel.png\" alt=\"chinh-do-rong-cua-o-trong-excel\" width=\"178\" height=\"222\" title=\"chinh-do-rong-cua-o-trong-excel\"><\/a><\/p>\n<p>Sau \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eeda t\u1eebng l\u1ed7i ph\u00eda tr\u00ean:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_NUM_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #NUM! trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_nhan_gay_loi_NUM_trong_Excel\"><\/span>Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i <strong>#NUM!<\/strong> trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u1ed7i <strong>#NUM!\u00a0<\/strong>trong Excel th\u01b0\u1eddng x\u1ea3y ra:<\/p>\n<ul>\n<li>Khi m\u1ed9t c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u tham s\u1ed1 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 nh\u01b0ng l\u1ea1i \u0111\u01b0\u1ee3c ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0a v\u00e0o m\u1ed9t gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<li>Khi k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh trong Excel qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 nh\u1ecf<\/li>\n<\/ul>\n<figure id=\"attachment_11549\" aria-describedby=\"caption-attachment-11549\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/cach-sua-loi-num-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-11549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-sua-loi-num-trong-excel-1024x576-1.png\" alt=\"cach-sua-loi-num-trong-excel\" width=\"1024\" height=\"576\" title=\"cach-sua-loi-num-trong-excel-1024x576-1\"><\/a><figcaption id=\"caption-attachment-11549\" class=\"wp-caption-text\">M\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c g\u00e2y ra l\u1ed7i #NUM! trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_VALUE_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/hoc-excel-co-ban-cach-sua-loi-value-khi-su-dung-ham-average-va-ham-sum-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_nhan_gay_loi_VALUE_trong_Excel\"><\/span>Nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i <strong>#VALUE!\u00a0<\/strong>trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 th\u1ec3 n\u00f3i, l\u1ed7i <strong>#VALUE!\u00a0<\/strong>l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i hay g\u1eb7p nh\u1ea5t khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel. \u0110\u00e2y l\u00e0 c\u00e1ch Excel th\u00f4ng b\u00e1o cho ch\u00fang ta r\u1eb1ng c\u00f3 v\u1ea5n \u0111\u1ec1 v\u1edbi c\u00f4ng th\u1ee9c ho\u1eb7c v\u00f9ng b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c tham chi\u1ebfu. V\u1ea5n \u0111\u1ec1 \u1edf \u0111\u00e2y l\u00e0 g\u00ec th\u00ec tu\u1ef3 v\u00e0o c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng:<\/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-344.gif\" title=\"ex101_92019-nho-344\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><a href=\"https:\/\/blog.hocexcel.online\/hoc-excel-co-ban-cach-sua-loi-value-khi-su-dung-ham-average-va-ham-sum-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m AVERAGE v\u00e0 h\u00e0m SUM trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-countif-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m COUNTIF \/ COUNTIFS trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/loi-value-cua-ham-vlookup-nguyen-nhan-va-cach-khac-phuc.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-find-hoac-search-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m FIND ho\u1eb7c SEARCH trong Excel<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_NA_trong_Excel\"><\/span>C\u00e1ch s\u1eeda l\u1ed7i #N\/A\u00a0trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u00f3i chung l\u1ed7i #N\/A x\u1ea3y ra khi c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm VLOOKUP, HLOOKUP, MATCH, LOOKUP kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/cach-sua-loi-na-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11590\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-sua-loi-na-trong-excel.png\" alt=\"cach-sua-loi-na-trong-excel\" width=\"280\" height=\"269\" title=\"cach-sua-loi-na-trong-excel\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>L\u1ed3ng c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm v\u1edbi h\u00e0m x\u1eed l\u00fd l\u1ed7i IFNA ho\u1eb7c IFERROR \u0111\u1ec3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 kh\u00f4ng b\u1ecb l\u1ed7i #NA<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_DIV0_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #DIV\/0! trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>L\u1ed7i #DIV\/0! x\u1ea3y ra khi trong 1 c\u00f4ng th\u1ee9c Excel xu\u1ea5t hi\u1ec7n ph\u00e9p chia cho 0. V\u00ec ph\u00e9p chia cho 0 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a trong to\u00e1n h\u1ecdc n\u00ean \u0111\u00e2y l\u00e0 1 l\u1ed7i v\u00e0 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng #DIV\/0! trong Excel:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-chia-cho-khong-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11591\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-chia-cho-khong-trong-excel.png\" alt=\"loi-chia-cho-khong-trong-excel\" width=\"433\" height=\"120\" title=\"loi-chia-cho-khong-trong-excel\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>\u0110\u1ea3m b\u1ea3o r\u1eb1ng m\u1eabu s\u1ed1 c\u1ee7a c\u00e1c ph\u00e2n s\u1ed1 kh\u00f4ng b\u1eb1ng 0 ho\u1eb7c c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 chia kh\u00f4ng r\u1ed7ng khi th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 ph\u00e9p t\u00ednh to\u00e1n trong Excel. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00eam h\u00e0m IFERROR \u0111\u1ec3 ki\u1ec3m so\u00e1t l\u1ed7i g\u1eb7p ph\u1ea3i n\u1ebfu c\u00f3 kh\u1ea3 n\u0103ng x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p chia cho 0 trong d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_REF_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Loi_REF_do_xoa_vung_tham_chieu_trong_cong_thuc\"><\/span>L\u1ed7i #REF! do xo\u00e1 v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u1ed7i #REF! th\u01b0\u1eddng x\u1ea3y ra khi v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c Excel b\u1ecb xo\u00e1 ho\u1eb7c b\u1ecb ghi \u0111\u00e8 l\u00ean.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/sua-loi-ref-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11594\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sua-loi-ref-trong-excel-01.png\" alt=\"sua-loi-ref-trong-excel-01\" width=\"445\" height=\"213\" title=\"sua-loi-ref-trong-excel-01\"><\/a><\/p>\n<p>Sau khi c\u1ed9t trong c\u00f4ng th\u1ee9c b\u1ecb xo\u00e1, l\u1ed7i #REF! s\u1ebd ph\u00e1t sinh:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/sua-loi-ref-trong-excel-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11595\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sua-loi-ref-trong-excel-02.png\" alt=\"sua-loi-ref-trong-excel-02\" width=\"393\" height=\"212\" title=\"sua-loi-ref-trong-excel-02\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong><\/p>\n<ul>\n<li>N\u1ebfu b\u1ea1n l\u1ee1 tay xo\u00e1 nh\u1ea7m c\u1ed9t th\u00ec h\u00e3y s\u1eed d\u1ee5ng ph\u00edm t\u1eaft CTRL + Z \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y l\u1ea1i c\u1ed9t v\u1eeba b\u1ecb xo\u00e1 (ch\u1ee9c n\u0103ng Undo)<\/li>\n<li>Ngo\u00e0i ra \u0111\u1ec3 h\u1ea1n ch\u1ebf vi\u1ec7c x\u1ea3y ra l\u1ed7i #REF!, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c s\u1eafp theo c\u00fa ph\u00e1p =SUM(B2:D2)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Loi_REF_do_su_dung_gia_tri_cho_tham_so_khong_phu_hop_trong_ham_VLOOKUP\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\" target=\"_blank\" rel=\"noopener noreferrer\">L\u1ed7i #REF! do s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb cho tham s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p trong h\u00e0m VLOOKUP<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/sua-loi-ham-ref-trong-cong-thuc-vlookup.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11596\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sua-loi-ham-ref-trong-cong-thuc-vlookup.png\" alt=\"sua-loi-ham-ref-trong-cong-thuc-vlookup\" width=\"462\" height=\"303\" title=\"sua-loi-ham-ref-trong-cong-thuc-vlookup\"><\/a><\/p>\n<p>Nh\u01b0 c\u00e1c b\u1ea1n th\u1ea5y trong h\u00ecnh minh ho\u1ea1 ph\u00eda tr\u00ean, v\u00f9ng tra c\u1ee9u ch\u1ec9 c\u00f3 4 c\u1ed9t, nh\u01b0ng tham s\u1ed1 column_index c\u1ee7a h\u00e0m vlookup l\u1ea1i \u0111\u01b0a ra gi\u00e1 tr\u1ecb = 5, v\u1eady n\u00ean \u1edf \u0111\u00e2y k\u1ebft qu\u1ea3 l\u00e0 h\u00e0m VLOOKUP tr\u1ea3 v\u1ec1 l\u1ed7i #REF!<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>S\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c VLOOKUP cho ph\u00f9 h\u1ee3p\u00a0<i class=\"ocpItalic\">=VLOOKUP(A8,A2:D5,4,FALSE)<\/i><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_REF_do_su_dung_tham_so_Row_hoac_Column_cua_ham_Index_khong_phu_hop\"><\/span>L\u1ed7i #REF! do s\u1eed d\u1ee5ng tham s\u1ed1 Row ho\u1eb7c Column c\u1ee7a h\u00e0m Index kh\u00f4ng ph\u00f9 h\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/cach-sua-loi-ref-voi-ham-index.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11597\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-sua-loi-ref-voi-ham-index.png\" alt=\"cach-sua-loi-ref-voi-ham-index\" width=\"448\" height=\"304\" title=\"cach-sua-loi-ref-voi-ham-index\"><\/a><\/p>\n<p>Trong c\u00f4ng th\u1ee9c INDEX \u1edf h\u00ecnh tr\u00ean, tham s\u1ed1 ROW v\u00e0 COLUMN \u0111\u1ec1u l\u00e0 5, v\u01b0\u1ee3t qu\u00e1 k\u00edch th\u01b0\u1edbc c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u B2:E5 n\u00ean \u0111\u00e3 g\u00e2y ra l\u1ed7i #REF!<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>S\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c cho ph\u00f9 h\u1ee3p:\u00a0\u00a0<i class=\"ocpItalic\">=INDEX(B2:E5,4,4)<\/i><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_REF_khi_su_dung_ham_Indirect_tham_chieu_toi_file_excel_dong\"><\/span>L\u1ed7i #REF! khi s\u1eed d\u1ee5ng h\u00e0m Indirect tham chi\u1ebfu t\u1edbi file excel \u0111\u00f3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-ref-khi-su-dung-ham-indirect.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11598\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-ref-khi-su-dung-ham-indirect.png\" alt=\"loi-ref-khi-su-dung-ham-indirect\" width=\"305\" height=\"199\" title=\"loi-ref-khi-su-dung-ham-indirect\"><\/a><\/p>\n<p>Khi tham chi\u1ebfu t\u1edbi m\u1ed9t file Excel \u0111ang \u0111\u00f3ng trong h\u00e0m Indirect, h\u00e0m n\u00e0y s\u1ebd cho l\u1ed7i #REF!<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>M\u1edf file Excel \u0111ang \u0111\u00f3ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_NAME_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #NAME?\u00a0trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_do_viet_sai_ten_ham\"><\/span>L\u1ed7i #NAME? do vi\u1ebft sai t\u00ean h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-name-do-viet-sai-ten-ham-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11600\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-name-do-viet-sai-ten-ham-excel.png\" alt=\"loi-name-do-viet-sai-ten-ham-excel\" width=\"437\" height=\"173\" title=\"loi-name-do-viet-sai-ten-ham-excel\"><\/a><\/p>\n<p>L\u00fd do th\u01b0\u1eddng g\u1eb7p nh\u1ea5t khi c\u00f3 l\u1ed7i <strong>#NAME?\u00a0<\/strong>l\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp sai t\u00ean h\u00e0m \u1edf trong Excel. Khi nh\u1eadp sai t\u00ean h\u00e0m th\u00ec Excel s\u1ebd kh\u00f4ng g\u1ee3i \u00fd ch\u1ee9c n\u0103ng v\u00e0 c\u00e1c tham s\u1ed1 t\u01b0\u01a1ng \u1ee9ng c\u1ee7a h\u00e0m \u0111\u00f3 (Ph\u1ea7n l\u1edbn c\u00e1c h\u00e0m \u0111\u1ec1u nh\u01b0 v\u1eady, tr\u1eeb 1 s\u1ed1 h\u00e0m \u0111\u1eb7c bi\u1ec7t nh\u01b0 Datedif)<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>Ki\u1ec3m tra l\u1ea1i t\u00ean h\u00e0m \u0111\u00e3 \u0111\u01b0\u1ee3c vi\u1ebft \u0111\u00fang ch\u01b0a v\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng <strong>Function Arguments<\/strong>\u00a0nh\u01b0 h\u00ecnh d\u01b0\u1edbi<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/function-arguments-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11601\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/function-arguments-excel.png\" alt=\"function-arguments-excel\" width=\"592\" height=\"330\" title=\"function-arguments-excel\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_khi_name_su_dung_chua_duoc_khai_bao_trong_Excel\"><\/span>L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng ch\u01b0a \u0111\u01b0\u1ee3c khai b\u00e1o trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5: name \u201cProfit\u201d trong c\u00f4ng th\u1ee9c sau \u0111\u00e2y ch\u01b0a \u0111\u01b0\u1ee3c khai b\u00e1o trong Excel<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-name-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11603\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-name-trong-excel-01.png\" alt=\"loi-name-trong-excel-01\" width=\"177\" height=\"371\" title=\"loi-name-trong-excel-01\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>Khai b\u00e1o t\u00ean n\u00e0y trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Name Manager<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_khi_name_su_dung_bi_viet_sai_trong_Excel\"><\/span>L\u1ed7i #NAME! khi name s\u1eed d\u1ee5ng b\u1ecb vi\u1ebft sai trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi t\u00ean (name) \u0111\u00e3 \u0111\u01b0\u1ee3c khai b\u00e1o trong Excel nh\u01b0ng b\u1ecb vi\u1ebft sai c\u0169ng s\u1ebd g\u00e2y ra l\u1ed7i #NAME!<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-name-trong-excel-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11604\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-name-trong-excel-02.png\" alt=\"loi-name-trong-excel-02\" width=\"184\" height=\"371\" title=\"loi-name-trong-excel-02\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>S\u1eeda l\u1ea1i t\u00ean n\u00e0y trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Name Manager<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_do_du_lieu_kieu_chu_khong_co_dau_ngoac_kep_bao_quanh\"><\/span>L\u1ed7i #NAME! do d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef kh\u00f4ng c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p bao quanh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-name-trong-excel-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11606\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-name-trong-excel-03.png\" alt=\"loi-name-trong-excel-03\" width=\"472\" height=\"200\" title=\"loi-name-trong-excel-03\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 b\u1ed5 sung ngo\u1eb7c k\u00e9p \u0111\u00fang ch\u1ed7<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_do_thieu_dau_ngan_cach_giua_dia_chi_vung_trong_Excel\"><\/span>L\u1ed7i #NAME! do thi\u1ebfu d\u1ea5u : ng\u0103n c\u00e1ch gi\u1eefa \u0111\u1ecba ch\u1ec9 v\u00f9ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-name-trong-excel-04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11607\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-name-trong-excel-04.png\" alt=\"loi-name-trong-excel-04\" width=\"444\" height=\"174\" title=\"loi-name-trong-excel-04\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 b\u1ed5 sung d\u1ea5u hai ch\u1ea5m \u0111\u00fang ch\u1ed7<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_NAME_do_su_dung_1_ham_ho_tro_boi_Addin_nhung_Addin_chua_duoc_cai_dat\"><\/span>L\u1ed7i #NAME! do s\u1eed d\u1ee5ng 1 h\u00e0m h\u1ed7 tr\u1ee3 b\u1edfi Addin nh\u01b0ng Addin ch\u01b0a \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 b\u1edfi Addin ho\u1eb7c l\u00e0 1 h\u00e0m UDF t\u1ef1 vi\u1ebft v\u00e0 kh\u00f4ng c\u00f3 trong Workbook b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>C\u00e0i \u0111\u1eb7t b\u1ed5 sung Addin ho\u1eb7c Code c\u1ee7a UDF<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_NULL_trong_Excel\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eeda l\u1ed7i #NULL! trong Excel<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>L\u1ed7i #NULL! x\u1ea3y ra khi c\u00f4ng th\u1ee9c l\u1ea5y ph\u1ea7n giao nhau gi\u1eefa 2 v\u00f9ng kh\u00f4ng giao nhau. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-null-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11609\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-null-trong-excel-300x145-1.png\" alt=\"loi-null-trong-excel\" width=\"300\" height=\"145\" title=\"loi-null-trong-excel-300x145-1\"><\/a><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 qua b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 th\u1ed1ng k\u00ea cho c\u00e1c b\u1ea1n c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c trong Excel. Hi v\u1ecdng b\u1ea1n s\u1ebd h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i n\u00e0y trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel \u0111\u1ec3 tr\u1edf n\u00ean hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/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-344.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4304,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4303","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\/4303","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=4303"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4304"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}