{"id":5373,"date":"2024-12-16T02:07:03","date_gmt":"2024-12-16T02:07:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan\/"},"modified":"2024-12-16T02:07:03","modified_gmt":"2024-12-16T02:07:03","slug":"cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan\/","title":{"rendered":"C\u00e1ch l\u1eadp b\u1ea3ng k\u1ebf ho\u1ea1ch thanh to\u00e1n h\u00f3a \u0111\u01a1n c\u00f3 chi\u1ebft kh\u1ea5u thanh to\u00e1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00e1c h\u1ee3p\u00a0\u0111\u1ed3ng mua b\u00e1n ho\u1eb7c Invoice th\u01b0\u1eddng c\u00f3 m\u1ed9t n\u1ed9i dung v\u1ec1\u00a0\u0111i\u1ec1u kho\u1ea3n thanh to\u00e1n nh\u01b0 sau:<\/p>\n<blockquote>\n<p>3\/10 net 30<\/p>\n<\/blockquote>\n<p>V\u1eady n\u1ed9i dung n\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u th\u1ebf n\u00e0o? Vi\u1ec7c\u00a0 l\u1eadp k\u1ebf ho\u1ea1ch thanh to\u00e1n cho nh\u1eefng h\u00f3a\u00a0\u0111\u01a1n n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online tr\u1ea3 l\u1eddi nh\u1eefng c\u00e2u h\u1ecfi n\u00e0y 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-675f8b467aaca\" 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\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#Phan_1_Chiet_khau_thanh_toan\" title=\"Ph\u1ea7n 1: Chi\u1ebft kh\u1ea5u thanh to\u00e1n\">Ph\u1ea7n 1: Chi\u1ebft kh\u1ea5u thanh to\u00e1n<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#11_Khai_niem\" title=\"1.1. Kh\u00e1i ni\u1ec7m\">1.1. Kh\u00e1i ni\u1ec7m<\/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\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#12_Cach_tinh\" title=\"1.2. C\u00e1ch t\u00ednh\">1.2. C\u00e1ch t\u00ednh<\/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\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#Phan_2_Lap_bang_ke_hoach_thanh_toan_tren_Excel\" title=\"Ph\u1ea7n 2: L\u1eadp b\u1ea3ng k\u1ebf ho\u1ea1ch thanh to\u00e1n tr\u00ean\u00a0Excel\">Ph\u1ea7n 2: L\u1eadp b\u1ea3ng k\u1ebf ho\u1ea1ch thanh to\u00e1n tr\u00ean\u00a0Excel<\/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\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#21_Xac_dinh_thong_tin_trong_hoa_don_Invoice\" title=\"2.1. X\u00e1c\u00a0\u0111\u1ecbnh th\u00f4ng tin trong h\u00f3a\u00a0\u0111\u01a1n, Invoice\">2.1. X\u00e1c\u00a0\u0111\u1ecbnh th\u00f4ng tin trong h\u00f3a\u00a0\u0111\u01a1n, Invoice<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#22_Lap_bang_tinh_ke_hoach_thanh_toan\" title=\"2.2. L\u1eadp b\u1ea3ng t\u00ednh k\u1ebf ho\u1ea1ch thanh to\u00e1n\">2.2. L\u1eadp b\u1ea3ng t\u00ednh k\u1ebf ho\u1ea1ch thanh to\u00e1n<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-lap-bang-ke-hoach-thanh-toan-hoa-don-co-chiet-khau-thanh-toan.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Phan_1_Chiet_khau_thanh_toan\"><\/span>Ph\u1ea7n 1: Chi\u1ebft kh\u1ea5u thanh to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"11_Khai_niem\"><\/span>1.1. Kh\u00e1i ni\u1ec7m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ed9i dung <strong>3\/10 net 30\u00a0<\/strong>ho\u1eb7c <strong>2\/15 net 45<\/strong>\u00a0ch\u00ednh l\u00e0 <strong>Chi\u1ebft kh\u1ea5u\u00a0 thanh to\u00e1n (CKTT)<\/strong>. N\u00f3 th\u01b0\u1eddng n\u1eb1m t\u1ea1i m\u1ee5c li\u00ean quan\u00a0\u0111\u1ebfn\u00a0<strong>\u0111i\u1ec1u kho\u1ea3n,\u00a0\u0111i\u1ec1u ki\u1ec7n thanh to\u00e1n<\/strong> trong H\u1ee3p\u00a0\u0111\u1ed3ng, Invoice.<\/p>\n<p><strong>\u0110\u01b0\u1ee3c hi\u1ec3u l\u00e0<\/strong>: N\u1ebfu kh\u00e1ch\u00a0 h\u00e0ng thanh to\u00e1n s\u1edbm tr\u01b0\u1edbc th\u1eddi h\u1ea1n th\u00ec s\u1ebd\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng chi\u1ebft kh\u1ea5u, v\u1edbi s\u1ed1 ti\u1ec1n thanh to\u00e1n\u00a0\u00edt h\u01a1n s\u1ed1 ph\u1ea3i tr\u1ea3 ghi tr\u00ean\u00a0h\u1ee3p\u00a0\u0111\u1ed3ng.<\/p>\n<p><strong>C\u1ee5 th\u1ec3<\/strong>: V\u1edbi CKTT l\u00e0 3\/10 net 30<\/p>\n<ul>\n<li>Th\u1eddi h\u1ea1n thanh to\u00e1n c\u1ee7a h\u1ee3p\u00a0\u00a0\u0111\u1ed3ng l\u00e0 trong v\u00f2ng\u00a0<strong>30<\/strong> ng\u00e0y k\u1ec3 t\u1eeb ng\u00e0y k\u00fd h\u1ee3p\u00a0\u0111\u1ed3ng, ng\u00e0y l\u1eadp Invoice<\/li>\n<li>Th\u1eddi h\u1ea1n thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng chi\u1ebft kh\u1ea5u thanh to\u00e1n l\u00e0 trong v\u00f2ng <strong>10<\/strong> ng\u00e0y k\u1ec3 t\u1eeb ng\u00e0y k\u00fd h\u1ee3p\u00a0\u0111\u1ed3ng, ng\u00e0y l\u1eadp Invoice (thanh to\u00e1n\u00a0trong th\u1eddi gian n\u00e0y s\u1ebd\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng CKTT)<\/li>\n<li>M\u1ee9c CKTT\u00a0l\u00e0 <strong>3%<\/strong><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"12_Cach_tinh\"><\/span>1.2. C\u00e1ch t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Chi\u1ebft kh\u1ea5u thanh to\u00e1n t\u00ednh tr\u00ean s\u1ed1 ti\u1ec1n tr\u1ea3 s\u1edbm, kh\u00f4ng ph\u1ea3i to\u00e0n b\u1ed9 s\u1ed1 ph\u1ea3i tr\u1ea3 m\u00e0 ch\u1ec9 t\u00ednh tr\u00ean s\u1ed1 tr\u1ea3 trong th\u1eddi gian h\u01b0\u1edfng chi\u1ebft kh\u1ea5u.<\/p>\n<ul>\n<li>S\u1ed1 ti\u1ec1n tr\u1ea3 trong th\u1eddi gian h\u01b0\u1edfng CKTT = A<\/li>\n<li>S\u1ed1 ti\u1ec1n\u00a0\u0111\u00e3 thanh to\u00e1n theo h\u1ee3p\u00a0\u0111\u1ed3ng = B = A \/ (1\u00a0\u2013 M\u1ee9c CKTT)<\/li>\n<li>S\u1ed1 ti\u1ec1n tr\u1ea3 sau th\u1eddi gian h\u01b0\u1edfng CKTT =\u00a0C<\/li>\n<li>T\u1ed5ng s\u1ed1 ti\u1ec1n\u00a0\u0111\u00e3 thanh to\u00e1n =\u00a0B + C<\/li>\n<\/ul>\n<p>V\u00ec m\u1ed7i kho\u1ea3n A khi thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng chi\u1ebft kh\u1ea5u l\u00e0 X%, do\u00a0\u0111\u00f3 gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a A tr\u00ean h\u1ee3p\u00a0\u0111\u1ed3ng s\u1ebd l\u1edbn h\u01a1n A.<\/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\/2024\/12\/vba101_92019-nho-187.gif\" title=\"vba101_92019-nho-187\"><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\/2024\/12\/ex101_92019-nho-463.gif\" title=\"ex101_92019-nho-463\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>C\u1ee5 th\u1ec3:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu theo h\u1ee3p\u00a0\u0111\u1ed3ng ph\u1ea3i tr\u1ea3 l\u00e0 1 tri\u1ec7u,\u00a0\u0111\u01b0\u1ee3c\u00a0 h\u01b0\u1edfng CK l\u00e0 3%, v\u1eady n\u1ebfu trong th\u1eddi gian h\u01b0\u1edfng CK m\u00e0 thanh to\u00e1n h\u1ebft th\u00ec s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3m s\u1ed1 ti\u1ec1n l\u00e0: 1.000.000 * 3% = 30.000<\/li>\n<li>S\u1ed1 ti\u1ec1n ph\u1ea3i tr\u1ea3 trong th\u1eddi gian chi\u1ebft kh\u1ea5u = 1.000.000 \u2013 30.000 = 970.000<\/li>\n<li>R\u00fat g\u1ecdn c\u00f4ng th\u1ee9c l\u00e0 1.000.000 * (1 \u2013 3%) = 1.000.000 * 97% = 970.000<\/li>\n<li>V\u1eady coi 970.000 l\u00e0 A, 1.000.0000 l\u00e0 B th\u00ec ta c\u00f3 A = B * (1-3%)<\/li>\n<li>\u0110\u1ed5i c\u00f4ng th\u1ee9c l\u1ea1i\u00a0\u0111\u1ec3 t\u00ednh B = A \/ (1-3%)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c c\u00e1ch t\u00ednh cho nh\u1eefng kho\u1ea3n thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng CKTT.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phan_2_Lap_bang_ke_hoach_thanh_toan_tren_Excel\"><\/span>Ph\u1ea7n 2: L\u1eadp b\u1ea3ng k\u1ebf ho\u1ea1ch thanh to\u00e1n tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"21_Xac_dinh_thong_tin_trong_hoa_don_Invoice\"><\/span>2.1. X\u00e1c\u00a0\u0111\u1ecbnh th\u00f4ng tin trong h\u00f3a\u00a0\u0111\u01a1n, Invoice<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14486\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cktt-01.png\" width=\"637\" height=\"328\" title=\"heo-cktt-01\"><\/p>\n<p>Gi\u1ea3 thi\u1ebft r\u1eb1ng ch\u00fang ta c\u00f3 1 h\u00f3a\u00a0\u0111\u01a1n v\u1edbi c\u00e1c th\u00f4ng tin nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1ed5ng s\u1ed1 ti\u1ec1n ph\u1ea3i tr\u1ea3 C3 = 150 $<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n thanh to\u00e1n C4 = 3\/10 net 30<\/li>\n<li>Ng\u00e0y l\u1eadp h\u00f3a\u00a0\u0111\u01a1n C8 = 08\/03\/2018<\/li>\n<\/ul>\n<p>T\u1eeb c\u00e1c n\u1ed9i dung tr\u00ean, ch\u00fang ta c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh c\u1ee5 th\u1ec3 c\u00e1c n\u1ed9i dung v\u1ec1 CKTT, th\u1eddi h\u1ea1n thanh to\u00e1n, th\u1eddi h\u1ea1n thanh to\u00e1n h\u01b0\u1edfng CKTT<\/p>\n<ul>\n<li>Chi\u1ebft kh\u1ea5u thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng C7 = 3%<\/li>\n<li>Th\u1eddi gian thanh to\u00e1n (C5) = 30 (ng\u00e0y) =&gt; Th\u1eddi h\u1ea1n thanh to\u00e1n C9 = C8 + 30 = 07\/04\/2018<\/li>\n<li>Th\u1eddi gian thanh to\u00e1n \u0111\u01b0\u1ee3c chi\u1ebft kh\u1ea5u C6 = 10 (ng\u00e0y) =&gt;\u00a0Th\u1eddi\u00a0\u0111i\u1ec3m thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c nh\u1eadn CKTT C10= C8\u00a0 + 10\u00a0 = 18\/03\/2018<\/li>\n<\/ul>\n<p>C\u00e1c n\u1ed9i dung c\u1ea7n\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong vi\u1ec7c t\u00ednh to\u00e1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"22_Lap_bang_tinh_ke_hoach_thanh_toan\"><\/span>2.2. L\u1eadp b\u1ea3ng t\u00ednh k\u1ebf ho\u1ea1ch thanh to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14488\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cktt-03.png\" width=\"1495\" height=\"471\" title=\"heo-cktt-03\"><\/p>\n<p>Tr\u00ecnh\u00a0t\u1ef1 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c g\u1ed3m<\/p>\n<p><em><strong>C\u00e1c c\u1ed9t<\/strong><\/em>: Ng\u00e0y thanh to\u00e1n, S\u1ed1 ti\u1ec1n theo k\u1ebf ho\u1ea1ch, s\u1ed1 th\u1ef1c\u00a0 nh\u1eadn n\u1ebfu bao g\u1ed3m CKTT<\/p>\n<p><strong><em>C\u00e1c h\u00e0ng<\/em><\/strong>:<\/p>\n<ul>\n<li>C\u00e1c l\u1ea7n thanh to\u00e1n (t\u1eeb d\u00f2ng 3\u00a0\u0111\u1ebfn d\u00f2ng 8)<\/li>\n<li>L\u1ea7n thanh to\u00e1n cu\u1ed1i c\u00f9ng (d\u00f2ng 9)<\/li>\n<li>T\u1ed5ng c\u1ed9ng<\/li>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 CKTT\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng th\u1ef1c\u00a0 t\u1ebf khi th\u1ef1c hi\u1ec7n theo k\u1ebf ho\u1ea1ch<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ed5ng s\u1ed1 th\u1ef1c\u00a0 nh\u1eadn lu\u00f4n b\u1eb1ng gi\u00e1 tr\u1ecb h\u1ee3p\u00a0\u0111\u1ed3ng (G10)<\/p>\n<p>G10 = C3<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: S\u1ed1 ti\u1ec1n th\u1ef1c nh\u1eadn\u00a0\u1edf l\u1ea7n thanh to\u00e1n cu\u1ed1i c\u00f9ng (G9)<\/p>\n<p>G9 =\u00a0T\u1ed5ng s\u1ed1 th\u1ef1c nh\u1eadn \u2013 T\u1ed5ng s\u1ed1 th\u1ef1c nh\u1eadn\u00a0c\u00e1c\u00a0\u0111\u1ee3t thanh to\u00e1n tr\u01b0\u1edbc\u00a0\u0111\u00f3<\/p>\n<p>= G10 \u2013 SUM(G3:G8)<\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: T\u00ednh s\u1ed1 ti\u1ec1n k\u1ebf\u00a0ho\u1ea1ch tr\u1ea3 cho l\u1ea7n tr\u1ea3 cu\u1ed1i\u00a0 c\u00f9ng (F9)<\/p>\n<p>C\u0103n c\u1ee9 theo ng\u00e0y tr\u1ea3 l\u1ea7n cu\u1ed1i c\u00f9ng:<\/p>\n<ul>\n<li>N\u1ebfu ng\u00e0y tr\u1ea3 l\u1ea7n cu\u1ed1i c\u00f9ng n\u1eb1m trong th\u1eddi gian h\u01b0\u1edfng CKTT =&gt; F9 = G9\u00a0* (1\u00a0\u2013 C7) k\u1ebft h\u1ee3p\u00a0\u0111i\u1ec1u ki\u1ec7n ng\u00e0y tr\u1ea3 n\u1eb1m trong th\u1eddi gian h\u01b0\u1edfng CKTT th\u00ec c\u00f4ng th\u1ee9c l\u00e0:\u00a0IF(E9&lt;=C10,G9*(1-C7),\u2026)<\/li>\n<li>N\u1ebfu ng\u00e0y tr\u1ea3 l\u1ea7n cu\u1ed1i n\u1eb1m ngo\u00e0i th\u1eddi gian h\u01b0\u1edfng CKTT =&gt; F9 = G9<\/li>\n<\/ul>\n<p>X\u00e9t tr\u01b0\u1eddng h\u1ee3p n\u1ebfu kh\u00f4ng c\u00f3 ng\u00e0y t\u1ea1i\u00a0\u00f4 E9 =&gt; Kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0 ng\u00e0y tr\u1ea3 =&gt; Bi\u1ec7n lu\u1eadn n\u1ebfu kh\u00f4ng c\u00f3 ng\u00e0y tr\u1ea3 th\u00ec kh\u00f4ng th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, ch\u1ec9 t\u00ednh khi E9 kh\u00e1c\u00a0 0<\/p>\n<p><strong>B\u01b0\u1edbc 5<\/strong>: T\u00ednh s\u1ed1 ti\u1ec1n th\u1ef1c nh\u1eadn t\u1ea1i m\u1ed7i l\u1ea7n thanh to\u00e1n (t\u1eeb G3\u00a0\u0111\u1ebfn G8)<\/p>\n<p>X\u00e9t t\u1ea1i G3<\/p>\n<p>C\u0103n c\u1ee9 theo ng\u00e0y tr\u1ea3 t\u1ea1i l\u1ea7n\u00a0\u0111\u00f3<\/p>\n<ul>\n<li>N\u1ebfu ng\u00e0y tr\u1ea3 l\u1ea7n\u00a0\u0111\u00f3 n\u1eb1m trong th\u1eddi gian h\u01b0\u1edfng CKTT =&gt;\u00a0G3 =\u00a0F3\u00a0\/ (1\u00a0\u2013\u00a0C7) k\u1ebft h\u1ee3p\u00a0\u0111i\u1ec1u ki\u1ec7n ng\u00e0y tr\u1ea3 n\u1eb1m trong th\u1eddi gian h\u01b0\u1edfng CKTT th\u00ec c\u00f4ng th\u1ee9c l\u00e0:\u00a0IF(E3&lt;=C10,F9.(1-C7),\u2026) =&gt; Do c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c l\u1ea7n tr\u1ea3 ti\u1ebfp theo =&gt; C\u1ed1\u00a0\u0111\u1ecbnh c\u00e1c\u00a0\u0111i\u1ec3m\u00a0\u1edf c\u1ed9t C<\/li>\n<li>N\u1ebfu ng\u00e0y tr\u1ea3 l\u1ea7n cu\u1ed1i n\u1eb1m ngo\u00e0i th\u1eddi gian h\u01b0\u1edfng CKTT =&gt;\u00a0G3\u00a0=\u00a0F3 hay hi\u1ec3u c\u00e1ch kh\u00e1c l\u00e0 chi\u1ebft kh\u1ea5u thanh to\u00e1n = 0<\/li>\n<li>C\u00e1ch vi\u1ebft c\u00f3 th\u1ec3 hi\u1ec3u l\u00e0 G3 = F3 \/ (1 \u2013 N\u1ebfu ng\u00e0y tr\u1ea3 trong th\u1eddi gian h\u01b0\u1edfng CK th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb t\u1ea1i C7, c\u00f2n ngo\u00e0i th\u1eddi gian h\u01b0\u1edfng CK th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb 0<\/li>\n<li>S\u1eed\u00a0 d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 n\u1ebfu c\u00f3 s\u1ed1 l\u1ebb =&gt; H\u00e0m ROUND(s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n, l\u00e0m tr\u00f2n t\u1edbi v\u1ecb tr\u00ed n\u00e0o)<\/li>\n<\/ul>\n<p>Sau khi ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c t\u1ea1i G3 c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c\u00a0\u00f4 G4, G5\u2026 G8<\/p>\n<p><strong>B\u01b0\u1edbc 6<\/strong>: T\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n k\u1ebf ho\u1ea1ch tr\u1ea3 (F10)<\/p>\n<p>F10 = T\u1ed5ng c\u00e1c l\u1ea7n tr\u1ea3 = SUM(F3:F9)<\/p>\n<p><strong>B\u01b0\u1edbc 7<\/strong>: T\u00ednh\u00a0t\u1ed5ng CKTT\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng (F11)<\/p>\n<p>B\u1edfi vi\u1ec7c tr\u1ea3 nhi\u1ec1u l\u1ea7n c\u00f3 th\u1ec3 x\u1ea3y ra vi\u1ec7c kh\u00f4ng ph\u1ea3i to\u00e0n b\u1ed9 s\u1ed1 ti\u1ec1n thanh to\u00e1n\u00a0\u0111\u01b0\u1ee3c\u00a0 h\u01b0\u1edfng CKTT, do\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh l\u1ea1i xem th\u1ef1c t\u1ebf\u00a0\u0111\u01b0\u1ee3c nh\u1eadn bao nhi\u00eau CKTT, %\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng l\u00e0 bao nhi\u00eau<\/p>\n<p>F11 = T\u1ed5ng s\u1ed1 th\u1ef1c nh\u1eadn \u2013 T\u1ed5ng s\u1ed1 k\u1ebf ho\u1ea1ch = G10-F10<\/p>\n<p><strong>B\u01b0\u1edbc 8<\/strong>: T\u00ednh t\u1ef7 l\u1ec7 CKTT\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng (G11)<\/p>\n<p>G11 = S\u1ed1 CKTT\u00a0\u0111\u01b0\u1ee3c h\u01b0\u1edfng \/ T\u1ed5ng s\u1ed1 th\u1ef1c nh\u1eadn = F11\/G10<\/p>\n<p>C\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 n\u1ebfu s\u1ed1 l\u1ebb<\/p>\n<p>Do\u00a0\u0111\u01a1n v\u1ecb l\u00e0 % n\u00ean c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Round v\u1edbi v\u1ecb tr\u00ed c\u1ea7n l\u00e0m tr\u00f2n &gt; 2<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady th\u00f4ng qua vi\u1ec7c\u00a0 ph\u00e2n t\u00edch c\u00e1ch t\u00ednh v\u00e0 t\u1eebng b\u01b0\u1edbc th\u1ef1c\u00a0 hi\u1ec7n, ch\u00fang ta c\u00f3 th\u1ec3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c b\u1ea3ng k\u1ebf ho\u1ea1ch thanh to\u00e1n cho nh\u1eefng h\u1ee3p\u00a0\u0111\u1ed3ng c\u00f3 ch\u1ee9a CKTT.<\/p>\n<p>Vi\u1ec7c\u00a0 ph\u00e2n t\u00edch CKTT v\u00e0 l\u1eadp k\u1ebf ho\u1ea1ch Thanh to\u00e1n s\u1ebd gi\u00fap ch\u00fang ta c\u00f3 k\u1ebf ho\u1ea1ch t\u00e0i ch\u00ednh ph\u00f9 h\u1ee3p nh\u1ea5t, ho\u1eb7c c\u00f3 k\u1ebf ho\u1ea1ch thu h\u1ed3i c\u00f4ng n\u1ee3 cho nh\u1eefng h\u00f3a\u00a0\u0111\u01a1n\u00a0\u0111\u00e3 b\u00e1n 1 c\u00e1ch t\u1ed1t nh\u1ea5t.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t\u00a0 c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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\/2024\/12\/vba101_92019-nho-187.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5373","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=5373"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5374"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}