{"id":5059,"date":"2024-12-09T01:52:59","date_gmt":"2024-12-09T01:52:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat\/"},"modified":"2024-12-09T01:52:59","modified_gmt":"2024-12-09T01:52:59","slug":"huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m % tr\u00ean Excel chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u01a1n v\u1ecb ph\u1ea7n tr\u0103m (%) l\u00e0 m\u1ed9t trong nh\u1eefng\u00a0\u0111\u01a1n v\u1ecb th\u01b0\u1eddng g\u1eb7p khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel. Nh\u01b0ng\u00a0trong th\u1ef1c t\u1ebf c\u00e1ch t\u00ednh ra gi\u00e1 tr\u1ecb % l\u1ea1i r\u1ea5y\u00a0\u0111a d\u1ea1ng v\u00e0 ph\u1ee9c t\u1ea1p. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m % tr\u00ean Excel m\u1ed9t c\u00e1ch chi ti\u1ebft 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-67564d7a423f6\" 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\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Dinh_dang_du_lieu_phan_tram_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u1ea7n tr\u0103m (%) trong\u00a0Excel\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u1ea7n tr\u0103m (%) trong\u00a0Excel<\/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\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Cong_thuc_tinh_phan_tram_tren_Excel\" title=\"C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m (%) tr\u00ean\u00a0Excel\">C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m (%) 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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Cong_thuc_tinh_phan_tram_cua_tong_chung_of_Grand_Total\" title=\"C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng chung (%\u00a0of Grand Total)\">C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng chung (%\u00a0of Grand Total)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Cong_thuc_tinh_phan_tram_cua_tong_nhom_of_Parent_Total\" title=\"C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng nh\u00f3m (%\u00a0of Parent Total)\">C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng nh\u00f3m (%\u00a0of Parent Total)<\/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\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Cong_thuc_tinh_phan_tram_chenh_lech_of_Difference\" title=\"C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch (%\u00a0of Difference)\">C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch (%\u00a0of Difference)<\/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\/huong-dan-cach-lap-cong-thuc-tinh-phan-tram-tren-excel-chi-tiet-nhat.html#Cong_thuc_tinh_phan_tram_luy_tien_of_Running_Total\" title=\"C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m l\u0169y ti\u1ebfn (%\u00a0of Running Total)\">C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m l\u0169y ti\u1ebfn (%\u00a0of Running Total)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_dang_du_lieu_phan_tram_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u1ea7n tr\u0103m (%) trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea3n ch\u1ea5t c\u1ee7a d\u1eef li\u1ec7u % trong\u00a0Excel l\u00e0 m\u1ed9t con s\u1ed1 nh\u1ecf h\u01a1n 0. Nh\u01b0ng \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 hi\u1ec3u v\u00e0 d\u1ec5 t\u00ednh to\u00e1n th\u00ec d\u1eef li\u1ec7u n\u00e0y c\u1ea7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecbnh d\u1ea1ng ri\u00eang. Trong <a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-trong-excel.html\">Format Cells<\/a> c\u1ee7a\u00a0Excel cung c\u1ea5p cho ch\u00fang ta m\u1ed9t\u00a0\u0111\u1ecbnh d\u1ea1ng l\u00e0 <strong>Percentage<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-du-lieu-phan-tram-format-cells-1024x315-1.png\" width=\"800\" height=\"246\" title=\"dinh-dang-du-lieu-phan-tram-format-cells-1024x315-1\"><\/p>\n<p>Khi\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u\u00a0\u1edf d\u1ea1ng n\u00e0y, d\u1eef li\u1ec7u t\u1eeb d\u1ea1ng s\u1ed1 0.05 s\u1ebd chuy\u1ec3n v\u1ec1 d\u1ea1ng s\u1ed1 c\u00f3 k\u00fd hi\u1ec7u % l\u00e0 5%.<\/p>\n<p>Khi mu\u1ed1n bi\u1ec3u di\u1ec5n ph\u1ea7n s\u1ed1\u00a0th\u1eadp ph\u00e2n trong s\u1ed1 %, ch\u00fang ta ch\u1ecdn Decimal places t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi s\u1ed1 ch\u1eef s\u1ed1 ph\u1ea7n th\u1eadp ph\u00e2n mu\u1ed1n hi\u1ec3n th\u1ecb.<\/p>\n<p>Do\u00a0\u0111\u00f3 khi mu\u1ed1n d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb\u00a0\u1edf d\u1ea1ng c\u00f3 k\u00fd t\u1ef1 %, ch\u00fang ta ph\u1ea3i thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng cho\u00a0\u00f4 d\u1eef li\u1ec7u\u00a0\u0111\u00f3. N\u1ebfu kh\u00f4ng\u00a0\u0111\u1ecbnh d\u1ea1ng,\u00a0Excel s\u1ebd ch\u1ec9 coi\u00a0\u0111\u00f3 l\u00e0 1 con s\u1ed1\u00a0kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u %.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_phan_tram_tren_Excel\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m (%) tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_phan_tram_cua_tong_chung_of_Grand_Total\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng chung (%\u00a0of Grand Total)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi mu\u1ed1n bi\u1ebft m\u1ed7i gi\u00e1 tr\u1ecb trong m\u1ed7i ph\u1ea7n t\u1eed chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng s\u1ed1, ch\u00fang ta d\u00f9ng c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng chung (hay c\u00f2n\u00a0\u0111\u01b0\u1ee3c g\u1ecdi ti\u1ebfng anh l\u00e0 %\u00a0of Grand Total). V\u00ed d\u1ee5 nh\u01b0 sau:<\/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-424.gif\" title=\"ex101_92019-nho-424\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24951\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-phan-tram-cua-tong-chung.png\" width=\"694\" height=\"257\" title=\"tinh-phan-tram-cua-tong-chung\"><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00e1ch t\u00ednh<\/strong><\/span>:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: X\u00e1c\u00a0\u0111\u1ecbnh t\u1ed5ng chung t\u1ea1i d\u00f2ng 8 v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">h\u00e0m SUM<\/a><\/p>\n<p style=\"padding-left: 30px\">B8=Sum(B2:B7)<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ea5y t\u1eebng ph\u1ea7n t\u1eed chia cho t\u1ed5ng chung<\/p>\n<p style=\"padding-left: 30px\">C2=B2\/B8<\/p>\n<p style=\"padding-left: 30px\">V\u00ec t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n t\u1eed\u00a0\u0111\u1ec1u chia cho t\u1ed5ng chung, n\u00ean ch\u00fang ta c\u1ed1\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u00f4 B8 th\u00e0nh $B$8<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>:\u00a0\u00c1p d\u1ee5ng to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c\u00a0\u1edf C2 xu\u1ed1ng t\u1edbi C7 (<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html\">k\u1ef9 thu\u1eadt Filldown<\/a>)<\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>:\u00a0\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng % b\u1eb1ng Format Cells. Ch\u00fa\u00a0\u00fd\u00a0\u1edf\u00a0\u0111\u00e2y c\u00f3 c\u1ea3 s\u1ed1 l\u1ebb th\u1eadp ph\u00e2n, do\u00a0\u0111\u00f3 c\u00f3 th\u1ec3\u00a0\u0111\u1ec3 2 ch\u1eef s\u1ed1 ph\u1ea7n th\u1eadp ph\u00e2n.<\/p>\n<p style=\"padding-left: 30px\">Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3:<\/p>\n<ul>\n<li><strong>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t<\/strong>: G\u1ecdi gi\u00e1 tr\u1ecb 1 ph\u1ea7n t\u1eed l\u00e0 A, t\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c ph\u1ea7n t\u1eed l\u00e0\u00a0Sum_A<\/li>\n<\/ul>\n<blockquote>\n<p>%\u00a0of Grand Total = (A\/Sum_A)*100%<\/p>\n<\/blockquote>\n<ul>\n<li>C\u00f3 th\u1ec3 thay vi\u1ec7c <strong>*100%<\/strong> b\u1eb1ng c\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u\u00a0\u1edf d\u1ea1ng <strong>Percentage<\/strong><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_phan_tram_cua_tong_nhom_of_Parent_Total\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng nh\u00f3m (%\u00a0of Parent Total)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c nh\u00f3m, ch\u00fang ta mu\u1ed1n\u00a0bi\u1ebft m\u1ed7i ph\u1ea7n t\u1eed chi\u1ebfm bao nhi\u00eau % trong ri\u00eang nh\u00f3m\u00a0\u0111\u00f3 th\u00ec t\u00ednh theo c\u00e1ch sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24952\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-phan-tram-cua-tong-nhom.png\" width=\"579\" height=\"288\" title=\"tinh-phan-tram-cua-tong-nhom\"><\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00e1ch t\u00ednh<\/strong><\/span>:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: X\u00e1c\u00a0\u0111\u1ecbnh t\u1ed5ng c\u1ee7a nh\u00f3m\u00a0\u0111\u00f3\u00a0v\u1edbi\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">h\u00e0m SUM<\/a><\/p>\n<p style=\"padding-left: 30px\">B2=SUM(B3:B6)<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ea5y t\u1eebng ph\u1ea7n t\u1eed trong nh\u00f3m chia cho t\u1ed5ng c\u1ee7a c\u1ea3 nh\u00f3m. Ch\u00fa\u00a0\u00fd c\u1ed1\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u00f4 t\u00ednh t\u1ed5ng<\/p>\n<p style=\"padding-left: 30px\">C3=B3\/$B$2<\/p>\n<p style=\"padding-left: 30px\">\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c ch\u1ec9 trong nh\u00f3m, t\u1eeb C3:C6<\/p>\n<p style=\"padding-left: 30px\">V\u1edbi nh\u00f3m kh\u00e1c, l\u1eb7p l\u1ea1i <strong>b\u01b0\u1edbc 1 <\/strong>v\u00e0<strong> b\u01b0\u1edbc 2<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>:\u00a0\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u d\u1ea1ng <strong>Percentage<\/strong><\/p>\n<p style=\"padding-left: 30px\">\u0110\u1ec3 ki\u1ec3m tra, ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1eebng nh\u00f3m v\u1edbi\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">h\u00e0m SUM<\/a>. K\u1ebft qu\u1ea3 s\u1ebd lu\u00f4n l\u00e0 100% (\u1edf c\u00e1c\u00a0\u00f4 C2 v\u00e0 C7)<\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t<\/strong><\/span>:<\/p>\n<p style=\"padding-left: 30px\">G\u1ecdi t\u1eebng ph\u1ea7n t\u1eed l\u00e0 A<\/p>\n<p style=\"padding-left: 30px\">T\u1ed5ng c\u1ee7a nh\u00f3m ch\u1ee9a ph\u1ea7n t\u1eed A l\u00e0 Subtotal_A<\/p>\n<blockquote style=\"padding-left: 30px\">\n<p style=\"padding-left: 30px\">%\u00a0of Parent Total = (A\/Subtotal_A)*100%<\/p>\n<\/blockquote>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1eebng nh\u00f3m, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\">h\u00e0m SUBTOTAL<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_phan_tram_chenh_lech_of_Difference\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh\u00a0ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch (%\u00a0of Difference)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch l\u00e0 t\u1ef7 l\u1ec7 ch\u00eanh l\u1ec7ch c\u1ee7a 2\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng li\u1ec1n nhau. Th\u01b0\u1eddng d\u00f9ng cho m\u1ee5c\u00a0\u0111\u00edch so s\u00e1nh gi\u1eefa c\u00e1c c\u1eb7p\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh t\u1ef7 l\u1ec7 ch\u00eanh l\u1ec7ch.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24956\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-phan-tram-chenh-lech.png\" width=\"515\" height=\"186\" title=\"tinh-phan-tram-chenh-lech\"><\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00e1ch t\u00ednh<\/strong><\/span>:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: X\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n ch\u00eanh l\u1ec7ch gi\u1eefa c\u00e1c ch\u1ec9 ti\u00eau tr\u01b0\u1edbc v\u00e0 sau. V\u00ed d\u1ee5:<\/p>\n<p style=\"padding-left: 30px\">Ch\u1ec9 ti\u00eau tr\u01b0\u1edbc l\u00e0 H\u00e0 N\u1ed9i c\u00f3 s\u1ed1 l\u01b0\u1ee3ng 100. Ch\u1ec9 ti\u00eau sau l\u00e0 H\u1ea3i Ph\u00f2ng c\u00f3 s\u1ed1\u00a0l\u01b0\u1ee3ng 85.<\/p>\n<p style=\"padding-left: 30px\">Ph\u1ea7n ch\u00eanh l\u1ec7ch l\u00e0 hi\u1ec7u c\u1ee7a ch\u1ec9 ti\u00eau sau \u2013 ch\u1ec9 ti\u00eau tr\u01b0\u1edbc = B3-B2<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ea5y ph\u1ea7n ch\u00eanh l\u1ec7ch chia cho ch\u1ec9 ti\u00eau tr\u01b0\u1edbc\u00a0\u0111\u1ec3 ra t\u1ef7 l\u1ec7 ch\u00eanh l\u1ec7ch<\/p>\n<p style=\"padding-left: 30px\">=(B3-B2)\/B2<\/p>\n<p style=\"padding-left: 30px\">Khi\u00a0\u0111\u00f3 n\u1ebfu ch\u1ec9 ti\u00eau sau &lt; ch\u1ec9 ti\u00eau tr\u01b0\u1edbc th\u00ec s\u1ebd ra s\u1ed1\u00a0\u00e2m<\/p>\n<p style=\"padding-left: 30px\">Ch\u1ec9 ti\u00eau sau &gt; ch\u1ec9 ti\u00eau tr\u01b0\u1edbc s\u1ebd ra s\u1ed1 d\u01b0\u01a1ng.<\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t<\/strong><\/span>:<\/p>\n<p style=\"padding-left: 30px\">G\u1ecdi\u00a0ch\u1ec9 ti\u00eau\u00a0tr\u01b0\u1edbc l\u00e0 A<\/p>\n<p style=\"padding-left: 30px\">Ch\u1ec9 ti\u00eau sau l\u00e0 B<\/p>\n<blockquote style=\"padding-left: 30px\">\n<p style=\"padding-left: 30px\">%\u00a0of Difference A\u00a0v\u00e0\u00a0B= ((B-A)\/A)*100%<\/p>\n<\/blockquote>\n<p>M\u1ed9t v\u00ed d\u1ee5 ti\u00eau bi\u1ec3u c\u1ee7a d\u1ea1ng n\u00e0y ch\u00ednh l\u00e0\u00a0\u0111\u1ec3 x\u00e2y d\u1ef1ng ra c\u00e1c b\u00e1o c\u00e1o b\u1eb1ng bi\u1ec3u\u00a0\u0111\u1ed3 d\u1ea1ng th\u00e1c n\u01b0\u1edbc (Water fall)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/bieu-do-dang-thac-nuoc-quan-ly-chenh-lech-chi-phi-du-an-excel-2016.html\">H\u01b0\u1edbng d\u1eabn t\u1ea1o bi\u1ec3u \u0111\u1ed3 d\u1ea1ng th\u00e1c n\u01b0\u1edbc qu\u1ea3n l\u00fd ch\u00eanh l\u1ec7ch chi ph\u00ed d\u1ef1 \u00e1n trong Excel 2016<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_phan_tram_luy_tien_of_Running_Total\"><\/span>C\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m l\u0169y ti\u1ebfn (%\u00a0of Running Total)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n tr\u0103m l\u0169y ti\u1ebfn l\u00e0 t\u1ef7 l\u1ec7\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c sau m\u1ed7i l\u1ea7n ghi nh\u1eadn k\u1ebft qu\u1ea3. T\u1ef7 l\u1ec7 n\u00e0y t\u0103ng d\u1ea7n t\u1edbi 100% l\u00e0 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24961\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-phan-tram-luy-tien.png\" width=\"741\" height=\"208\" title=\"tinh-phan-tram-luy-tien\"><\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00e1ch t\u00ednh<\/strong><\/span>:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u00ednh t\u1ed5ng to\u00e0n b\u1ed9 qu\u00e1 tr\u00ecnh. T\u1ea1i\u00a0\u00f4 C7 ghi nh\u1eadn t\u1ed5ng s\u1ea3n l\u01b0\u1ee3ng = SUM(C2:C6) = 22<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: T\u00ednh t\u1ed5ng sau m\u1ed7i l\u1ea7n ghi nh\u1eadn k\u1ebft qu\u1ea3:<\/p>\n<p style=\"padding-left: 30px\">=SUM($C$2:C2)<\/p>\n<p style=\"padding-left: 30px\">S\u1eed d\u1ee5ng h\u00e0m SUM\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng. Ch\u00fa\u00a0\u00fd c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u l\u00e0\u00a0\u00f4 C2, v\u00f9ng t\u00ednh t\u1ed5ng\u00a0\u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng d\u1ea7n ra theo m\u1ed7i d\u00f2ng<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: L\u1ea5y t\u1ed5ng t\u1eebng l\u1ea7n chia cho t\u1ed5ng to\u00e0n b\u1ed9 qu\u00e1 tr\u00ecnh\u00a0\u0111\u1ec3 ra t\u1ef7 l\u1ec7 %\u00a0l\u0169y ti\u1ebfn sau t\u1eebng l\u1ea7n<\/p>\n<p style=\"padding-left: 30px\">E2=SUM($C$2:C2)\/$C$7<\/p>\n<p style=\"padding-left: 30px\">T\u1ea1i m\u1ed7i l\u1ea7n\u00a0\u0111\u1ec1u chia cho t\u1ed5ng to\u00e0n b\u1ed9 (\u00f4 C7) do\u00a0\u0111\u00f3 c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u00f4 C7 trong c\u00f4ng th\u1ee9c.<\/p>\n<p><span style=\"text-decoration: underline\"><strong>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t<\/strong><\/span>:<\/p>\n<p style=\"padding-left: 30px\">G\u1ecdi t\u1ed5ng t\u1eebng\u00a0\u0111o\u1ea1n l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb A1, A2, A3\u2026<\/p>\n<p style=\"padding-left: 30px\">T\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c\u00a0\u0111o\u1ea1n l\u00e0 Sum_A<\/p>\n<p style=\"padding-left: 60px\">%\u00a0of Running Total t\u1ea1i A1 = (A1\/Sum_A)*100%<\/p>\n<p style=\"padding-left: 60px\">%\u00a0of Running Total t\u1ea1i A2 = (A2\/Sum_A)*100%<\/p>\n<p>Tr\u00ean\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch t\u00ednh % th\u01b0\u1eddng g\u1eb7p trong c\u00e1c b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.\u00a0\u0110\u1ec3 b\u1ed5 sung th\u00eam cho c\u00e1c ki\u1ebfn th\u1ee9c tr\u00ean, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p>1. S\u1eed d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n s\u1ed1\u00a0\u0111\u1ec3 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3 t\u00ednh %, v\u00ec th\u01b0\u1eddng k\u1ebft qu\u1ea3 t\u00ednh ra s\u1ed1 l\u1ebb<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-ham-lam-tron-so-trong-excel-va-cac-nguyen-tac-lam-tron-so.html\">T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u00e0 c\u00e1c nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n s\u1ed1<\/a><\/p>\n<p>2. C\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb % khi th\u1ef1c hi\u1ec7n b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-cach-bieu-dien-gia-tri-phan-tram-trong-bao-cao-bang-pivot-table.html\">T\u00ecm hi\u1ec3u c\u00e1ch bi\u1ec3u di\u1ec5n gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/a><\/p>\n<p>3. T\u00ecm hi\u1ec3u v\u1ec1 k\u1ef9 n\u0103ng b\u00e1o c\u00e1o tr\u00ean\u00a0Excel<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-ban-can-hoc-ky-nang-chuc-du-lieu-va-lap-bao-cao-tren-excel.html\">T\u1ea1i sao b\u1ea1n c\u1ea7n h\u1ecdc k\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel<\/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-424.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5060,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5059","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\/5059","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=5059"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5059\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5060"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}