{"id":6810,"date":"2024-12-21T16:15:11","date_gmt":"2024-12-21T16:15:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc\/"},"modified":"2024-12-21T16:15:11","modified_gmt":"2024-12-21T16:15:11","slug":"cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc\/","title":{"rendered":"C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel \u2013 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Th\u1eadt d\u1ec5 d\u00e0ng \u0111\u1ec3 theo d\u00f5i vi\u1ec7c kinh doanh n\u1ebfu b\u1ea1n bi\u1ebft t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u0103ng ho\u1eb7c gi\u1ea3m k\u1ebft qu\u1ea3 kinh doanh trong m\u1ed7i th\u00e1ng. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn ph\u01b0\u01a1ng ph\u00e1p t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m: c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u0103ng l\u00ean, ph\u1ea7n tr\u0103m t\u1ed5ng th\u1ec3\u2026<\/p>\n<p style=\"text-align: justify\">\nVi\u1ec7c t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong nhi\u1ec1u l\u0129nh v\u1ef1c cu\u1ed9c s\u1ed1ng: t\u00ednh ti\u1ec1n boa trong nh\u00e0 h\u00e0ng, chia hoa h\u1ed3ng cho nh\u00e0 b\u00e1n l\u1ebb, t\u00ednh thu\u1ebf thu nh\u1eadp ho\u1eb7c l\u00e3i su\u1ea5t. Gi\u1ea3 s\u1eed, b\u1ea1n may m\u1eafn nh\u1eadn \u0111\u01b0\u1ee3c m\u00e3 khuy\u1ebfn m\u1ea1i gi\u1ea3m 25% khi mua 1 TV plasma th\u1ebf h\u1ec7 m\u1edbi. Li\u1ec7u \u0111\u00e2y c\u00f3 ph\u1ea3i m\u1ed9t th\u1ecfa thu\u1eadn t\u1ed1t? V\u00e0 th\u1ef1c s\u1ef1 b\u1ea1n ph\u1ea3i b\u1ecf ra bao nhi\u00eau ti\u1ec1n?<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hoc-va-cong-dung-cua-ham-hoc-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m s\u1ed1 h\u1ecdc trong Excel<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">T\u1ef1 h\u1ecdc Excel\u00a0<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/14-%e2%97%8f-cach-dinh-dang-du-lieu-trong-bang-tinh-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u1ecbnh d\u1ea1ng % trong excel\u00a0<\/a><\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766e98e3acd4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Phan_tram_co_ban\" title=\"Ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n\">Ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Cong_thuc_ty_le_phan_tram_co_ban_cua_Excel\" title=\"C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel\">C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_1_Mot_o_tinh_tong_cu_the\" title=\"V\u00ed d\u1ee5 1. M\u1ed9t \u00f4 t\u00ednh t\u1ed5ng c\u1ee5 th\u1ec3\">V\u00ed d\u1ee5 1. M\u1ed9t \u00f4 t\u00ednh t\u1ed5ng c\u1ee5 th\u1ec3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_2_Tong_cua_tung_phan_trong_nhieu_hang\" title=\"V\u00ed d\u1ee5 2. T\u1ed5ng c\u1ee7a t\u1eebng ph\u1ea7n trong nhi\u1ec1u h\u00e0ng\">V\u00ed d\u1ee5 2. T\u1ed5ng c\u1ee7a t\u1eebng ph\u1ea7n trong nhi\u1ec1u h\u00e0ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Cach_tinh_ty_le_phan_tram_thay_doi_trong_Excel\" title=\"C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong Excel\">C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_1_Tinh_toan_phan_tram_thay_doi_giua_2_cot\" title=\"V\u00ed d\u1ee5 1. T\u00ednh to\u00e1n ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 c\u1ed9t:\">V\u00ed d\u1ee5 1. T\u00ednh to\u00e1n ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 c\u1ed9t:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_2_Tinh_toan_ty_le_phan_tram_thay_doi_giua_2_hang\" title=\"V\u00ed d\u1ee5 2. T\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 h\u00e0ng:\">V\u00ed d\u1ee5 2. T\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 h\u00e0ng:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Tinh_so_luong_va_tong_so_theo_ty_le_phan_tram\" title=\"T\u00ednh s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ed5ng s\u1ed1 theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:\">T\u00ednh s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ed5ng s\u1ed1 theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_1_Tinh_so_tien_bang_tong_so_va_ty_le_phan_tram\" title=\"V\u00ed d\u1ee5 1. T\u00ednh s\u1ed1 ti\u1ec1n b\u1eb1ng t\u1ed5ng s\u1ed1 v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m\">V\u00ed d\u1ee5 1. T\u00ednh s\u1ed1 ti\u1ec1n b\u1eb1ng t\u1ed5ng s\u1ed1 v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Vi_du_2_Tinh_tong_theo_so_luong_va_ty_le_phan_tram\" title=\"V\u00ed d\u1ee5 2. T\u00ednh t\u1ed5ng theo s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m\">V\u00ed d\u1ee5 2. T\u00ednh t\u1ed5ng theo s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-ty-le-phan-tram-trong-excel-vi-du-cong-thuc.html#Lam_the_nao_de_tang_giam_mot_so_bang_ty_le_phan_tram\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u0103ng \/ gi\u1ea3m m\u1ed9t s\u1ed1 b\u1eb1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u0103ng \/ gi\u1ea3m m\u1ed9t s\u1ed1 b\u1eb1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Phan_tram_co_ban\"><\/span>Ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Thu\u1eadt ng\u1eef \u201cph\u1ea7n tr\u0103m\u201d b\u1eaft ngu\u1ed3n t\u1eeb ch\u1eef Latinh, ngh\u0129a l\u00e0 \u201ctr\u00ean m\u1ed9t tr\u0103m\u201d. T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m l\u00e0 m\u1ed9t ph\u1ea7n nh\u1ecf c\u1ee7a 100, \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch chia t\u1eed s\u1ed1 cho m\u1eabu s\u1ed1 r\u1ed3i nh\u00e2n k\u1ebft qu\u1ea3 v\u1edbi 100.<\/p>\n<p style=\"text-align: justify\">\nC\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\n<strong>T\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m m\u1ed9t ph\u1ea7n\u00a0 (%) = (M\u1ed9t ph\u1ea7n \/ To\u00e0n b\u1ed9) * 100\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">\nV\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 20 tr\u00e1i t\u00e1o v\u00e0 cho b\u1ea1n b\u00e8 c\u1ee7a b\u1ea1n 5 tr\u00e1i, v\u1eady t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m s\u1ed1 t\u00e1o b\u1ea1n \u0111\u00e3 cho b\u1ea1n m\u00ecnh l\u00e0 bao nhi\u00eau? B\u1eb1ng t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n = 5\/20 * 100, c\u00e2u tr\u1ea3 l\u1eddi s\u1ebd l\u00e0 25%.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-270.gif\" title=\"vba101_92019-nho-270\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-611.gif\" title=\"ex101_92019-nho-611\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\n\u0110\u00e2y l\u00e0 c\u00e1ch thu\u1eddng \u0111u\u1ee3c s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ecdc v\u00e0 cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y. Vi\u1ec7c t\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m b\u1eb1ng Excel th\u1eadm ch\u00ed c\u00f2n d\u1ec5 d\u00e0ng h\u01a1n do Excel \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 thao t\u00e1c. Tuy nhi\u00ean,\u00a0kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c Excel n\u00e0o bao qu\u00e1t t\u1ea5t c\u1ea3 tru\u1eddng h\u1ee3p t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m. N\u1ebfu b\u1ea1n h\u1ecfi:\u00a0\u201cT\u00f4i s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m n\u00e0o \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u00f4i mu\u1ed1n?\u201d, th\u00ec b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi \u201cT\u1ea5t nhi\u00ean n\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ea1t \u0111\u01b0\u1ee3c\u201d.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Ll\u1edbp h\u1ecdc word excel \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_ty_le_phan_tram_co_ban_cua_Excel\"><\/span>C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel l\u00e0:<\/p>\n<p style=\"text-align: justify\">\n<strong>M\u1ed9t ph\u1ea7n \/ T\u1ed5ng s\u1ed1 = Ph\u1ea7n tr\u0103m<\/strong><\/p>\n<p style=\"text-align: justify\">\nN\u1ebfu b\u1ea1n so s\u00e1nh n\u00f3 v\u1edbi c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a Excel thi\u1ebfu ph\u1ea7n *100. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m ho\u00e0n ch\u1ec9nh khi b\u1ea1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho \u00f4 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">\nGi\u1ea3 s\u1eed b\u1ea1n c\u00f3 \u201cOrdered\u201d trong c\u1ed9t B v\u00e0 \u201cDelivered\u201d trong c\u1ed9t C. \u0110\u1ec3 t\u00ecm ra \u201cPercentage of Delivered items\u201d (ph\u1ea7n tr\u0103m c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c ph\u00e2n ph\u1ed1i), b\u1ea1n s\u1ebd l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">\n\u2022 Nh\u1eadp c\u00f4ng th\u1ee9c = C2 \/ B2 v\u00e0o \u00f4 D2, v\u00e0 sao ch\u00e9p n\u00f3 v\u00e0o nh\u1eefng h\u00e0ng b\u1ea1n c\u1ea7n.<br \/>\n\u2022 Nh\u1ea5p v\u00e0o n\u00fat <em><strong>Percent Style<\/strong><\/em> (tab <em><strong>Home &gt;<\/strong>\u00a0<\/em>group<em>\u00a0<strong>Number<\/strong><\/em>) \u0111\u1ec3 c\u00e1c ph\u00e2n s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m.<br \/>\n\u2022 N\u1ebfu c\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 t\u0103ng s\u1ed1 ch\u1eef s\u1ed1 ph\u1ea7n th\u1eadp ph\u00e2n.<\/p>\n<p style=\"text-align: justify\">\nC\u00e1c b\u01b0\u1edbc n\u00e0y c\u0169ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m n\u00e0o kh\u00e1c trong Excel.<\/p>\n<p style=\"text-align: justify\">\nTrong v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi, c\u1ed9t D hi\u1ec3n th\u1ecb t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u00e3 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng \u0111\u01a1n v\u1ecb (kh\u00f4ng c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n).<\/p>\n<figure style=\"width: 355px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-percentage-formula-1.png\" alt=\"C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel\" width=\"355\" height=\"264\"><figcaption class=\"wp-caption-text\"><em>C\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u01a1 b\u1ea3n c\u1ee7a Excel<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>T\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng s\u1ed1 trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 tr\u00ean l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 v\u1ec1 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng s\u1ed1. B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t v\u00e0i v\u00ed d\u1ee5 kh\u00e1c, n\u00f3 s\u1ebd gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ednh \u0111\u01b0\u1ee3c ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng s\u1ed1 trong Excel, d\u1ef1a tr\u00ean c\u00e1c d\u1eef li\u1ec7u kh\u00e1c nhau.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Mot_o_tinh_tong_cu_the\"><\/span>V\u00ed d\u1ee5 1. M\u1ed9t \u00f4 t\u00ednh t\u1ed5ng c\u1ee5 th\u1ec3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t t\u00ecnh hu\u1ed1ng kh\u00e1 ph\u1ed5 bi\u1ebfn l\u00e0 b\u1ea1n c\u00f3 \u00f4 t\u1ed5ng c\u1ed9ng \u1edf cu\u1ed1i b\u1ea3ng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m s\u1ebd t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00f4ng th\u1ee9c tr\u00ean, ch\u1ec9 kh\u00e1c \u00f4 tham chi\u1ebfu m\u1eabu s\u1ed1 l\u00e0 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i (v\u1edbi $). N\u00f3 s\u1ebd kh\u00f4ng thay \u0111\u1ed5i d\u00f9 c\u00f4ng th\u1ee9c \u0111u\u1ee3c \u0111\u1eb7t \u1edf b\u1ea5t k\u00ec v\u1ecb tr\u00ed n\u00e0o.<br \/>\nV\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb trong c\u1ed9t B v\u00e0 t\u1ed5ng c\u1ee7a ch\u00fang b\u1eb1ng \u00f4 B10, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m c\u1ee7a t\u1ed5ng s\u1ed1: = B2\/$B$10<br \/>\n\u00d4 B2 mang gi\u00e1 tr\u1ecb tu\u01a1ng \u0111\u1ed1i v\u00ec b\u1ea1n mu\u1ed1n n\u00f3 thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c c\u1ee7a c\u1ed9t B. $B$10 l\u00e0m tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ec3 m\u1eabu s\u1ed1 c\u1ed1 \u0111\u1ecbnh b\u1eb1ng B10 khi t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00f4ng th\u1ee9c xu\u1ed1ng h\u00e0ng 9.<br \/>\n<strong>Ch\u00fa \u00fd.\u00a0<\/strong>\u0110\u1ec3 m\u1eabu s\u1ed1 l\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i, b\u1ea1n c\u1ea7n nh\u1eadp $ th\u1ee7 c\u00f4ng, ho\u1eb7c nh\u1ea5p v\u00e0o \u00f4 tham chi\u1ebfu trong thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n F4.<br \/>\nH\u00ecnh minh ho\u1ea1 du\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 v\u1edbi \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m hi\u1ec3n th\u1ecb hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-percentage-total.png\" alt=\"Calculating percentage of a total in Excel\" title=\"calculate-percentage-total\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Tong_cua_tung_phan_trong_nhieu_hang\"><\/span>V\u00ed d\u1ee5 2. T\u1ed5ng c\u1ee7a t\u1eebng ph\u1ea7n trong nhi\u1ec1u h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u00ean, gi\u1ea3 s\u1eed c\u00f3 nhi\u1ec1u h\u00e0ng ch\u1ee9a c\u00f9ng m\u1ed9t s\u1ea3n ph\u1ea9m, b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ea3n ph\u1ea9m \u0111\u00f3 chi\u1ebfm bao nhi\u00eau ph\u1ea7n tr\u0103m tr\u00ean t\u1ed5ng \u0111\u01a1n h\u00e0ng.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <em><strong>SUMIF<\/strong><\/em> <\/a>\u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ea3n ph\u1ea9m \u0111\u00f3 tru\u1edbc, sau \u0111\u00f3 chia cho t\u1ed5ng t\u1ea5t c\u1ea3 s\u1ea3n ph\u1ea9m nh\u01b0 sau:<br \/>\n<em><strong>= SUMIF (range,criteria, sum_range) \/ total<\/strong><\/em><br \/>\nC\u1ed9t A ch\u1ee9a t\u00ean c\u00e1c lo\u1ea1i\u00a0s\u1ea3n ph\u1ea9m, c\u1ed9t B li\u1ec7t k\u00ea s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng, \u00f4 E1 l\u00e0 t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m m\u00e0 b\u1ea1n quan t\u00e2m, \u00f4 B10 l\u00e0 t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u00e1c s\u1ea3n ph\u1ea9m. D\u1ef1a v\u00e0o \u0111\u00f3, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd l\u00e0:<br \/>\n= SUMIF (A2: A9, E1, B2: B9) \/ $B$10<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-percentage-total.png\" alt=\"A formula to calculate a percentage of the total when items are in multiple rows\" title=\"excel-percentage-total\"><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp t\u00ean s\u1ea3n ph\u1ea9m v\u00e0o c\u00f4ng th\u1ee9c, nh\u01b0 sau:<br \/>\n<strong>= SUMIF (A2: A9, \u201ccherries\u201d, B2: B9) \/ $B$10<\/strong><br \/>\nN\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft nhi\u1ec1u s\u1ea3n ph\u1ea9m kh\u00e1c nhau chi\u1ebfm t\u1ef7 tr\u1ecdng bao nhi\u00eau trong t\u1ed5ng s\u1ed1, h\u00e3y t\u00ednh t\u1ed5ng ch\u00fang b\u1eb1ng nhi\u1ec1u h\u00e0m, sau \u0111\u00f3 chia cho t\u1ed5ng s\u1ed1. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c sau t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m qu\u1ea3 cherries v\u00e0 qu\u1ea3 apples (t\u00e1o):<br \/>\n<strong>= (SUMIF (A2: A9, \u201ccherries\u201d, B2: B9) + SUMIF (A2: A9, \u201capples\u201d, B2: B9)) \/ $B$10<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tinh_ty_le_phan_tram_thay_doi_trong_Excel\"><\/span>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel, c\u00f4ng th\u1ee9c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i th\u01b0\u1eddng s\u1eed d\u1ee5ng nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">\nC\u00f4ng th\u1ee9c t\u00ednh thay \u0111\u1ed5i t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m (ph\u1ea7n tr\u0103m t\u0103ng \/ gi\u1ea3m). \u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb A v\u00e0 B, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\">\n<strong>(B \u2013 A) \/ A = Ph\u1ea7n tr\u0103m thay \u0111\u1ed5i<\/strong><\/p>\n<p style=\"text-align: justify\">Khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y v\u1edbi d\u1eef li\u1ec7u th\u1ef1c, \u0111i\u1ec1u quan tr\u1ecdng l\u00e0 b\u1ea1n x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb n\u00e0o l\u00e0 A v\u00e0 gi\u00e1 tr\u1ecb n\u00e0o l\u00e0 B. V\u00ed d\u1ee5, ng\u00e0y h\u00f4m qua b\u1ea1n c\u00f3 80 qu\u1ea3 t\u00e1o v\u00e0 sau c\u00f9ng b\u1ea1n c\u00f3 100, c\u00f3 ngh\u0129a l\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n tr\u01b0\u1edbc 20 qu\u1ea3 t\u00e1o, t\u01b0\u01a1ng \u1ee9ng s\u1ed1 t\u00e1o t\u0103ng th\u00eam l\u00e0 25%. N\u1ebfu b\u1ea1n c\u00f3 100 tr\u00e1i t\u00e1o v\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u00f3 80, nh\u01b0 v\u1eady s\u1ed1 t\u00e1o c\u1ee7a b\u1ea1n \u0111\u00e3 gi\u1ea3m xu\u1ed1ng 20 tr\u00e1i, ngh\u0129a l\u00e0 s\u1ed1 t\u00e1o gi\u1ea3m 20% so v\u1edbi ban \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">\nDo \u0111\u00f3, c\u00f4ng th\u1ee9c Excel v\u1ec1 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i c\u00f3 d\u1ea1ng nh\u01b0 sau:<br \/>\n<strong>(Gi\u00e1 tr\u1ecb m\u1edbi \u2013 Gi\u00e1 tr\u1ecb c\u0169) \/ Gi\u00e1 tr\u1ecb c\u0169 = Ph\u1ea7n tr\u0103m Thay \u0111\u1ed5i<\/strong><br \/>\nV\u00e0 b\u00e2y gi\u1edd, h\u00e3y xem c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c thay \u0111\u1ed5i t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m (hay \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m t\u0103ng l\u00ean trong Excel) trong b\u1ea3ng t\u00ednh.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Tinh_toan_phan_tram_thay_doi_giua_2_cot\"><\/span>V\u00ed d\u1ee5 1. T\u00ednh to\u00e1n ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 c\u1ed9t:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 gi\u00e1 c\u1ea3 th\u00e1ng tr\u01b0\u1edbc trong c\u1ed9t B v\u00e0 gi\u00e1 th\u00e1ng n\u00e0y trong c\u1ed9t C, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 D2 \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i:<br \/>\n<strong>= (C2-B2) \/ B2<\/strong><br \/>\nC\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u0103ng\/gi\u1ea3m trong th\u00e1ng n\u00e0y (c\u1ed9t C) so v\u1edbi th\u00e1ng tr\u01b0\u1edbc (c\u1ed9t B).<br \/>\nSau khi sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c h\u00e0ng kh\u00e1c, nh\u1ea5p v\u00e0o n\u00fat <em><strong>Percent Style<\/strong><\/em> tr\u00ean thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 th\u1eadp ph\u00e2n d\u01b0\u1edbi d\u1ea1ng ph\u1ea7n tr\u0103m, sau \u0111\u00f3 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 trong h\u00ecnh du\u1edbi \u0111\u00e2y. Trong v\u00ed d\u1ee5 n\u00e0y, t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 cho th\u1ea5y t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u0103ng, \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo m\u00e0u kh\u00e1c (th\u01b0\u1eddng l\u00e0 m\u00e0u \u0111en), trong khi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u00e2m (ph\u1ea7n tr\u0103m gi\u1ea3m) \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng m\u00e0u \u0111\u1ecf.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/percentage-change-formula-excel.png\" alt=\"Excel formula to calculate percent change between 2 columns\" title=\"percentage-change-formula-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Tinh_toan_ty_le_phan_tram_thay_doi_giua_2_hang\"><\/span>V\u00ed d\u1ee5 2. T\u00ednh to\u00e1n t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i gi\u1eefa 2 h\u00e0ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t ch\u1ee9a s\u1ed1, v\u00ed d\u1ee5 c\u1ed9t C \u2013 li\u1ec7t k\u00ea doanh thu h\u00e0ng tu\u1ea7n ho\u1eb7c h\u00e0ng th\u00e1ng, b\u1ea1n c\u00f3 th\u1ec3 d\u1ef1a v\u00e0o \u0111\u00f3 \u0111\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<br \/>\n<strong>= (C3-C2) \/ C2<\/strong><br \/>\nTrong \u0111\u00f3 C2 v\u00e0 C3 l\u00e0 \u00f4 th\u1ee9 nh\u1ea5t v\u00e0 th\u1ee9 hai ch\u1ee9a d\u1eef li\u1ec7u.<br \/>\n<strong>L\u01b0u \u00fd:<\/strong> B\u1ea1n n\u00ean b\u1ecf qua h\u00e0ng \u0111\u1ea7u ti\u00ean c\u00f3 d\u1eef li\u1ec7u v\u00e0 \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m Excel c\u1ee7a b\u1ea1n v\u00e0o \u00f4 th\u1ee9 2, t\u1ee9c l\u00e0 D3 trong v\u00ed d\u1ee5 n\u00e0y.<br \/>\nSau khi \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m cho c\u1ed9t v\u1edbi c\u00f4ng th\u1ee9c thay \u0111\u1ed5i ph\u1ea7n tr\u0103m, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-percentage-change-excel.png\" alt=\"Excel formula to calculate percent change between rows\" title=\"calculate-percentage-change-excel\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i so v\u1edbi m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3, th\u00ec b\u1ea1n c\u1ea7n s\u1eeda tham chi\u1ebfu \u0111\u1ebfn \u00f4 \u0111\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i, v\u00ed d\u1ee5: $C$2.<br \/>\nV\u00ed d\u1ee5: D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m thay \u0111\u1ed5i nh\u1eb1m t\u1ef7 l\u1ec7 t\u0103ng \/ gi\u1ea3m ph\u1ea7n tr\u0103m m\u1ed7i th\u00e1ng so v\u1edbi th\u00e1ng 1 (C2):<br \/>\n= (C3- $C$2) \/ $C$2<br \/>\nKhi b\u1ea1n k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ec3 sao ch\u00e9p \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c, th\u00ec tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ($C$2) s\u1ebd gi\u1eef nguy\u00ean, trong khi tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (C3) s\u1ebd thay \u0111\u1ed5i th\u00e0nh C4, C5\u2026<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/total-percentage-change.png\" alt=\"Calculating a percentage change compared to January\" title=\"total-percentage-change\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tinh_so_luong_va_tong_so_theo_ty_le_phan_tram\"><\/span>T\u00ednh s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ed5ng s\u1ed1 theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, vi\u1ec7c t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong Excel r\u1ea5t d\u1ec5 d\u00e0ng, do \u0111\u00f3 vi\u1ec7c t\u00ednh c\u00e1c kho\u1ea3n ti\u1ec1n v\u00e0 t\u1ed5ng s\u1ed1 c\u0169ng d\u1ec5 nh\u01b0 v\u1eady n\u1ebfu b\u1ea1n bi\u1ebft t\u1edbi ph\u1ea7n tr\u0103m.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Tinh_so_tien_bang_tong_so_va_ty_le_phan_tram\"><\/span>V\u00ed d\u1ee5 1. T\u00ednh s\u1ed1 ti\u1ec1n b\u1eb1ng t\u1ed5ng s\u1ed1 v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang mua m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh x\u00e1ch tay m\u1edbi v\u1edbi gi\u00e1 $950 v\u00e0 thu th\u00eam 11% thu\u1ebf VAT cho l\u1ea7n mua h\u00e0ng n\u00e0y. C\u00e2u h\u1ecfi \u0111\u1eb7t ra l\u00e0: b\u1ea1n ph\u1ea3i tr\u1ea3 bao nhi\u00eau ti\u1ec1n tr\u00ean gi\u00e1 r\u00f2ng (gi\u00e1 g\u1ed1c c\u1ee7a s\u1ea3n ph\u1ea9m)? N\u00f3i c\u00e1ch kh\u00e1c, 11% c\u1ee7a $950 l\u00e0 bao nhi\u00eau?<br \/>\nV\u00e0 c\u00f4ng th\u1ee9c sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n:<br \/>\n<strong>T\u1ed5ng s\u1ed1 * Ph\u1ea7n tr\u0103m = L\u01b0\u1ee3ng ti\u1ec1n<\/strong><br \/>\nGi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb t\u1ed5ng s\u1ed1 n\u1eb1m trong \u00f4 A2 v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong \u00f4 B2, th\u00ec c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd hi\u1ec3u l\u00e0: = A2 * B2 (=$104.50).<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-amount-by-percentage.png\" alt=\"Calculating amount by total and percentage\" title=\"calculate-amount-by-percentage\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng, khi b\u1ea1n nh\u1eadp m\u1ed9t s\u1ed1 v\u00e0 theo sau c\u00f3 d\u1ea5u ph\u1ea7n tr\u0103m (%) trong Excel, th\u00ec s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 m\u1ed9t ph\u1ea7n tr\u0103m gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3. V\u00ed d\u1ee5, 11% th\u1ef1c s\u1ef1 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 l\u00e0 0.11 v\u00e0 Excel s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb c\u01a1 b\u1ea3n n\u00e0y trong t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 t\u00ednh to\u00e1n.<br \/>\nN\u00f3i c\u00e1ch kh\u00e1c, c\u00f4ng th\u1ee9c = A2 * 11% t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi = A2 * 0,11. \u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n \u0111\u01b0\u1ee3c t\u1ef1 do s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp s\u1ed1 th\u1eadp ph\u00e2n d\u01b0\u1edbi d\u1ea1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong c\u00f4ng th\u1ee9c n\u1ebfu n\u00f3 ho\u1ea1t \u0111\u1ed9ng tr\u00ean c\u00e1c b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Tinh_tong_theo_so_luong_va_ty_le_phan_tram\"><\/span>V\u00ed d\u1ee5 2. T\u00ednh t\u1ed5ng theo s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: B\u1ea1n c\u1ee7a b\u1ea1n ch\u00e0o b\u00e1n m\u00e1y t\u00ednh c\u0169 c\u1ee7a h\u1ecd v\u1edbi gi\u00e1 400 USD, \u0111\u00e3 gi\u1ea3m 30% so v\u1edbi gi\u00e1 g\u1ed1c. V\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a n\u00f3.<br \/>\nV\u00ec 30% l\u00e0 chi\u1ebft kh\u1ea5u, n\u00ean b\u1ea1n s\u1ebd kh\u1ea5u tr\u1eeb n\u00f3 kh\u1ecfi 100% tr\u01b0\u1edbc, \u0111\u1ec3 bi\u1ebft t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m b\u1ea1n th\u1ef1c s\u1ef1 ph\u1ea3i tr\u1ea3 (100% \u2013 30% = 70%). Sau \u0111\u00f3, b\u1ea1n c\u1ea7n c\u00f4ng th\u1ee9c t\u00ednh gi\u00e1 ban \u0111\u1ea7u, t\u1ee9c l\u00e0 t\u00ecm gi\u00e1 tr\u1ecb c\u00f3 70% tu\u01a1ng \u1ee9ng v\u1edbi $400.<br \/>\nC\u00f4ng th\u1ee9c t\u00ednh nh\u01b0 sau:<br \/>\n<strong>S\u1ed1 ti\u1ec1n \/ Ph\u1ea7n tr\u0103m = T\u1ed5ng s\u1ed1<\/strong><br \/>\n\u00c1p d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u th\u1ef1c, ta c\u00f3 m\u1ed9t trong nh\u1eefng c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:<br \/>\n= A2 \/ B2 ho\u1eb7c = A2 \/ 0.7 ho\u1eb7c = A2 \/ 70%<\/p>\n<p style=\"text-align: justify\"><strong><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/total-by-percentage.png\" alt=\"Calculating the total by amount and percentage\" title=\"total-by-percentage\"><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tang_giam_mot_so_bang_ty_le_phan_tram\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u0103ng \/ gi\u1ea3m m\u1ed9t s\u1ed1 b\u1eb1ng t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u00f9a l\u1ec5 thu\u1eddng cho th\u1ea5y s\u1ef1 thay \u0111\u1ed5i trong chi ti\u00eau so v\u1edbi ti\u00eau d\u00f9ng h\u00e0ng tu\u1ea7n. Do \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n xem x\u00e9t c\u00e1c l\u1ef1a ch\u1ecdn kh\u00e1c nhau \u0111\u1ec3 t\u00ecm ra m\u1ee9c ph\u1ee5 c\u1ea5p h\u00e0ng tu\u1ea7n t\u1ed1t nh\u1ea5t cho b\u1ea1n.<br \/>\n\u1ee8ng v\u1edbi m\u1ed9t l\u01b0\u1ee3ng t\u0103ng theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, ta c\u00f3 c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= S\u1ed1 ti\u1ec1n * (1 +%)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c = A1 * (1 + 20%) l\u00e0m t\u0103ng gi\u00e1 tr\u1ecb trong \u00f4 A1 th\u00eam 20%.<\/p>\n<p style=\"text-align: justify\">\u1ee8ng v\u1edbi m\u1ed9t l\u01b0\u1ee3ng gi\u1ea3m theo t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m, ta c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>= S\u1ed1 ti\u1ec1n * (1 -%)<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c = A1 * (1-20%) l\u00e0m gi\u1ea3m gi\u00e1 tr\u1ecb trong \u00f4 A1 \u0111i 20%.<br \/>\nTrong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang t\u00f4i, n\u1ebfu A2 l\u00e0 Current Spendings (chi ti\u00eau hi\u1ec7n t\u1ea1i) c\u1ee7a b\u1ea1n v\u00e0 B2 l\u00e0 Increase by (ph\u1ea7n tr\u0103m s\u1ed1 ti\u1ec1n b\u1ea1n mu\u1ed1n t\u0103ng) b\u1eb1ng, v\u00e0 d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n s\u1ebd nh\u1eadp v\u00e0o \u00f4 C2:<br \/>\nV\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m T\u0103ng: = A2 * (1 + B2)<br \/>\nV\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m Gi\u1ea3m: = A2 * (1-B2)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-increase-percentage.png\" alt=\"Excel formula to increase a number by percentage\" title=\"formula-increase-percentage\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: Ta\u0300i li\u00ea\u0323u <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\">ho\u0323c Excel VBA<\/a> 2020<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u0103ng \/ gi\u1ea3m to\u00e0n b\u1ed9 c\u1ed9t theo m\u1ed9t t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m:<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u0103ng ho\u1eb7c gi\u1ea3m b\u1edfi m\u1ed9t t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m nh\u1ea5t \u0111\u1ecbnh, v\u00e0 b\u1ea1n mu\u1ed1n c\u1eadp nh\u1eadt cho t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 trong c\u00f9ng m\u1ed9t c\u1ed9t thay v\u00ec th\u00eam m\u1ed9t c\u1ed9t m\u1edbi b\u1eb1ng c\u00f4ng th\u1ee9c:<br \/>\nThi d\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 b\u01b0\u1edbc nhanh \u0111\u1ec3 x\u1eed l\u00fd t\u00e1c v\u1ee5 n\u00e0y:<br \/>\n1. Nh\u1eadp t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 b\u1ea1n mu\u1ed1n t\u0103ng ho\u1eb7c gi\u1ea3m trong m\u1ed9t s\u1ed1 c\u1ed9t, nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 c\u1ed9t B.<br \/>\n2. Trong m\u1ed9t \u00f4 r\u1ed7ng, nh\u1eadp m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<br \/>\nV\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m t\u0103ng: = 1 + 20%<br \/>\nV\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m gi\u1ea3m: = 1-20%<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/increase-by-percentage.png\" alt=\"A formula to increase an entire column of numbers by a certain percentage\" title=\"increase-by-percentage\"><\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c thay th\u1ebf con s\u1ed1 20% trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean v\u1edbi t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m b\u1ea1n mu\u1ed1n.<br \/>\n3. Ch\u1ecdn \u00f4 \u0111ang ch\u1ee9a c\u00f4ng th\u1ee9c n\u00e0y (trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ta l\u00e0 \u00f4 C2) v\u00e0 sao ch\u00e9p n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5n <em><strong>Ctrl + C.<\/strong><\/em><br \/>\n4. Ch\u1ecdn d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng ch\u1ecdn v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o <em><strong>Paste Special\u2026<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/increase-by-percentage-paste-special.png\" alt=\"Use Paste Special to increase an entire column of numbers by percentage\" title=\"increase-by-percentage-paste-special\"><\/p>\n<p style=\"text-align: justify\">5. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i <em><strong>Paste Special<\/strong><\/em>, ch\u1ecdn <em><strong>Values<\/strong><\/em> trong khung <em><strong>Paste<\/strong><\/em>, <em><strong>Multiply<\/strong><\/em> trong khung <em><strong>Operation<\/strong><\/em>, sau \u0111\u00f3 nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-special-multiply.png\" alt=\"In the Paste Special dialog window, select Values under Paste, Multiply under Operation.\" title=\"paste-special-multiply\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 k\u1ebft qu\u1ea3 l\u00e0- t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t B \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u0103ng th\u00eam 20%.<\/p>\n<p style=\"text-align: justify\">V\u1edbi \u00fd t\u01b0\u1edfng \u0111\u00f3, b\u1ea1n c\u0169ng c\u00f3 c\u00f3 th\u1ec3 nh\u00e2n ho\u1eb7c chia c\u00e1c s\u1ed1 trong m\u1ed9t c\u1ed9t cho m\u1ed9t t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m nh\u1ea5t \u0111\u1ecbnh. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp ph\u1ea7n tr\u0103m b\u1ea1n mong mu\u1ed1n v\u00e0o \u00f4 tr\u1ed1ng v\u00e0 l\u00e0m theo c\u00e1c b\u01b0\u1edbc tr\u00ean.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a><\/p>\n<p><strong>Ngu\u1ed3n<\/strong>: <em>Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi H\u1ecdc Excel Online.<\/em><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-270.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6810"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6811"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}