{"id":10435,"date":"2025-01-14T04:11:22","date_gmt":"2025-01-14T04:11:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int\/"},"modified":"2025-01-14T04:11:22","modified_gmt":"2025-01-14T04:11:22","slug":"cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int\/","title":{"rendered":"C\u00e1ch t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia v\u1edbi h\u00e0m QUOTIENT v\u00e0 h\u00e0m INT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta th\u01b0\u1eddng ngh\u0129 r\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong>h\u00e0m INT<\/strong><\/a> l\u00e0 h\u00e0m t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a 1 ph\u00e9p chia. Nh\u01b0ng th\u1ef1c s\u1ef1 th\u00ec\u00a0kh\u00f4ng ph\u1ea3i nh\u01b0 v\u1eady. H\u00e0m ch\u00ednh x\u00e1c nh\u1ea5t gi\u00fap t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia l\u00e0 h\u00e0m QUOTIENT.\u00a0B\u1ea1n c\u00f3 bi\u1ebft v\u1ec1 h\u00e0m QUOTIENT kh\u00f4ng? H\u00e0m INT th\u1ef1c s\u1ef1 c\u00f3 t\u00e1c d\u1ee5ng g\u00ec? H\u00e0m INT v\u00e0 QUOTIENT gi\u1ed1ng nhau, kh\u00e1c nhau \u1edf \u0111i\u1ec3m n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u v\u1ec1\u00a0c\u00e1ch t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia v\u1edbi h\u00e0m QUOTIENT v\u00e0 h\u00e0m INT.<\/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-6785e3e9370e6\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int.html#Tim_hieu_ve_ham_QUOTIENT\" title=\"T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m QUOTIENT\">T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m QUOTIENT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int.html#Tac_dung_that_su_cua_ham_INT\" title=\"T\u00e1c d\u1ee5ng th\u1eadt s\u1ef1 c\u1ee7a h\u00e0m INT\">T\u00e1c d\u1ee5ng th\u1eadt s\u1ef1 c\u1ee7a h\u00e0m INT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-phan-nguyen-cua-phep-chia-voi-ham-quotient-va-ham-int.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tim_hieu_ve_ham_QUOTIENT\"><\/span>T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m QUOTIENT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, h\u00e0m QUOTIENT m\u1edbi th\u1ef1c s\u1ef1 l\u00e0 h\u00e0m gi\u00fap\u00a0t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m QUOTIENT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=QUOTIENT(numerator, denominator)<\/p>\n<p>Trong \u0111\u00f3<\/p>\n<ul>\n<li><strong>numerator<\/strong>: S\u1ed1 b\u1ecb chia (t\u1eed s\u1ed1)<\/li>\n<li><strong>denominator<\/strong>: S\u1ed1 chia (m\u1eabu s\u1ed1)<\/li>\n<\/ul>\n<p>C\u1ea5u tr\u00fac h\u00e0m n\u00e0y\u00a0r\u1ea5t gi\u1ed1ng v\u1edbi h\u00e0m MOD ph\u1ea3i kh\u00f4ng?<\/p>\n<p style=\"padding-left: 30px\">=MOD(number, divisor)<\/p>\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 (t\u1ee9c s\u1ed1 b\u1ecb chia, t\u1eed s\u1ed1)<\/li>\n<li><strong>divisor<\/strong>: S\u1ed1 chia (m\u1eabu s\u1ed1)<\/li>\n<\/ul>\n<p>Ki\u1ec3m tra m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p th\u1ef1c hi\u1ec7n ph\u00e9p chia nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-168.gif\" title=\"ex101_92019-nho-168\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19786\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-quotient-va-mod.png\" width=\"559\" height=\"173\" title=\"ham-quotient-va-mod\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tac_dung_that_su_cua_ham_INT\"><\/span>T\u00e1c d\u1ee5ng th\u1eadt s\u1ef1 c\u1ee7a h\u00e0m INT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m INT(number) v\u1ec1 b\u1ea3n ch\u1ea5t kh\u00f4ng ph\u1ea3i l\u00e0 h\u00e0m ki\u1ec3m tra k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p chia. N\u00f3 l\u00e0 h\u00e0m gi\u00fap ch\u00fang ta <strong>l\u00e0m tr\u00f2n 1 s\u1ed1 xu\u1ed1ng ph\u1ea7n nguy\u00ean nh\u1ecf h\u01a1n<\/strong>. V\u1ec1 b\u1ea3n ch\u1ea5t th\u00ec\u00a0<strong>h\u00e0m INT\u00a0l\u00e0 1 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1<\/strong>, gi\u1ed1ng nh\u01b0 h\u00e0m ROUNDDOWN nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00e0m tr\u00f2n h\u01b0\u1edbng v\u1ec1 s\u1ed1 0 m\u00e0 l\u00e0 l\u00e0m tr\u00f2n xu\u1ed1ng s\u1ed1 nh\u1ecf h\u01a1n.<\/p>\n<p>V\u1eady t\u1ea1i sao ch\u00fang ta l\u1ea1i hay hi\u1ec3u nh\u1ea7m r\u1eb1ng h\u00e0m INT l\u00e0 h\u00e0m x\u00e1c \u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia? H\u00e3y xem v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19790\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/phan-biet-int-va-quotient-02.png\" width=\"643\" height=\"172\" title=\"phan-biet-int-va-quotient-02\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean ch\u00fang ta th\u1ea5y h\u00e0m INT v\u00e0 h\u00e0m QUOTIENT ra k\u1ebft qu\u1ea3 gi\u1ed1ng nhau. Nh\u01b0ng c\u00e1ch vi\u1ebft h\u00e0m INT c\u00f3 \u0111i\u1ec3m c\u1ea7n ch\u00fa \u00fd \u0111\u00f3 l\u00e0 ch\u00fang ta ph\u1ea3i th\u1ef1c hi\u1ec7n ph\u00e9p chia ngay trong n\u1ed9i dung h\u00e0m. B\u1edfi tham s\u1ed1 c\u1ee7a h\u00e0m INT ch\u1ec9 c\u00f3 1 l\u00e0 Number, do \u0111\u00f3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh Number \u0111\u00f3 th\u00ec ph\u1ea3i vi\u1ebft to\u00e0n b\u1ed9 bi\u1ec3u th\u1ee9c ph\u00e9p chia.<\/p>\n<p>Nh\u01b0 v\u1eady h\u00e0m INT ra k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi QUOTIENT v\u1edbi k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng (s\u1ed1 &gt;0)<\/p>\n<p>N\u1ebfu nh\u01b0 ch\u00fang ta t\u00ednh to\u00e1n v\u1edbi ph\u00e9p chia c\u00f3 s\u1ed1 \u00e2m th\u00ec k\u1ebft qu\u1ea3 s\u1ebd ra sao?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19791\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/phan-biet-int-va-quotient-03.png\" width=\"642\" height=\"173\" title=\"phan-biet-int-va-quotient-03\"><\/p>\n<p>B\u00e2y gi\u1edd c\u00f3 s\u1ef1 kh\u00e1c nhau r\u1ed3i \u0111\u00f3. H\u00e0m QUOTIENT ra k\u1ebft qu\u1ea3 l\u1ea7n l\u01b0\u1ee3t l\u00e0 -1 \u1edf ph\u00e9p chia 8\/(-5), trong khi \u0111\u00f3 h\u00e0m INT l\u1ea1i ra k\u1ebft qu\u1ea3 l\u00e0 -2.<\/p>\n<p><em><strong>L\u01b0u \u00fd<\/strong><\/em>: C\u1ea7n ph\u1ea3i nh\u1eafc l\u1ea1i t\u1eeb \u201c<strong>Ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia<\/strong>\u201d \u0111\u1ec3 c\u00e1c b\u1ea1n hi\u1ec3u \u0111\u00fang v\u1ec1 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m QUOTIENT. V\u00ec l\u00e0 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia n\u00ean d\u1ea5u \u00e2m \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u00ean ngo\u00e0i ph\u00e9p chia, khi ra k\u1ebft qu\u1ea3 r\u1ed3i th\u00ec \u0111\u01b0a v\u1ec1 d\u1ea1ng s\u1ed1 \u00e2m.<\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh nh\u1ea9m: 8 chia 5 th\u00ec ph\u1ea7n nguy\u00ean l\u00e0 1. N\u1ebfu l\u00e0 s\u1ed1 \u00e2m th\u00ec k\u1ebft qu\u1ea3 l\u00e0 \u00e2m 1. Trong khi \u0111\u00f3 h\u00e0m INT ra k\u1ebft qu\u1ea3 \u00e2m 2.<\/p>\n<p>K\u1ebft qu\u1ea3 h\u00e0m INT c\u00f3 \u00fd ngh\u0129a: 8 chia \u00e2m 5 th\u00ec \u0111\u01b0\u1ee3c\u00a0k\u1ebft qu\u1ea3 l\u00e0 -1.6 v\u00e0 s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng s\u1ed1 nguy\u00ean nh\u1ecf h\u01a1n n\u00f3 l\u00e0 -2<\/p>\n<p>K\u1ebft qu\u1ea3 2 h\u00e0m \u0111\u1ec1u \u0111\u00fang nh\u01b0ng \u00fd ngh\u0129a l\u1ea1i kh\u00e1c nhau.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m QUOTIENT m\u1edbi ch\u00ednh x\u00e1c l\u00e0 h\u00e0m t\u00ednh ph\u1ea7n nguy\u00ean c\u1ee7a 1 ph\u00e9p chia.<\/p>\n<p>H\u00e0m INT l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng ph\u1ea7n nguy\u00ean nh\u1ecf h\u01a1n.<\/p>\n<p>H\u00e0m INT ra k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi QUOTIENT khi x\u00e9t ph\u00e9p chia s\u1ed1 d\u01b0\u01a1ng (s\u1ed1 l\u1edbn h\u01a1n 0) do \u0111\u00f3 c\u00f3 th\u1ec3 thay th\u1ebf cho nhau \u0111\u01b0\u1ee3c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/p>\n<p>H\u00e0m INT hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng h\u01a1n do t\u00ean h\u00e0m ng\u1eafn v\u00e0 d\u1ec5 vi\u1ebft h\u01a1n QUOTIENT v\u00e0 c\u00f3 th\u1ec3 d\u00f9ng thay cho QUOTIENT \u0111\u01b0\u1ee3c. Tuy nhi\u00ean v\u1edbi ph\u00e9p chia s\u1ed1 \u00e2m (\u00edt g\u1eb7p) th\u00ec b\u1eaft bu\u1ed9c ph\u1ea3i d\u00f9ng v\u1edbi h\u00e0m QUOTIENT m\u1edbi ra k\u1ebft qu\u1ea3 \u0111\u00fang.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ham-excel-huu-ich-nhat-kem-theo-mot-vi-du-minh-hoa.html\">Nh\u1eefng h\u00e0m Excel h\u1eefu \u00edch nh\u1ea5t k\u00e8m theo m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-hoc-va-cong-dung-cua-ham-hoc-trong-excel.html\">H\u00e0m s\u1ed1 h\u1ecdc v\u00e0 c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m s\u1ed1 h\u1ecdc trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2Kyz86j\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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\/2025\/01\/ex101_92019-nho-168.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10435","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\/10435","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=10435"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10435\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10436"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}