{"id":10746,"date":"2025-01-14T23:29:53","date_gmt":"2025-01-14T23:29:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly\/"},"modified":"2025-01-14T23:29:53","modified_gmt":"2025-01-14T23:29:53","slug":"tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 v\u00f2ng t\u00ednh l\u1eb7p trong Excel v\u00e0 c\u00e1ch x\u1eed l\u00fd"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong khi s\u1eed d\u1ee5ng\u00a0Excel,\u00a0\u0111\u00f4i khi ch\u00fang ta m\u1edf 1 file\u00a0excel l\u00ean v\u00e0 g\u1eb7p ph\u1ea3i th\u00f4ng b\u00e1o nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12926 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic01-9.png\" width=\"1320\" height=\"210\" title=\"pic01-9\"><\/p>\n<p>\u0110\u00e2y ch\u00ednh l\u00e0 th\u00f4ng b\u00e1o trong file c\u00f3 ch\u1ee9a ph\u00e9p t\u00ednh b\u1ecb l\u1eb7p theo v\u00f2ng (<em>Circular references<\/em>). Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u xem v\u00f2ng l\u1eb7p l\u00e0 th\u1ebf n\u00e0o v\u00e0 c\u00e1ch x\u1eed l\u00fd nh\u00e9:<\/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-6786f370e8056\" 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\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly.html#The_nao_la_vong_tinh_lap_vong_lap_tham_chieu_vong_tron_tham_chieu_vong_lap\" title=\"Th\u1ebf n\u00e0o l\u00e0 v\u00f2ng t\u00ednh l\u1eb7p (v\u00f2ng l\u1eb7p\u00a0\/ tham chi\u1ebfu v\u00f2ng tr\u00f2n\u00a0\/ tham chi\u1ebfu v\u00f2ng l\u1eb7p)\">Th\u1ebf n\u00e0o l\u00e0 v\u00f2ng t\u00ednh l\u1eb7p (v\u00f2ng l\u1eb7p\u00a0\/ tham chi\u1ebfu v\u00f2ng tr\u00f2n\u00a0\/ tham chi\u1ebfu v\u00f2ng l\u1eb7p)<\/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\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly.html#Cach_tim_vi_tri_bi_vong_lap_khi_khong_ro_vi_tri_do_o_dau\" title=\"C\u00e1ch t\u00ecm v\u1ecb tr\u00ed b\u1ecb v\u00f2ng l\u1eb7p khi kh\u00f4ng r\u00f5 v\u1ecb tr\u00ed \u0111\u00f3\u00a0\u1edf\u00a0\u0111\u00e2u?\">C\u00e1ch t\u00ecm v\u1ecb tr\u00ed b\u1ecb v\u00f2ng l\u1eb7p khi kh\u00f4ng r\u00f5 v\u1ecb tr\u00ed \u0111\u00f3\u00a0\u1edf\u00a0\u0111\u00e2u?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly.html#Cach_xu_ly_khi_gap_vong_lap\" title=\"C\u00e1ch x\u1eed l\u00fd khi g\u1eb7p v\u00f2ng l\u1eb7p:\">C\u00e1ch x\u1eed l\u00fd khi g\u1eb7p v\u00f2ng l\u1eb7p:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly.html#Truong_hop_1_su_dung_tham_chieu_vong_vong_tinh_lap\" title=\"Tr\u01b0\u1eddng h\u1ee3p 1: s\u1eed d\u1ee5ng tham chi\u1ebfu v\u00f2ng (v\u00f2ng t\u00ednh l\u1eb7p)\">Tr\u01b0\u1eddng h\u1ee3p 1: s\u1eed d\u1ee5ng tham chi\u1ebfu v\u00f2ng (v\u00f2ng t\u00ednh l\u1eb7p)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-vong-tinh-lap-trong-excel-va-cach-xu-ly.html#Truong_hop_2_Loai_bo_vong_lap\" title=\"Tr\u01b0\u1eddng h\u1ee3p 2: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p\">Tr\u01b0\u1eddng h\u1ee3p 2: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_nao_la_vong_tinh_lap_vong_lap_tham_chieu_vong_tron_tham_chieu_vong_lap\"><\/span><strong>Th\u1ebf n\u00e0o l\u00e0 v\u00f2ng t\u00ednh l\u1eb7p (v\u00f2ng l\u1eb7p\u00a0\/ tham chi\u1ebfu v\u00f2ng tr\u00f2n\u00a0\/ tham chi\u1ebfu v\u00f2ng l\u1eb7p)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong v\u00ed d\u1ee5\u00a0\u1edf h\u00ecnh tr\u00ean, khi ch\u00fang ta b\u1ea5m v\u00e0o n\u00fat OK trong th\u00f4ng b\u00e1o, n\u1ebfu t\u1ea1i sheet\u00a0\u0111ang m\u1edf ch\u1ee9a v\u00f2ng l\u1eb7p, s\u1ebd ngay l\u1eadp t\u1ee9c hi\u1ec7n l\u00ean cho ch\u00fang ta n\u1ed9i dung sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12928 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic02-9.png\" width=\"386\" height=\"224\" title=\"pic02-9\"><\/p>\n<p>T\u1ea1i v\u1ecb tr\u00ed c\u00f3 c\u00f4ng th\u1ee9c, c\u00f3 n\u00fat m\u0169i t\u00ean m\u00e0u xanh n\u1ed1i hai d\u1ea5u ch\u1ea5m xanh t\u1ea1i 2\u00a0\u00f4, m\u00e0 t\u1ea1i c\u00e1c\u00a0\u00f4\u00a0\u0111\u00f3\u00a0\u0111ang c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c l\u1eb7p l\u1ea1i k\u1ebft qu\u1ea3 c\u1ee7a nhau.<\/p>\n<p>V\u00e0\u00a0\u1edf ph\u00eda d\u01b0\u1edbi Sheet Tab (danh s\u00e1ch c\u00e1c Sheet), ch\u00fang ta th\u1ea5y c\u00f3 d\u00f2ng ch\u1eef th\u00f4ng b\u00e1o: Circular References: C1, t\u1ee9c l\u00e0 th\u00f4ng b\u00e1o v\u00f2ng l\u1eb7p\u00a0\u0111ang c\u00f3 v\u1ea5n\u00a0\u0111\u1ec1 t\u1ea1i v\u1ecb tr\u00ed\u00a0\u00f4 C1.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-16.gif\" title=\"vba101_92019-nho-16\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2025\/01\/ex101_92019-nho-217.gif\" title=\"ex101_92019-nho-217\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u00fang ta c\u00f9ng xem c\u00f4ng th\u1ee9c t\u1ea1i c\u00e1c\u00a0\u00f4 n\u00e0y th\u1ebf n\u00e0o nh\u00e9:<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 A1 =SUM(C1:C5)-B1<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 C1 =A1-B1<\/p>\n<p>C1 l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong <a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">h\u00e0m SUM<\/a> t\u1ea1i A1, v\u00ec v\u1eady k\u1ebft qu\u1ea3 c\u1ee7a A1 s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u00ednh th\u00f4ng qua d\u1eef li\u1ec7u c\u1ee7a C1<\/p>\n<p>Nh\u01b0ng t\u1ea1i\u00a0\u00f4 C1 l\u1ea1i tham chi\u1ebfu t\u1edbi A1 v\u00e0 B1, d\u00f9ng k\u1ebft qu\u1ea3 c\u1ee7a A1\u00a0\u0111\u1ec3 l\u00e0m\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng t\u00ednh to\u00e1n.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y gi\u1eefa 2\u00a0\u00f4 A1 v\u00e0 C1\u00a0\u0111ang c\u00f3 s\u1ef1 l\u1eb7p l\u1ea1i l\u1eabn nhau, d\u00f9ng ch\u00ednh k\u1ebft qu\u1ea3 c\u1ee7a nhau\u00a0\u0111\u1ec3 t\u00ednh k\u1ebft qu\u1ea3 cho m\u00ecnh, v\u00e0 n\u00f3 t\u1ea1o th\u00e0nh v\u00f2ng tr\u00f2n kh\u00f4ng bi\u1ebft\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec3m cu\u1ed1i.<\/p>\n<p>=&gt;\u00a0\u0110\u00e2y ch\u00ednh l\u00e0 kh\u00e1i ni\u1ec7m v\u1ec1 v\u00f2ng t\u00ednh l\u1eb7p trong\u00a0Excel v\u00e0 c\u00e1ch\u00a0Excel th\u00f4ng b\u00e1o t\u1edbi ch\u00fang ta v\u1ec1 v\u00f2ng l\u1eb7p.<\/p>\n<p>V\u00f2ng l\u1eb7p trong t\u00ednh to\u00e1n s\u1ebd khi\u1ebfn\u00a0Excel ti\u00eau t\u1ed1n b\u1ed9 nh\u1edb, t\u00e0i nguy\u00ean khi ph\u1ea3i th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh li\u00ean t\u1ee5c theo v\u00f2ng. B\u1edfi v\u1eady s\u1ebd lu\u00f4n c\u00f3 th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi d\u00f9ng bi\u1ebft khi c\u00f3 v\u00f2ng l\u1eb7p trong b\u1ea3ng t\u00ednh\u00a0\u0111\u1ec3 c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tim_vi_tri_bi_vong_lap_khi_khong_ro_vi_tri_do_o_dau\"><\/span><strong>C\u00e1ch t\u00ecm v\u1ecb tr\u00ed b\u1ecb v\u00f2ng l\u1eb7p khi kh\u00f4ng r\u00f5 v\u1ecb tr\u00ed \u0111\u00f3\u00a0\u1edf\u00a0\u0111\u00e2u?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12929 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic03-7.png\" width=\"1172\" height=\"248\" title=\"pic03-7\"><\/p>\n<p>Ch\u1ecdn Tab <strong>Formulas<\/strong>, t\u00ecm\u00a0\u0111\u1ebfn m\u1ee5c\u00a0<strong>Error Checking<\/strong>, ch\u1ecdn <strong>Circular References<\/strong><\/p>\n<p>Trong m\u1ee5c n\u00e0y\u00a0Excel s\u1ebd ch\u1ec9 cho ch\u00fang ta bi\u1ebft v\u00f2ng l\u1eb7p xu\u1ea5t hi\u1ec7n\u00a0\u1edf v\u1ecb tr\u00ed n\u00e0o (Sheet n\u00e0o, \u00f4 n\u00e0o),\u00a0\u0111\u00e2u l\u00e0 tr\u1ecdng t\u00e2m c\u1ee7a v\u00f2ng l\u1eb7p n\u00e0y (v\u1ecb tr\u00ed\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh d\u1ea5u t\u00edch V)<\/p>\n<p>B\u1ea5m v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o trong Circular References th\u00ec\u00a0Excel s\u1ebd\u00a0\u0111\u01b0a ch\u00fang ta\u00a0\u0111\u1ebfn ngay v\u1ecb tr\u00ed\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 ki\u1ec3m tra l\u1ea1i th\u00f4ng tin.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xu_ly_khi_gap_vong_lap\"><\/span><strong>C\u00e1ch x\u1eed l\u00fd khi g\u1eb7p v\u00f2ng l\u1eb7p:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u01b0\u1eddng vi\u1ec7c t\u00ednh to\u00e1n b\u1ecb v\u00f2ng l\u1eb7p c\u00f3 2 nguy\u00ean nh\u00e2n ch\u00ednh:<\/p>\n<ul>\n<li>Nguy\u00ean nh\u00e2n do c\u1ed1\u00a0\u00fd v\u00e0 mu\u1ed1n t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p: B\u1ea1n bi\u1ebft r\u00f5 r\u1eb1ng s\u1ebd xu\u1ea5t hi\u1ec7n v\u00f2ng l\u1eb7p v\u00e0 ch\u1ea5p nh\u1eadn \u0111i\u1ec1u \u0111\u00f3 \u0111\u1ec3\u00a0khai th\u00e1c t\u00ednh n\u0103ng n\u00e0y.<\/li>\n<li>Nguy\u00ean nh\u00e2n do v\u00f4\u00a0\u00fd: b\u1ea1n kh\u00f4ng mu\u1ed1n ho\u1eb7c kh\u00f4ng bi\u1ebft r\u1eb1ng\u00a0\u0111\u00e3 t\u1ea1o ra v\u00f2ng l\u1eb7p, c\u1ea7n x\u1eed l\u00fd\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_1_su_dung_tham_chieu_vong_vong_tinh_lap\"><\/span><strong><em>Tr\u01b0\u1eddng h\u1ee3p 1: s\u1eed d\u1ee5ng tham chi\u1ebfu v\u00f2ng (v\u00f2ng t\u00ednh l\u1eb7p)<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ecdn tab <strong>File<\/strong> &gt;<strong> Option<\/strong> &gt; <strong>Formulas<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12930 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic04-7.png\" width=\"1026\" height=\"846\" title=\"pic04-7\"><\/p>\n<blockquote>\n<p>Xem ngay: T\u1ed5ng h\u1ee3p b\u00e0i vi\u1ebft v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a> hay nh\u1ea5t m\u1ecdi th\u1eddi \u0111\u1ea1i<\/p>\n<\/blockquote>\n<p>\u0110\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o m\u1ee5c <strong>Enable iterative calculation<\/strong> (Cho ph\u00e9p t\u00ednh to\u00e1n l\u1eb7p)<\/p>\n<p><em><strong>Maximum Iterations<\/strong><\/em> : S\u1ed1 l\u1ea7n l\u1eb7p t\u1ed1i\u00a0\u0111a (gi\u1edbi h\u1ea1n s\u1ed1 l\u1ea7n l\u1eb7p\u00a0\u0111\u1ec3 ki\u1ec3m so\u00e1t gi\u1edbi h\u1ea1n cho v\u00f2ng l\u1eb7p)<\/p>\n<p><em><strong>Maximum change<\/strong><\/em>: Thay\u00a0\u0111\u1ed5i t\u1ed1i\u00a0\u0111a (khi t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p th\u00ec c\u1ee9 c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i k\u1ebft qu\u1ea3 sau m\u1ed7i v\u00f2ng l\u1eb7p th\u00ec s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u00ednh ti\u1ebfp) =&gt; T\u00f9y v\u00e0o\u00a0\u0111\u1ed9 ph\u1ee9c t\u1ea1p trong v\u00f2ng l\u1eb7p m\u00e0 c\u1ea7n gi\u1edbi h\u1ea1n\u00a0\u0111i\u1ec1u n\u00e0y,\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n. Gi\u00e1 tr\u1ecb c\u00e0ng nh\u1ecf th\u00ec k\u1ebft qu\u1ea3 v\u00f2ng l\u1eb7p c\u00e0ng ch\u00ednh x\u00e1c, nh\u01b0ng\u00a0Excel s\u1ebd c\u1ea7n t\u00ednh to\u00e1n nhi\u1ec1u h\u01a1n v\u00e0 t\u1ed1n t\u00e0i nguy\u00ean\u00a0\u0111\u1ec3 x\u1eed l\u00fd h\u01a1n.<\/p>\n<p>Vi\u1ec7c t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p c\u00f3 th\u1ec3 cho ra 3 k\u1ebft qu\u1ea3 (theo Support.office.com)<\/p>\n<ul>\n<li>\u0110\u00e1p\u00a0\u00e1n h\u1ed9i t\u1ee5: T\u00ednh\u00a0\u0111\u1ebfn khi\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng,\u00a0\u1ed5n\u00a0\u0111\u1ecbnh =&gt;\u00a0Th\u01b0\u1eddng d\u00f9ng v\u00f2ng l\u1eb7p\u00a0\u0111\u1ec3\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y<\/li>\n<li>\u0110\u00e1p\u00a0\u00e1n ph\u00e2n k\u1ef3: Qua c\u00e1c l\u1ea7n l\u1eb7p c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t v\u1ec1 k\u1ebft qu\u1ea3, l\u1ea7n sau s\u1ebd kh\u00e1c so\u00a0v\u1edbi tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/li>\n<li>\u0110\u00e1p\u00a0\u00e1n chuy\u1ec3n\u00a0\u0111\u1ed5i gi\u1eefa hai gi\u00e1 tr\u1ecb: Th\u01b0\u1eddng c\u00f3 m\u1ed9t v\u00e0i k\u1ebft qu\u1ea3 nh\u1ea5t\u00a0\u0111\u1ecbnh v\u00e0 s\u1ebd l\u1eb7p l\u1ea1i sau m\u1ed9t v\u00e0i l\u1ea7n l\u1eb7p<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_2_Loai_bo_vong_lap\"><\/span><strong><em>Tr\u01b0\u1eddng h\u1ee3p 2: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>B\u1ecf\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0\u1edf m\u1ee5c <strong><em>Enable iterative calculation<\/em><\/strong>\u00a0\u1edf b\u01b0\u1edbc tr\u00ean\u00a0\u0111\u1ec3 kh\u00f4ng t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p<\/li>\n<li>D\u1ef1a theo v\u1ecb tr\u00ed m\u00e0 ch\u1ee9c n\u0103ng\u00a0Error checking &gt; Circular References ch\u1ec9 d\u1eabn\u00a0\u0111\u1ec3 ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c, lo\u1ea1i b\u1ecf c\u00e1c tham chi\u1ebfu g\u00e2y l\u1eb7p trong c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3 (x\u00f3a, chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh ghi ch\u00fa ho\u1eb7c s\u1eeda l\u1ea1i tham chi\u1ebfu trong c\u00f4ng th\u1ee9c)<\/li>\n<\/ul>\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\">HocExcel.Online<\/a><\/p>\n<p>\u00a0<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-16.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10747,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10746","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\/10746","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=10746"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10746\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10747"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}