{"id":470768,"date":"2025-07-06T11:44:54","date_gmt":"2025-07-06T04:44:54","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=470768"},"modified":"2025-07-06T11:44:54","modified_gmt":"2025-07-06T04:44:54","slug":"ham-tinh-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/","title":{"rendered":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>H\u00e0m t\u00ednh % trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong c\u00e1c ph\u00e9p t\u00ednh. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh ph\u1ea7n tr\u0103m trong Excel chu\u1ea9n nh\u1ea5t, \u0111i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3 \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>T\u1ea1i sao n\u00ean bi\u1ebft h\u00e0m t\u00ednh % trong Excel?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u, kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m gi\u00fap b\u1ea1n nhanh ch\u00f3ng nh\u1eadn di\u1ec7n m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c con s\u1ed1. V\u00ed d\u1ee5, trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, ph\u1ea7n tr\u0103m cho th\u1ea5y m\u1ee9c t\u0103ng tr\u01b0\u1edfng doanh thu, t\u1ef7 l\u1ec7 l\u00e3i g\u1ed9p hay ph\u1ea7n tr\u0103m chi ph\u00ed so v\u1edbi ng\u00e2n s\u00e1ch. Thay v\u00ec ch\u1ec9 nh\u00ecn v\u00e0o con s\u1ed1 tuy\u1ec7t \u0111\u1ed1i, vi\u1ec7c bi\u1ec3u th\u1ecb d\u1eef li\u1ec7u b\u1eb1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m gi\u00fap th\u00f4ng tin tr\u1edf n\u00ean d\u1ec5 hi\u1ec3u h\u01a1n, l\u00e0m n\u1ed5i b\u1eadt xu h\u01b0\u1edbng, thay \u0111\u1ed5i v\u00e0 s\u1ef1 t\u01b0\u01a1ng quan gi\u1eefa c\u00e1c y\u1ebfu t\u1ed1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-470774 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-1.jpg\" alt=\"ham-tinh-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi c\u00f3 \u0111\u01b0\u1ee3c c\u00e1c con s\u1ed1 ph\u1ea7n tr\u0103m, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u qua bi\u1ec3u \u0111\u1ed3 ho\u1eb7c \u0111\u1ed3 th\u1ecb. Bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n, c\u1ed9t, hay \u0111\u01b0\u1eddng th\u1eb3ng \u0111\u1ec1u gi\u00fap truy\u1ec1n t\u1ea3i \u00fd ngh\u0129a d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c quan, ph\u1ee5c v\u1ee5 t\u1ed1t cho c\u00e1c b\u00e0i thuy\u1ebft tr\u00ecnh, b\u00e1o c\u00e1o, ho\u1eb7c ph\u00e2n t\u00edch \u0111\u1ecbnh h\u01b0\u1edbng chi\u1ebfn l\u01b0\u1ee3c. Vi\u1ec7c n\u00e0y kh\u00f4ng nh\u1eefng gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t v\u1ea5n \u0111\u1ec1 m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi kh\u00e1c ti\u1ebfp nh\u1eadn th\u00f4ng tin m\u1ed9t c\u00e1ch m\u1ea1ch l\u1ea1c h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong vi\u1ec7c qu\u1ea3n l\u00fd ng\u00e2n s\u00e1ch. T\u00ednh ph\u1ea7n tr\u0103m chi ti\u00eau, ph\u00e2n b\u1ed5 chi ph\u00ed hay so s\u00e1nh t\u1ef7 l\u1ec7 l\u1ee3i nhu\u1eadn \u0111\u1ec1u d\u1ef1a v\u00e0o kh\u1ea3 n\u0103ng x\u1eed l\u00fd ph\u1ea7n tr\u0103m ch\u00ednh x\u00e1c. T\u1eeb \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t t\u00e0i ch\u00ednh hi\u1ec7u qu\u1ea3, ph\u00e1t hi\u1ec7n l\u1ed7 h\u1ed5ng trong k\u1ebf ho\u1ea1ch chi ti\u00eau, c\u0169ng nh\u01b0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh ph\u00f9 h\u1ee3p v\u1edbi t\u00ecnh h\u00ecnh th\u1ef1c t\u1ebf.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Percentage format <\/span><b>(h\u00e0m t\u00ednh % trong Excel)<\/b><span style=\"font-weight: 400;\"> kh\u00f4ng ch\u1ec9 ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n h\u1ea1n ch\u1ebf sai s\u00f3t trong qu\u00e1 tr\u00ecnh nh\u1eadp v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u. Thay v\u00ec hi\u1ec3n th\u1ecb c\u00e1c con s\u1ed1 th\u1eadp ph\u00e2n nh\u01b0 0.25 hay 0.87, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i th\u00e0nh 25% ho\u1eb7c 87% khi \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng. \u0110\u00e2y l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0ng r\u1ea5t c\u1ea7n thi\u1ebft trong qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n c\u1ea7n tr\u00ecnh b\u00e0y th\u00f4ng tin m\u1ed9t c\u00e1ch ng\u1eafn g\u1ecdn, d\u1ec5 hi\u1ec3u cho ng\u01b0\u1eddi kh\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m. <\/span><span style=\"font-weight: 400;\">Tr\u00ean thanh c\u00f4ng c\u1ee5, chuy\u1ec3n sang tab Home.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-470775 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-2.jpg\" alt=\"ham-tinh-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Trong nh\u00f3m Number, nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng % \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-470776 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-3.jpg\" alt=\"ham-tinh-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: T\u00f9y ch\u1ecdn kh\u00e1c: Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng \u2192 ch\u1ecdn Format Cells \u2192 trong h\u1ed9p tho\u1ea1i hi\u1ec7n ra, ch\u1ecdn m\u1ee5c Percentage \u2192 nh\u1ea5n OK.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470777 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-4.jpg\" alt=\"ham-tinh-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi th\u1ef1c hi\u1ec7n xong, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb s\u1ed1 li\u1ec7u v\u1edbi k\u00fd hi\u1ec7u %, gi\u00fap b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n tr\u1edf n\u00ean r\u00f5 r\u00e0ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel c\u01a1 b\u1ea3n<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u1edbi d\u1eef li\u1ec7u s\u1ed1 trong Excel, vi\u1ec7c n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % c\u01a1 b\u1ea3n l\u00e0 \u0111i\u1ec1u r\u1ea5t quan tr\u1ecdng. Nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0y gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ednh t\u1ef7 l\u1ec7, so s\u00e1nh gi\u00e1 tr\u1ecb, theo d\u00f5i s\u1ef1 thay \u0111\u1ed5i ho\u1eb7c ph\u00e2n t\u00edch hi\u1ec7u su\u1ea5t m\u00e0 kh\u00f4ng m\u1ea5t qu\u00e1 nhi\u1ec1u th\u1eddi gian. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m ph\u1ed5 bi\u1ebfn, d\u1ec5 \u00e1p d\u1ee5ng trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>T\u00ednh t\u1ef7 l\u1ec7 % m\u1ed9t gi\u00e1 tr\u1ecb trong t\u1ed5ng<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, vi\u1ec7c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t ph\u1ea7n so v\u1edbi t\u1ed5ng th\u1ec3 l\u00e0 thao t\u00e1c ph\u1ed5 bi\u1ebfn v\u00e0 c\u1ea7n thi\u1ebft, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n mu\u1ed1n bi\u1ebft m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m trong to\u00e0n b\u1ed9 t\u1eadp h\u1ee3p. Excel cung c\u1ea5p c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian khi ph\u00e2n t\u00edch th\u00f4ng tin. T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m kh\u00f4ng ch\u1ec9 l\u00e0m r\u00f5 m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c s\u1ed1 li\u1ec7u m\u00e0 c\u00f2n gi\u00fap tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u r\u00f5 r\u00e0ng h\u01a1n khi tr\u00ecnh b\u00e0y trong b\u00e1o c\u00e1o, b\u1ea3ng bi\u1ec3u ho\u1eb7c bi\u1ec3u \u0111\u1ed3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470778 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-5.jpg\" alt=\"ham-tinh-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh (v\u00ed d\u1ee5: \u00f4 C4 l\u00e0 s\u1ed1 s\u00e1ch gi\u00e1o khoa) v\u00e0 \u00f4 ch\u1ee9a t\u1ed5ng gi\u00e1 tr\u1ecb (v\u00ed d\u1ee5: \u00f4 C9 l\u00e0 t\u1ed5ng s\u1ed1 s\u00e1ch). Sau \u0111\u00f3, t\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =C4\/C9. Cu\u1ed1i c\u00f9ng l\u00e0 nh\u1ea5n ch\u1ecdn Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470779 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-6.jpg\" alt=\"ham-tinh-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>T\u00ednh t\u1ef7 l\u1ec7 % t\u1eebng ph\u1ea7n trong nhi\u1ec1u h\u00e0ng<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c trong <\/span><b>h\u00e0m t\u00ednh % trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m SUMIF k\u1ebft h\u1ee3p ph\u00e9p chia cho t\u1ed5ng gi\u00e1 tr\u1ecb to\u00e0n b\u1ed9 d\u1eef li\u1ec7u. C\u00f4ng th\u1ee9c n\u00e0y cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, sau \u0111\u00f3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch ti\u1ebfp c\u1eadn th\u00f4ng minh, ti\u1ebft ki\u1ec7m c\u00f4ng s\u1ee9c v\u00e0 \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c b\u00e1o c\u00e1o ph\u00e2n t\u00edch, th\u1ed1ng k\u00ea s\u1ea3n l\u01b0\u1ee3ng hay ki\u1ec3m k\u00ea h\u00e0ng h\u00f3a theo t\u1eebng nh\u00f3m c\u1ee5 th\u1ec3.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c l\u00e0: <\/span><b>=SUMIF(range, criteria, sum_range) \/ total<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">range: L\u00e0 ph\u1ea1m vi ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u0111ang l\u1ecdc theo t\u00ean s\u1ea3n ph\u1ea9m, th\u00ec range s\u1ebd l\u00e0 c\u1ed9t ch\u1ee9a t\u00ean c\u00e1c s\u1ea3n ph\u1ea9m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria: L\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ec3 ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">sum_range: L\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n c\u1ed9ng khi \u0111i\u1ec1u ki\u1ec7n \u1edf range \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. \u0110\u00e2y l\u00e0 ph\u1ea7n s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470780 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-7.jpg\" alt=\"ham-tinh-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c b\u1ea1n h\u00e3y v\u1eadn d\u1ee5ng v\u00e0o v\u00ed d\u1ee5 minh h\u1ecda, sau \u0111\u00f3 x\u00e1c \u0111\u1ecbnh c\u1ed9t ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m (v\u00ed d\u1ee5: B5:B11) v\u00e0 c\u1ed9t ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng (v\u00ed d\u1ee5: C5:C11). K\u1ebf \u0111\u1ebfn l\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =SUMIF(B5:B11, &#8220;A&#8221;, C5:C11)\/$C$12 c\u0169ng nh\u01b0 nh\u1ea5n Enter v\u00e0 \u0111\u1ecbnh d\u1ea1ng k\u1ebft qu\u1ea3 theo d\u1ea1ng ph\u1ea7n tr\u0103m.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % thay \u0111\u1ed5i trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c <\/span><b>h\u00e0m t\u00ednh % trong Excel<\/b><span style=\"font-weight: 400;\"> thay \u0111\u1ed5i gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u0111o l\u01b0\u1eddng m\u1ee9c t\u0103ng ho\u1eb7c gi\u1ea3m gi\u1eefa hai gi\u00e1 tr\u1ecb theo th\u1eddi gian ho\u1eb7c gi\u1eefa c\u00e1c giai \u0111o\u1ea1n kh\u00e1c nhau. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng trong vi\u1ec7c ph\u00e2n t\u00edch xu h\u01b0\u1edbng, so s\u00e1nh hi\u1ec7u su\u1ea5t v\u00e0 \u0111\u00e1nh gi\u00e1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 ch\u00ednh x\u00e1c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>T\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 h\u00e0ng<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa hai d\u00f2ng li\u00ean ti\u1ebfp gi\u00fap b\u1ea1n n\u1eafm b\u1eaft m\u1ee9c \u0111\u1ed9 bi\u1ebfn \u0111\u1ed9ng theo th\u1eddi gian ho\u1eb7c theo t\u1eebng giai \u0111o\u1ea1n c\u1ee5 th\u1ec3. \u0110\u1eb7c bi\u1ec7t, v\u1edbi nh\u1eefng c\u00f4ng vi\u1ec7c mang t\u00ednh ti\u1ebfn \u0111\u1ed9, theo d\u00f5i t\u1ef7 l\u1ec7 thay \u0111\u1ed5i t\u00edch l\u0169y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u0111\u00e1nh gi\u00e1 m\u1ee9c \u0111\u1ed9 ho\u00e0n th\u00e0nh v\u00e0 \u0111i\u1ec1u ch\u1ec9nh k\u1ebf ho\u1ea1ch ph\u00f9 h\u1ee3p. \u0110\u00e2y l\u00e0 c\u00e1ch ti\u1ebfp c\u1eadn th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c b\u00e1o c\u00e1o s\u1ea3n xu\u1ea5t, qu\u1ea3n l\u00fd d\u1ef1 \u00e1n, theo d\u00f5i ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c hay \u0111\u00e1nh gi\u00e1 hi\u1ec7u qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng theo t\u1eebng ng\u00e0y, tu\u1ea7n ho\u1eb7c th\u00e1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i c\u1ed9t D, t\u00ednh n\u0103ng su\u1ea5t t\u00edch l\u0169y theo t\u1eebng d\u00f2ng b\u1eb1ng c\u00f4ng th\u1ee9c: =SUM($C$2:C2). L\u01b0u \u00fd, b\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u b\u1eb1ng k\u00fd hi\u1ec7u $ tr\u01b0\u1edbc h\u00e0ng v\u00e0 c\u1ed9t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470781 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-8.jpg\" alt=\"ham-tinh-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i c\u1ed9t E, t\u00ednh ph\u1ea7n tr\u0103m t\u00edch l\u0169y b\u1eb1ng c\u00e1ch chia gi\u00e1 tr\u1ecb \u1edf c\u1ed9t D cho t\u1ed5ng n\u0103ng su\u1ea5t, v\u00ed d\u1ee5 \u1edf \u00f4 C7: =D2\/$C$7. S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i $C$7 \u0111\u1ec3 kh\u00f4ng thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470782 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-9.jpg\" alt=\"ham-tinh-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi ho\u00e0n t\u1ea5t, k\u1ebft qu\u1ea3 t\u1ea1i d\u00f2ng cu\u1ed1i c\u00f9ng s\u1ebd l\u00e0 100%, cho th\u1ea5y to\u00e0n b\u1ed9 c\u00f4ng vi\u1ec7c \u0111\u00e3 ho\u00e0n th\u00e0nh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470783 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-10.jpg\" alt=\"ham-tinh-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>T\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i 2 c\u1ed9t<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c <\/span><b>h\u00e0m t\u00ednh % trong Excel<\/b><span style=\"font-weight: 400;\"> thay \u0111\u1ed5i gi\u1eefa hai c\u1ed9t l\u00e0 m\u1ed9t thao t\u00e1c quan tr\u1ecdng gi\u00fap b\u1ea1n nhanh ch\u00f3ng \u0111\u00e1nh gi\u00e1 xu h\u01b0\u1edbng t\u0103ng ho\u1eb7c gi\u1ea3m c\u1ee7a d\u1eef li\u1ec7u theo th\u1eddi gian ho\u1eb7c gi\u1eefa hai nh\u00f3m kh\u00e1c nhau. C\u00e1ch t\u00ednh n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng nh\u01b0 so s\u00e1nh doanh thu c\u00e1c th\u00e1ng, theo d\u00f5i bi\u1ebfn \u0111\u1ed9ng gi\u00e1 c\u1ea3, ph\u00e2n t\u00edch s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m b\u00e1n ra, hay \u0111\u00e1nh gi\u00e1 s\u1ef1 t\u0103ng tr\u01b0\u1edfng c\u1ee7a t\u1eebng ch\u1ec9 s\u1ed1. Qua \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111\u01b0a ra nh\u1eadn \u0111\u1ecbnh c\u1ee5 th\u1ec3 v\u1ec1 m\u1ee9c \u0111\u1ed9 thay \u0111\u1ed5i v\u00e0 hi\u1ec7u qu\u1ea3 c\u1ee7a t\u1eebng giai \u0111o\u1ea1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c l\u00e0 <\/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;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470784 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-11.jpg\" alt=\"ham-tinh-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u00e0 c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u1edf c\u1ed9t D (\u00f4 D2) th\u00ec nh\u1eadp c\u00f4ng th\u1ee9c: =(C2-B2)\/B2. Ti\u1ebfp \u0111\u1ebfn l\u00e0 nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng d\u01b0\u1edbi b\u1eb1ng c\u00e1ch di chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 D2 r\u1ed3i k\u00e9o xu\u1ed1ng.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch t\u00ednh gi\u00e1 tr\u1ecb c\u1ee7a t\u1ed5ng s\u1ed1 khi bi\u1ebft t\u1ef7 l\u1ec7 % trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf, b\u1ea1n th\u01b0\u1eddng g\u1eb7p b\u00e0i to\u00e1n t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb t\u1ed5ng ho\u1eb7c s\u1ed1 ti\u1ec1n cu\u1ed1i c\u00f9ng d\u1ef1a tr\u00ean m\u1ed9t t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u00e3 bi\u1ebft. Vi\u1ec7c n\u00e0y \u0111\u1eb7c bi\u1ec7t ph\u1ed5 bi\u1ebfn trong l\u0129nh v\u1ef1c mua s\u1eafm, d\u1ecbch v\u1ee5 hay qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n. \u0110\u1ec3 l\u00e0m r\u00f5 h\u01a1n, ch\u00fang ta s\u1ebd xem x\u00e9t hai v\u00ed d\u1ee5 minh h\u1ecda \u0111i\u1ec3n h\u00ecnh v\u1ec1 c\u00e1ch \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>V\u00ed d\u1ee5 1<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, khi b\u1ea1n \u0111i \u0103n buffet v\u1edbi gi\u00e1 v\u00e9 l\u00e0 119.000 \u0111\u1ed3ng v\u00e0 ph\u1ea3i tr\u1ea3 th\u00eam 10% ti\u1ec1n thu\u1ebf, vi\u1ec7c c\u1ea7n l\u00e0m l\u00e0 t\u00ednh 10% c\u1ee7a 119.000 \u0111\u1ed3ng l\u00e0 bao nhi\u00eau.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470785 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-12.jpg\" alt=\"ham-tinh-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n l\u00e0 l\u1ea5y t\u1ed5ng s\u1ed1 nh\u00e2n v\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m: Gi\u00e1 tr\u1ecb = T\u1ed5ng s\u1ed1 \u00d7 Ph\u1ea7n tr\u0103m. \u00c1p d\u1ee5ng v\u00e0o v\u00ed d\u1ee5, b\u1ea1n s\u1ebd nhanh ch\u00f3ng bi\u1ebft \u0111\u01b0\u1ee3c s\u1ed1 ti\u1ec1n thu\u1ebf c\u1ea7n thanh to\u00e1n, gi\u00fap ki\u1ec3m so\u00e1t chi ti\u00eau ch\u00ednh x\u00e1c h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>V\u00ed d\u1ee5 2<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n mua m\u1ed9t con g\u1ea5u b\u00f4ng v\u1edbi gi\u00e1 319.000 \u0111\u1ed3ng, m\u1ee9c gi\u1ea3m gi\u00e1 12% so v\u1edbi gi\u00e1 ban \u0111\u1ea7u. \u0110\u1ec3 t\u00ecm ra gi\u00e1 g\u1ed1c, b\u1ea1n kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u1ea5y gi\u00e1 \u0111\u00e3 gi\u1ea3m chia cho t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m gi\u1ea3m, m\u00e0 ph\u1ea3i l\u1ea5y s\u1ed1 ti\u1ec1n \u0111\u00e3 thanh to\u00e1n chia cho ph\u1ea7n tr\u0103m c\u00f2n l\u1ea1i (100% &#8211; 12% = 88%).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470786 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-13.jpg\" alt=\"ham-tinh-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng l\u00e0: Gi\u00e1 g\u1ed1c = S\u1ed1 ti\u1ec1n \/ Ph\u1ea7n tr\u0103m c\u00f2n l\u1ea1i. V\u1edbi c\u00f4ng th\u1ee9c n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a s\u1ea3n ph\u1ea9m l\u00e0 bao nhi\u00eau, t\u1eeb \u0111\u00f3 \u0111\u00e1nh gi\u00e1 ch\u00ednh x\u00e1c m\u1ee9c chi\u1ebft kh\u1ea5u v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh mua s\u1eafm h\u1ee3p l\u00fd.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m t\u00ednh % trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n c\u1ea7n ph\u00e2n bi\u1ec7t r\u00f5 gi\u1eefa \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m v\u00e0 gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf. Trong Excel, khi b\u1ea1n nh\u1eadp m\u1ed9t con s\u1ed1 r\u1ed3i ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Percentage, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u00e2n gi\u00e1 tr\u1ecb \u0111\u00f3 v\u1edbi 100 v\u00e0 th\u00eam k\u00fd hi\u1ec7u %. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp 0,2 v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m, Excel s\u1ebd hi\u1ec3n th\u1ecb 20%, nh\u01b0ng n\u1ebfu b\u1ea1n nh\u1eadp 20 r\u1ed3i \u0111\u1ecbnh d\u1ea1ng l\u00e0 ph\u1ea7n tr\u0103m, k\u1ebft qu\u1ea3 s\u1ebd th\u00e0nh 2000%. Do \u0111\u00f3, h\u00e3y lu\u00f4n nh\u1eadp \u0111\u00fang gi\u00e1 tr\u1ecb tr\u01b0\u1edbc khi chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m \u0111\u1ec3 tr\u00e1nh hi\u1ec3u nh\u1ea7m k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-tinh-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-470787 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-14.jpg\" alt=\"ham-tinh-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1ee9 hai, h\u00e3y c\u1ea9n th\u1eadn khi s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 chia cho m\u1eabu s\u1ed1. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, n\u1ebfu m\u1eabu s\u1ed1 l\u00e0 0 ho\u1eb7c \u00f4 \u0111\u00f3 tr\u1ed1ng, Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #DIV\/0!. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m IF \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n ph\u00e9p chia.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd n\u1eefa l\u00e0 khi sao ch\u00e9p c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m trong c\u00e1c \u00f4 li\u00ean ti\u1ebfp, h\u00e3y s\u1eed d\u1ee5ng \u0111\u00fang lo\u1ea1i tham chi\u1ebfu. N\u1ebfu b\u1ea1n c\u1ea7n gi\u1eef nguy\u00ean m\u1ed9t gi\u00e1 tr\u1ecb m\u1eabu s\u1ed1 ho\u1eb7c t\u1ed5ng c\u1ed1 \u0111\u1ecbnh, h\u00e3y d\u00f9ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i (v\u00ed d\u1ee5: $B$2) \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 kh\u00f4ng b\u1ecb thay \u0111\u1ed5i sai l\u1ec7ch khi k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng kh\u00e1c.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00f3m l\u1ea1i,<\/span><b> h\u00e0m t\u00ednh % trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u00f4ng c\u1ee5 thi\u1ebft y\u1ebfu gi\u00fap b\u1ea1n ph\u00e2n t\u00edch, so s\u00e1nh v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 tr\u1ef1c quan. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd th\u00f4ng tin. D\u00f9 b\u1ea1n \u0111ang theo d\u00f5i ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c, t\u00ednh chi\u1ebft kh\u1ea5u, hay ph\u00e2n t\u00edch s\u1ef1 thay \u0111\u1ed5i gi\u1eefa c\u00e1c giai \u0111o\u1ea1n, vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u00fang h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m s\u1ebd mang l\u1ea1i k\u1ebft qu\u1ea3 r\u00f5 r\u00e0ng, ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n trong m\u1ecdi b\u00e1o c\u00e1o.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/chuyen-tu-excel-sang-pdf\/\"><strong>3 c\u00e1ch chuy\u1ec3n t\u1eeb Excel sang PDF mi\u1ec5n ph\u00ed c\u1ef1c nhanh, c\u1ef1c chu\u1ea9n<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ai-tao-cong-thuc-excel\/\"><strong>Top 5+ c\u00f4ng c\u1ee5 AI t\u1ea1o c\u00f4ng th\u1ee9c Excel chu\u1ea9n nh\u1ea5t<\/strong><\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m t\u00ednh % trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong c\u00e1c ph\u00e9p t\u00ednh. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh ph\u1ea7n tr\u0103m trong Excel chu\u1ea9n nh\u1ea5t, \u0111i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":470773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-470768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"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>3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.\" \/>\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\/ham-tinh-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-06T04:44:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-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=\"Daisy Daisy\" \/>\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=\"Daisy Daisy\" \/>\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\/ham-tinh-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c\"},\"headline\":\"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\",\"datePublished\":\"2025-07-06T04:44:54+00:00\",\"dateModified\":\"2025-07-06T04:44:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\"},\"wordCount\":3366,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\",\"name\":\"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg\",\"datePublished\":\"2025-07-06T04:44:54+00:00\",\"dateModified\":\"2025-07-06T04:44:54+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-tinh-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\"}]},{\"@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\/a7254cd2473ea15c26ef1b1fcd58398c\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.","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\/ham-tinh-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-07-06T04:44:54+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\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\/ham-tinh-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c"},"headline":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","datePublished":"2025-07-06T04:44:54+00:00","dateModified":"2025-07-06T04:44:54+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/"},"wordCount":3366,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/","name":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg","datePublished":"2025-07-06T04:44:54+00:00","dateModified":"2025-07-06T04:44:54+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n chi ti\u1ebft 3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel chu\u1ea9n v\u00e0 r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n, \u0111i k\u00e8m v\u1edbi v\u00ed d\u1ee5 minh h\u1ecda r\u00f5 r\u00e0ng.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-tinh-trong-excel.jpg","width":1200,"height":628,"caption":"ham-tinh-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"}]},{"@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\/a7254cd2473ea15c26ef1b1fcd58398c","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/470768","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\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=470768"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/470768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/470773"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=470768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=470768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=470768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}