{"id":5004,"date":"2024-12-08T22:07:02","date_gmt":"2024-12-08T22:07:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du\/"},"modified":"2024-12-08T22:07:02","modified_gmt":"2024-12-08T22:07:02","slug":"huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m chia trong Excel c\u00f3 v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"ph\u00e9p-chia-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du.html?phep-chia-trong-excel\">\n<p>Trong\u00a0Excel ch\u00fang ta th\u1ea5y c\u00f3 h\u00e0m t\u00ednh t\u1ed5ng l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">h\u00e0m SUM<\/a>, h\u00e0m t\u00ednh t\u00edch l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-product-de-nhan-trong-excel.html\">h\u00e0m PRODUCT<\/a>, v\u1eady c\u00f2n h\u00e0m chia l\u00e0 h\u00e0m n\u00e0o?\u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m chia trong Excel, <strong>ph\u00e9p chia trong excel.<\/strong><\/p>\n<\/blockquote>\n<p>Nh\u1eafc t\u1edbi <strong>ph\u00e9p chia trong excel,<\/strong> ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng:<\/p>\n<ul>\n<li>S\u1ed1 b\u1ecb chia (t\u1eed s\u1ed1)<\/li>\n<li>S\u1ed1 chia (m\u1eabu s\u1ed1)<\/li>\n<\/ul>\n<p>M\u1ee5c \u0111\u00edch c\u1ee7a <strong>ph\u00e9p chia trong excel<\/strong> l\u00e0 t\u00ecm:<\/p>\n<ul>\n<li>Ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia<\/li>\n<li>Ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p chia<\/li>\n<\/ul>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 c\u1ee7a <strong>ph\u00e9p chia trong excel<\/strong> l\u00e0 s\u1eed d\u1ee5ng bi\u1ec3u th\u1ee9c S\u1ed1 b\u1ecb chia \/ s\u1ed1 chia. D\u1ea5u \u201c\/\u201d ch\u00ednh l\u00e0 d\u1ea5u c\u1ee7a ph\u00e9p chia trong Excel. Ngo\u00e0i ra \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh t\u1eebng m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3 nh\u01b0 x\u00e1c \u0111\u1ecbnh ph\u1ea7n s\u1ed1 nguy\u00ean, ph\u1ea7n s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia, Excel cung c\u1ea5p cho ch\u00fang ta nh\u1eefng h\u00e0m c\u1ee5 th\u1ec3:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-675618853e209\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du.html#Cach_dung_ham_MOD_xac_dinh_phan_so_du_cua_phep_chia\" title=\"C\u00e1ch d\u00f9ng h\u00e0m MOD x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia\">C\u00e1ch d\u00f9ng h\u00e0m MOD x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-chia-trong-excel-co-vi-du.html#Cach_dung_ham_QUOTIENT_xac_dinh_phan_nguyen_cua_phep_chia\" title=\"C\u00e1ch d\u00f9ng h\u00e0m QUOTIENT x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia\">C\u00e1ch d\u00f9ng h\u00e0m QUOTIENT x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_MOD_xac_dinh_phan_so_du_cua_phep_chia\"><\/span>C\u00e1ch d\u00f9ng h\u00e0m MOD x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>H\u00e0m MOD\u00a0<\/strong>c\u00f3 t\u00e1c d\u1ee5ng l\u1ea5y ph\u1ea7n s\u1ed1 d\u01b0 c\u1ee7a 1 ph\u00e9p chia. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MOD nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=MOD(number, divisor)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Number: s\u1ed1 b\u1ecb chia (t\u1eed s\u1ed1)<\/li>\n<li>Divisor: s\u1ed1 chia (m\u1eabu s\u1ed1)<\/li>\n<\/ul>\n<p>V\u1ec1 nguy\u00ean t\u1eafc c\u1ee7a ph\u00e9p chia: m\u1eabu s\u1ed1 kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c b\u1eb1ng 0, do\u00a0\u0111\u00f3 Divisor ph\u1ea3i kh\u00e1c 0. N\u1ebfu b\u1eb1ng 0 s\u1ebd xu\u1ea5t hi\u1ec7n <a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-loi-div0-trong-excel-va-cach-khac-phuc.html\">l\u1ed7i #DIV\/0<\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-417.gif\" title=\"ex101_92019-nho-417\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25051\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-mod-tinh-phan-so-du-cua-phep-chia.png\" width=\"748\" height=\"196\" title=\"ham-mod-tinh-phan-so-du-cua-phep-chia\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean ta c\u00f3:<\/p>\n<ul>\n<li>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n s\u1ed1\u00a0d\u01b0 c\u1ee7a ph\u00e9p chia 7 chia 3, ta c\u00f3 MOD(7,3) cho k\u1ebft qu\u1ea3 = 1. N\u1ebfu\u00a0\u0111\u1eb7t s\u1ed1 7 v\u00e0o\u00a0\u00f4 A3, s\u1ed1 3 v\u00e0o\u00a0\u00f4 B3, ta c\u00f3 D3=MOD(A3,B3)=1<\/li>\n<li>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady n\u1ebfu\u00a0\u0111em 1548 chia cho 15, k\u1ebft qu\u1ea3 l\u00e0 d\u01b0 3<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra h\u00e0m MOD c\u00f2n c\u00f3 th\u1ec3\u00a0\u1ee9ng d\u1ee5ng trong vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian: t\u00ednh theo tu\u1ea7n, theo th\u00e1ng v\u00e0 l\u1ebb bao nhi\u00eau ng\u00e0y<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ung-dung-ham-int-va-mod-trong-cong-viec.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m INT v\u00e0 MOD trong c\u00f4ng vi\u1ec7c<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_QUOTIENT_xac_dinh_phan_nguyen_cua_phep_chia\"><\/span>C\u00e1ch d\u00f9ng h\u00e0m QUOTIENT x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia, ch\u00fang ta c\u00f3 2 c\u00e1ch: S\u1eed d\u1ee5ng h\u00e0m INT v\u00e0 <strong>h\u00e0m QUOTIENT<\/strong>. Nh\u01b0ng v\u1ec1 b\u1ea3n ch\u1ea5t th\u1ef1c s\u1ef1 th\u00ec h\u00e0m QUOTIENT m\u1edbi\u00a0\u0111\u00fang l\u00e0 h\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong>H\u00e0m INT<\/strong><\/a> c\u00f3 t\u00e1c d\u1ee5ng\u00a0<strong>l\u00e0m tr\u00f2n 1 s\u1ed1 xu\u1ed1ng ph\u1ea7n nguy\u00ean nh\u1ecf h\u01a1n<\/strong>. Do\u00a0\u0111\u00f3 t\u00ednh ch\u1ea5t, k\u1ebft qu\u1ea3 kh\u00e1 gi\u1ed1ng v\u1edbi vi\u1ec7c l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia. Nh\u01b0ng s\u1ebd c\u00f3 m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00e1ch l\u00e0m n\u00e0y ra k\u1ebft qu\u1ea3 kh\u00f4ng\u00a0\u0111\u00fang, v\u00ed d\u1ee5 v\u1edbi ph\u00e9p chia ra s\u1ed1\u00a0\u00e2m.<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m QUOTIENT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=QUOTIENT(numerator, denominator)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Numberator: s\u1ed1 b\u1ecb chia (t\u1eed s\u1ed1)<\/li>\n<li>Denominator: s\u1ed1 chia (m\u1eabu s\u1ed1)<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19786\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-quotient-va-mod.png\" width=\"559\" height=\"173\" title=\"ham-quotient-va-mod\"><\/p>\n<p>N\u1ebfu l\u1ea5y 8 chia 5, ta\u00a0\u0111\u01b0\u1ee3c 1 v\u00e0 d\u01b0 3 =&gt; H\u00e0m QUOTIENT ra k\u1ebft qu\u1ea3 l\u00e0 1, h\u00e0m MOD ra k\u1ebft qu\u1ea3 l\u00e0 3<\/p>\n<p>N\u1ebfu l\u1ea5y 92 chia 11, ta\u00a0\u0111\u01b0\u1ee3c 8 v\u00e0 d\u01b0 4 =&gt; H\u00e0m\u00a0QUOTIENT ra k\u1ebft qu\u1ea3 l\u00e0 8, h\u00e0m MOD ra k\u1ebft qu\u1ea3 l\u00e0\u00a04<\/p>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u1ea3u <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m li\u00ean quan t\u1edbi ph\u00e9p chia trong Excel.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-417.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5004","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5004","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=5004"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5004\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5005"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}