{"id":259977,"date":"2023-09-21T09:46:28","date_gmt":"2023-09-21T02:46:28","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=259977"},"modified":"2025-10-17T10:35:56","modified_gmt":"2025-10-17T03:35:56","slug":"tinh-phan-tram-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">L\u00e0m sao \u0111\u1ec3 <\/span><b>t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/b><span style=\"font-weight: 400;\"> nhanh v\u00e0 hi\u1ec7u qu\u1ea3 \u0111ang l\u00e0 m\u1ed9t trong nh\u1eefng ch\u1ee7 \u0111\u1ec1 m\u00e0 <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u nh\u1ea5t trong c\u00e1c b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y. Do \u0111\u00f3, n\u1ed9i dung c\u1ee7a b\u00e0i vi\u1ebft ng\u00e0y h\u00f4m nay s\u1ebd d\u00e0nh ri\u00eang cho vi\u1ec7c h\u01b0\u1edbng d\u1eabn ng\u01b0\u1eddi d\u00f9ng c\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng nh\u1ea5t v\u1edbi c\u00f4ng c\u1ee5 Excel. N\u00e0o, h\u00e3y c\u00f9ng ch\u00fang t\u00f4i kh\u00e1m ph\u00e1 ngay c\u00e1c ph\u01b0\u01a1ng ph\u00e1p ph\u1ed5 bi\u1ebfn \u1ea5y trong t\u1eebng g\u1ee3i \u00fd d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h2>Hi\u1ec3u b\u1ea3n ch\u1ea5t v\u00e0 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m (%) trong Excel<\/h2>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c, \u0111i\u1ec1u quan tr\u1ecdng nh\u1ea5t l\u00e0 ph\u1ea3i hi\u1ec3u c\u00e1ch Excel x\u1eed l\u00fd ph\u1ea7n tr\u0103m. V\u1ec1 b\u1ea3n ch\u1ea5t, Excel l\u01b0u tr\u1eef t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m d\u01b0\u1edbi d\u1ea1ng m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n. V\u00ed d\u1ee5:\u00a0<strong>50%<\/strong>\u00a0th\u1ef1c ch\u1ea5t \u0111\u01b0\u1ee3c l\u01b0u l\u00e0\u00a0<strong>0.5<\/strong>, v\u00e0\u00a0<strong>75%<\/strong>\u00a0\u0111\u01b0\u1ee3c l\u01b0u l\u00e0\u00a0<strong>0.75<\/strong>.<\/p>\n<p>Khi b\u1ea1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng &#8220;Percentage&#8221; (Ph\u1ea7n tr\u0103m) cho m\u1ed9t \u00f4, Excel s\u1ebd nh\u00e2n gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u00f3 v\u1edbi 100 v\u00e0 hi\u1ec3n th\u1ecb k\u00fd t\u1ef1 &#8220;%&#8221; \u1edf cu\u1ed1i.<\/p>\n<ul>\n<li><strong>Tr\u01b0\u1eddng h\u1ee3p 1: Nh\u1eadp s\u1ed1 th\u1eadp ph\u00e2n tr\u01b0\u1edbc:<\/strong>\u00a0N\u1ebfu b\u1ea1n nh\u1eadp\u00a0<code>0.25<\/code>\u00a0v\u00e0o m\u1ed9t \u00f4 v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, \u00f4 \u0111\u00f3 s\u1ebd hi\u1ec3n th\u1ecb\u00a0<strong>25%<\/strong>. \u0110\u00e2y l\u00e0 c\u00e1ch l\u00e0m \u0111\u00fang.<\/li>\n<li><strong>Tr\u01b0\u1eddng h\u1ee3p 2: Nh\u1eadp s\u1ed1 nguy\u00ean tr\u01b0\u1edbc (L\u1ed7i th\u01b0\u1eddng g\u1eb7p):<\/strong>\u00a0N\u1ebfu b\u1ea1n nh\u1eadp s\u1ed1\u00a0<code>25<\/code>\u00a0v\u00e0o m\u1ed9t \u00f4 r\u1ed3i m\u1edbi \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m, Excel s\u1ebd hi\u1ec3u l\u00e0 25 * 100 v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 l\u00e0\u00a0<strong>2500%<\/strong>. \u0110\u00e2y l\u00e0 l\u1ed7i sai ph\u1ed5 bi\u1ebfn nh\u1ea5t!\n<p><figure id=\"attachment_259979\" aria-describedby=\"caption-attachment-259979\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-259979 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1.jpg\" alt=\"tinh-phan-tram-trong-excel-1\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-1-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259979\" class=\"wp-caption-text\">\u0110\u00f4i n\u00e9t v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m (%) tr\u00ean c\u00f4ng c\u1ee5 Excel<\/figcaption><\/figure><\/li>\n<\/ul>\n<p><strong>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u0111\u00fang:<\/strong><\/p>\n<p>Tr\u00ean tab\u00a0<strong>Home<\/strong>, trong nh\u00f3m\u00a0<strong>Number<\/strong>, b\u1ea1n c\u00f3 th\u1ec3:<br \/>\n1. Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong>% (Percent Style)<\/strong>\u00a0\u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng nhanh.<br \/>\n2. Nh\u1ea5p v\u00e0o m\u0169i t\u00ean nh\u1ecf \u1edf g\u00f3c nh\u00f3m Number \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0<strong>Format Cells<\/strong>, ch\u1ecdn\u00a0<strong>Percentage<\/strong>\u00a0v\u00e0 t\u00f9y ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n (Decimal places) n\u1ebfu c\u1ea7n.<\/p>\n<h2>T\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t hi\u1ec7n nay<\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u00f3 \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u kh\u00eda c\u1ea1nh c\u1ee7a cu\u1ed9c s\u1ed1ng. Ch\u1eb3ng h\u1ea1n nh\u01b0: t\u00ednh ti\u1ec1n boa trong nh\u00e0 h\u00e0ng, ph\u00e2n chia hoa h\u1ed3ng cho c\u00e1c nh\u00e0 b\u00e1n l\u1ebb, t\u00ednh thu\u1ebf thu nh\u1eadp ho\u1eb7c t\u00ednh l\u00e3i su\u1ea5t. N\u1ebfu \u0111ang g\u1eb7p r\u1eafc r\u1ed1i trong thao t\u00e1c t\u00ednh to\u00e1n, \u0111\u1eebng ng\u1ea7n ng\u1ea1i, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay.<\/span><\/p>\n<h3>C\u00e1ch T\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t ph\u1ea7n so v\u1edbi t\u1ed5ng s\u1ed1<\/h3>\n<p>\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p c\u01a1 b\u1ea3n nh\u1ea5t, d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ed9t gi\u00e1 tr\u1ecb chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m trong t\u1ed5ng th\u1ec3.<\/p>\n<p><strong>C\u00f4ng th\u1ee9c:<\/strong>\u00a0= (Gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n \/ T\u1ed5ng gi\u00e1 tr\u1ecb)<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0T\u1ea1i \u00f4 c\u1ea7n t\u00ednh ph\u1ea7n tr\u0103m, nh\u1eadp c\u00f4ng th\u1ee9c chia gi\u00e1 tr\u1ecb c\u1ee7a m\u1ee5c \u0111\u00f3 cho \u00f4 ch\u1ee9a t\u1ed5ng gi\u00e1 tr\u1ecb. V\u00ed d\u1ee5: \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a s\u1ea3n ph\u1ea9m \u1edf \u00f4 B2 so v\u1edbi t\u1ed5ng \u1edf \u00f4 B10, c\u00f4ng th\u1ee9c s\u1ebd l\u00e0\u00a0=B2\/B$10.<br \/>\n<strong>L\u01b0u \u00fd quan tr\u1ecdng:<\/strong>\u00a0S\u1eed d\u1ee5ng k\u00fd hi\u1ec7u\u00a0$\u00a0(tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i) nh\u01b0\u00a0B$10\u00a0\u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 t\u1ed5ng. \u0110i\u1ec1u n\u00e0y \u0111\u1ea3m b\u1ea3o khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng kh\u00e1c, \u00f4 t\u1ed5ng s\u1ebd kh\u00f4ng b\u1ecb thay \u0111\u1ed5i.<\/li>\n<li><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Nh\u1ea5n Enter. K\u1ebft qu\u1ea3 ban \u0111\u1ea7u c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<li><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn \u00f4 k\u1ebft qu\u1ea3, v\u00e0o tab\u00a0<strong>Home<\/strong>\u00a0v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong>%<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/li>\n<li><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0\u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 c\u00f4ng th\u1ee9c cho \u0111\u1ebfn khi n\u00f3 bi\u1ebfn th\u00e0nh d\u1ea5u c\u1ed9ng m\u00e0u \u0111en (+), sau \u0111\u00f3 k\u00e9o xu\u1ed1ng \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/li>\n<\/ul>\n<figure id=\"attachment_259980\" aria-describedby=\"caption-attachment-259980\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-259980 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2.jpg\" alt=\"tinh-phan-tram-trong-excel-2\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-2-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259980\" class=\"wp-caption-text\">Ti\u1ebfn h\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m theo h\u01b0\u1edbng d\u1eabn<\/figcaption><\/figure>\n<figure id=\"attachment_259981\" aria-describedby=\"caption-attachment-259981\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-259981 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3.jpg\" alt=\"tinh-phan-tram-trong-excel-3\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-3-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259981\" class=\"wp-caption-text\">K\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng kh\u00e1c<\/figcaption><\/figure>\n<h3>C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m ch\u00eanh l\u1ec7ch trong Excel<\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m trong Excel theo tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: <\/span><b>T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m (%) = (Gi\u00e1 tr\u1ecb m\u1edbi &#8211; Gi\u00e1 tr\u1ecb c\u0169) \/ Gi\u00e1 tr\u1ecb c\u0169<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400;\">: Ng\u01b0\u1eddi d\u00f9ng b\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c m\u1edf b\u1ea3ng Excel m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i. Sau \u0111\u00f3, nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i b\u00ean tr\u00ean. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh s\u1ef1 t\u0103ng\/gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng qu\u1ea3 Cherry so v\u1edbi th\u00e1ng tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp: =(C2-B2)\/B2. Trong \u0111\u00f3 C2 l\u00e0 gi\u00e1 tr\u1ecb th\u00e1ng tr\u01b0\u1edbc v\u00e0 B2 l\u00e0 gi\u00e1 tr\u1ecb th\u00e1ng hi\u1ec7n t\u1ea1i c\u1ee7a s\u1ed1 l\u01b0\u1ee3ng Cherry.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259982\" aria-describedby=\"caption-attachment-259982\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259982 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4.jpg\" alt=\"tinh-phan-tram-trong-excel-4\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-4-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259982\" class=\"wp-caption-text\">Nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i \u0111\u01b0\u1ee3c g\u1ee3i \u00fd b\u00ean tr\u00ean<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 2<\/b><span style=\"font-weight: 400;\">: Trong nh\u00f3m \u201cNumber\u201d c\u1ee7a tab \u201cHome\u201d, ng\u01b0\u1eddi d\u00f9ng ti\u1ebfp t\u1ee5c ch\u1ecdn m\u1ee5c \u201cPercentage\u201d \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch ch\u1ecdn \u201cMore Number Formats\u201d.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259983\" aria-describedby=\"caption-attachment-259983\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259983 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5.jpg\" alt=\"tinh-phan-tram-trong-excel-5\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-5-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259983\" class=\"wp-caption-text\">Ch\u1ecdn m\u1ee5c \u201cPercentage\u201d \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 3<\/b><span style=\"font-weight: 400;\">: \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng d\u01b0\u1edbi, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ch\u1ec9 c\u1ea7n \u0111\u1ec3 chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi c\u1ee7a \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. Khi con tr\u1ecf chu\u1ed9t tr\u1edf th\u00e0nh bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng (+), b\u1ea1n k\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng kh\u00e1c. Nh\u01b0 v\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh c\u00e1c thao t\u00e1c trong vi\u1ec7c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i cho to\u00e0n b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean Excel r\u1ed3i \u0111\u1ea5y.<\/span><\/li>\n<\/ul>\n<h3>C\u00e1ch t\u00ednh gi\u00e1 tr\u1ecb khi \u0111\u00e3 c\u00f3 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel<\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb khi bi\u1ebft ph\u1ea7n tr\u0103m, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: <\/span><b>Gi\u00e1 tr\u1ecb = T\u1ed5ng s\u1ed1 * T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m (%)<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400;\">: Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n k\u00edch ho\u1ea1t b\u1ea3ng Excel m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n. Sau \u0111\u00f3, nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch nh\u00e2n t\u1ed5ng s\u1ed1 v\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh 11% c\u1ee7a t\u1ed5ng s\u1ed1 $950, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c: = A2 * B2. Trong \u0111\u00f3 A2 l\u00e0 gi\u00e1 tr\u1ecb t\u1ed5ng s\u1ed1 v\u00e0 B2 l\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m m\u00e0 \u0111\u1ec1 b\u00e0i cho.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259984\" aria-describedby=\"caption-attachment-259984\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259984 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6.jpg\" alt=\"tinh-phan-tram-trong-excel-6\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-6-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259984\" class=\"wp-caption-text\">Nh\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00ecnh minh h\u1ecda<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 2<\/b><span style=\"font-weight: 400;\">: \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n \u0111\u1ec3 chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi c\u1ee7a \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. Khi con tr\u1ecf chu\u1ed9t tr\u1edf th\u00e0nh bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng (+), b\u1ea1n k\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c h\u00e0ng kh\u00e1c, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel c\u1ee7a 2 ph\u01b0\u01a1ng ph\u00e1p ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u b\u00ean tr\u00ean.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259985\" aria-describedby=\"caption-attachment-259985\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259985 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7.jpg\" alt=\"tinh-phan-tram-trong-excel-7\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-7-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259985\" class=\"wp-caption-text\">K\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c nh\u01b0 2 c\u00e1ch t\u00ednh tr\u00ean<\/figcaption><\/figure>\n<h3>C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m ph\u1ed5 bi\u1ebfn hi\u1ec7n nay<\/h3>\n<p><span style=\"font-weight: 400;\">\u00c1p d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c khi\u1ebfn nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng g\u1eb7p nhi\u1ec1u r\u1eafc r\u1ed1i hi\u1ec7n nay. Th\u1ea5u hi\u1ec3u \u0111i\u1ec1u \u0111\u00f3, n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n c\u1ea3i thi\u1ec7n \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 n\u00e0y th\u00f4ng qua c\u00e1c g\u1ee3i \u00fd sau:<\/span><\/p>\n<h4>T\u00ednh ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng chung trong Excel<\/h4>\n<p><span style=\"font-weight: 400;\">Khi ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n bi\u1ebft m\u1ed7i gi\u00e1 tr\u1ecb chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng chung theo c\u00f4ng th\u1ee9c nh\u01b0:<\/span><b> % of Grand Total = (A \/ Sum_A) * 100%<\/b><span style=\"font-weight: 400;\">. Trong \u0111\u00f3 A l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ph\u1ea7n t\u1eed c\u1ee5 th\u1ec3 v\u00e0 Sum_A l\u00e0 t\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c ph\u1ea7n t\u1eed. C\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o qua v\u00ed d\u1ee5 c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400;\">: X\u00e1c \u0111\u1ecbnh t\u1ed5ng chung t\u1ea1i m\u1ed9t \u00f4. Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m SUM: B8 = SUM(B2:B7) cho \u00f4 d\u1eef li\u1ec7u B8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 2<\/b><span style=\"font-weight: 400;\">: T\u1ea1i m\u1ed7i \u00f4 d\u1eef li\u1ec7u c\u1ea7n t\u00ednh ph\u1ea7n tr\u0103m, ng\u01b0\u1eddi d\u00f9ng ti\u1ebfn h\u00e0nh chia gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u0111\u00f3 cho t\u1ed5ng chung \u0111\u00e3 t\u00ednh \u1edf B8. V\u00ed d\u1ee5, t\u1ea1i \u00f4 C2, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c C2 = B2\/B$8. \u0110\u1ed3ng th\u1eddi c\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4 B8 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng d\u1ea5u $ khi t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean Excel.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259986\" aria-describedby=\"caption-attachment-259986\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259986 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8.jpg\" alt=\"tinh-phan-tram-trong-excel-8\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-8-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259986\" class=\"wp-caption-text\">V\u00ed d\u1ee5 1: C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng chung trong Excel<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 3<\/b><span style=\"font-weight: 400;\">: \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u1ea7n t\u00ednh ph\u1ea7n tr\u0103m. B\u1ea1n c\u00f3 th\u1ec3 k\u00e9o xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 4<\/b><span style=\"font-weight: 400;\">: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u201cFormat Cells\u201d. Ch\u00fa \u00fd r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. V\u00ed d\u1ee5, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 cho ph\u00e9p k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb \u1edf d\u1ea1ng 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n n\u1ebfu c\u1ea7n.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259987\" aria-describedby=\"caption-attachment-259987\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259987 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9.jpg\" alt=\"tinh-phan-tram-trong-excel-9\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-9-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259987\" class=\"wp-caption-text\">V\u00ed d\u1ee5 2: C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng chung trong Excel<\/figcaption><\/figure>\n<h4>T\u00ednh ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng nh\u00f3m trong Excel<\/h4>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c th\u00e0nh c\u00e1c nh\u00f3m v\u00e0 mu\u1ed1n bi\u1ebft m\u1ed7i ph\u1ea7n t\u1eed chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m trong ri\u00eang nh\u00f3m \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel theo c\u00e1c g\u1ee3i \u00fd sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400;\">: B\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c x\u00e1c \u0111\u1ecbnh t\u1ed5ng c\u1ee7a nh\u00f3m \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM. V\u00ed d\u1ee5, t\u1ea1i \u00f4 B2, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a nh\u00f3m t\u1eeb B3 \u0111\u1ebfn B6 nh\u01b0 sau: B2 = SUM(B3:B6)<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259988\" aria-describedby=\"caption-attachment-259988\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259988 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10.jpg\" alt=\"tinh-phan-tram-trong-excel-10\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-10-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259988\" class=\"wp-caption-text\">\u00c1p d\u1ee5ng h\u00e0m SUM cho nh\u00f3m \u0111\u01b0\u1ee3c t\u00ednh<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 2<\/b><span style=\"font-weight: 400;\">: T\u1ea1i m\u1ed7i ph\u1ea7n t\u1eed trong nh\u00f3m, ng\u01b0\u1eddi d\u00f9ng ti\u1ebfn h\u00e0nh chia gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n t\u1eed \u0111\u00f3 cho t\u1ed5ng c\u1ee7a nh\u00f3m \u0111\u00e3 t\u00ednh \u1edf B2. L\u01b0u \u00fd r\u1eb1ng b\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a \u00f4 t\u00ednh t\u1ed5ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng d\u1ea5u $ trong c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5, t\u1ea1i \u00f4 C3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c C3 = B3 \/ $B$2. Sau \u0111\u00f3, \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 cho t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n t\u1eed t\u1eeb C3 \u0111\u1ebfn C6 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_259989\" aria-describedby=\"caption-attachment-259989\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259989 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11.jpg\" alt=\"tinh-phan-tram-trong-excel-11\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-11-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259989\" class=\"wp-caption-text\">\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 cho t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n t\u1eed t\u1eeb C3 \u0111\u1ebfn C6<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><b>B\u01b0\u1edbc 3<\/b><span style=\"font-weight: 400;\">: N\u1ebfu b\u1ea1n mu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1eebng nh\u00f3m b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM. K\u1ebft qu\u1ea3 s\u1ebd lu\u00f4n l\u00e0 100% cho m\u1ed7i nh\u00f3m (\u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf c\u00e1c \u00f4 C2 v\u00e0 C7).\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u1eeb \u0111\u00f3, ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t \u0111\u1ec3 t\u00ednh <\/span><b>% of Parent Total = (A \/ Subtotal_A) * 100%<\/b><span style=\"font-weight: 400;\">ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t ph\u1ea7n t\u1eed so v\u1edbi t\u1ed5ng c\u1ee7a nh\u00f3m \u0111\u00f3 l\u00e0: . Trong \u0111\u00f3, A l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ph\u1ea7n t\u1eed c\u1ee5 th\u1ec3 v\u00e0 Subtotal_A l\u00e0 t\u1ed5ng c\u1ee7a nh\u00f3m ch\u1ee9a ph\u1ea7n t\u1eed \u0111\u00f3.<\/span><\/p>\n<h2>\u1ee8ng d\u1ee5ng c\u1ee7a vi\u1ec7c t\u00ednh ph\u1ea7n tr\u0103m trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp<\/h2>\n<p>Vi\u1ec7c th\u00e0nh th\u1ea1o c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m trong Excel gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft nhi\u1ec1u b\u00e0i to\u00e1n th\u1ef1c t\u1ebf:<\/p>\n<ul>\n<li><strong>Kinh doanh &amp; B\u00e1n h\u00e0ng:<\/strong>\u00a0T\u00ednh t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh KPI, ph\u1ea7n tr\u0103m t\u0103ng tr\u01b0\u1edfng doanh thu so v\u1edbi th\u00e1ng tr\u01b0\u1edbc, t\u00ednh ti\u1ec1n chi\u1ebft kh\u1ea5u, hoa h\u1ed3ng cho nh\u00e2n vi\u00ean.<\/li>\n<li><strong>T\u00e0i ch\u00ednh &amp; K\u1ebf to\u00e1n:<\/strong>\u00a0T\u00ednh thu\u1ebf GTGT, ph\u00e2n b\u1ed5 chi ph\u00ed, t\u00ednh t\u1ef7 su\u1ea5t l\u1ee3i nhu\u1eadn, l\u00e3i su\u1ea5t vay.<\/li>\n<li><strong>H\u1ecdc t\u1eadp &amp; Nghi\u00ean c\u1ee9u:<\/strong>\u00a0T\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111i\u1ec3m s\u1ed1, ph\u00e2n t\u00edch d\u1eef li\u1ec7u kh\u1ea3o s\u00e1t.<\/li>\n<li><strong>Qu\u1ea3n l\u00fd d\u1ef1 \u00e1n:<\/strong>\u00a0Theo d\u00f5i ph\u1ea7n tr\u0103m ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c \u0111\u00e3 ho\u00e0n th\u00e0nh.<\/li>\n<\/ul>\n<h2>Nh\u1eefng l\u01b0u \u00fd quan tr\u1ecdng \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m ch\u00ednh x\u00e1c<\/h2>\n<ul>\n<li><strong>\u0110\u1ecbnh d\u1ea1ng \u0111\u00fang \u00f4:<\/strong>\u00a0Lu\u00f4n \u0111\u1ea3m b\u1ea3o \u00f4 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 &#8220;Percentage&#8221;.<\/li>\n<li><strong>S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ($):<\/strong>\u00a0Khi chia cho m\u1ed9t gi\u00e1 tr\u1ecb t\u1ed5ng kh\u00f4ng \u0111\u1ed5i (nh\u01b0 t\u1ed5ng doanh thu, t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng), h\u00e3y d\u00f9ng\u00a0<code>$<\/code>\u00a0\u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh \u00f4 \u0111\u00f3 (v\u00ed d\u1ee5:\u00a0<code>$B$10<\/code>) tr\u01b0\u1edbc khi sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Ki\u1ec3m tra l\u1ed7i\u00a0<code>#DIV\/0!<\/code>:<\/strong>\u00a0L\u1ed7i n\u00e0y x\u1ea3y ra khi b\u1ea1n chia cho 0. H\u00e3y \u0111\u1ea3m b\u1ea3o \u00f4 m\u1eabu s\u1ed1 (s\u1ed1 chia) c\u1ee7a b\u1ea1n c\u00f3 gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7.<\/li>\n<li><strong>Hi\u1ec3u s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa t\u0103ng tr\u01b0\u1edfng v\u00e0 t\u1ef7 tr\u1ecdng:<\/strong>\u00a0C\u00f4ng th\u1ee9c t\u00ednh &#8220;% thay \u0111\u1ed5i&#8221; kh\u00e1c v\u1edbi c\u00f4ng th\u1ee9c t\u00ednh &#8220;t\u1ef7 l\u1ec7 % c\u1ee7a m\u1ed9t ph\u1ea7n trong t\u1ed5ng&#8221;. \u0110\u1eebng nh\u1ea7m l\u1eabn gi\u1eefa hai tr\u01b0\u1eddng h\u1ee3p.<\/li>\n<li><strong>Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o:<\/strong>\u00a0Sai s\u00f3t trong d\u1eef li\u1ec7u ngu\u1ed3n s\u1ebd d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 sai, d\u00f9 c\u00f4ng th\u1ee9c \u0111\u00fang.<\/li>\n<\/ul>\n<figure id=\"attachment_259990\" aria-describedby=\"caption-attachment-259990\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-259990 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12.jpg\" alt=\"tinh-phan-tram-trong-excel-12\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel-12-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-259990\" class=\"wp-caption-text\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/figcaption><\/figure>\n<h2>L\u1eddi k\u1ebft<\/h2>\n<p><span style=\"font-weight: 400;\">B\u00ean tr\u00ean l\u00e0 to\u00e0n b\u1ed9 c\u00e1c <\/span><b>c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 t\u1ed5ng h\u1ee3p \u0111\u01b0\u1ee3c. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n th\u00e0nh c\u00f4ng trong vi\u1ec7c ho\u00e0n th\u00e0nh c\u00e1c b\u00e0i t\u1eadp c\u00f3 li\u00ean quan \u0111\u1ebfn vi\u1ec7c t\u00ednh to\u00e1n tr\u00ean c\u00f4ng c\u1ee5 Excel. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n c\u00f3 c\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m n\u00e0o hay h\u01a1n th\u00ec c\u00f3 th\u1ec3 b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi \u0111\u1ec3 ch\u00fang t\u00f4i c\u1eadp nh\u1eadt v\u00e0o b\u00e0i vi\u1ebft nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/them-hang-trong-excel\/\"><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n khi xo\u00e1, th\u00eam h\u00e0ng trong Excel<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\"><span style=\"font-weight: 400;\">C\u00e1c th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n nh\u1ea5t b\u1ea1n c\u1ea7n n\u1eafm<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-co-dinh-o-trong-excel\/\"><span style=\"font-weight: 400;\">C\u00e1c c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>L\u00e0m sao \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m trong Excel nhanh v\u00e0 hi\u1ec7u qu\u1ea3 \u0111ang l\u00e0 m\u1ed9t trong nh\u1eefng ch\u1ee7 \u0111\u1ec1 m\u00e0 Ho\u00e0ng H\u00e0 Mobile nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u nh\u1ea5t trong c\u00e1c b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y. Do \u0111\u00f3, n\u1ed9i dung c\u1ee7a b\u00e0i vi\u1ebft ng\u00e0y h\u00f4m nay s\u1ebd d\u00e0nh ri\u00eang cho vi\u1ec7c h\u01b0\u1edbng d\u1eabn ng\u01b0\u1eddi d\u00f9ng c\u00e1ch t\u00ednh t\u1ef7 [&hellip;]<\/p>\n","protected":false},"author":101,"featured_media":259978,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-259977","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel: C\u00f4ng Th\u1ee9c &amp; V\u00ed d\u1ee5 D\u1ec5 Hi\u1ec3u<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-21T02:46:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-17T03:35:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3\"},\"headline\":\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)\",\"datePublished\":\"2023-09-21T02:46:28+00:00\",\"dateModified\":\"2025-10-17T03:35:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\"},\"wordCount\":3305,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\",\"name\":\"5 C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel: C\u00f4ng Th\u1ee9c & V\u00ed d\u1ee5 D\u1ec5 Hi\u1ec3u\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg\",\"datePublished\":\"2023-09-21T02:46:28+00:00\",\"dateModified\":\"2025-10-17T03:35:56+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel: C\u00f4ng Th\u1ee9c & V\u00ed d\u1ee5 D\u1ec5 Hi\u1ec3u","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)","og_description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-21T02:46:28+00:00","article_modified_time":"2025-10-17T03:35:56+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3"},"headline":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)","datePublished":"2023-09-21T02:46:28+00:00","dateModified":"2025-10-17T03:35:56+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/"},"wordCount":3305,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/","name":"5 C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel: C\u00f4ng Th\u1ee9c & V\u00ed d\u1ee5 D\u1ec5 Hi\u1ec3u","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg","datePublished":"2023-09-21T02:46:28+00:00","dateModified":"2025-10-17T03:35:56+00:00","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5+ c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Bao g\u1ed3m t\u00ednh % thay \u0111\u1ed5i, chi\u1ebft kh\u1ea5u, t\u0103ng tr\u01b0\u1edfng v\u00e0 c\u00e1c m\u1eb9o \u0111\u1ecbnh d\u1ea1ng. Xem ngay!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/tinh-phan-tram-trong-excel.jpg","width":1200,"height":628,"caption":"C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-phan-tram-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp C\u00e1ch T\u00ednh Ph\u1ea7n Tr\u0103m trong Excel (K\u00e8m V\u00ed D\u1ee5 Chi Ti\u1ebft)"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3","name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/259977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/101"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=259977"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/259977\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/259978"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=259977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=259977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=259977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}