{"id":1478,"date":"2024-12-02T05:14:01","date_gmt":"2024-12-02T05:14:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-phan-biet-ham-trunc-voi-ham-int-trong-excel\/"},"modified":"2024-12-02T05:14:01","modified_gmt":"2024-12-02T05:14:01","slug":"huong-dan-cach-phan-biet-ham-trunc-voi-ham-int-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-phan-biet-ham-trunc-voi-ham-int-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e2n bi\u1ec7t h\u00e0m TRUNC v\u1edbi h\u00e0m INT trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>\u0110\u1ec3 t\u00e1ch ph\u1ea7n nguy\u00ean c\u1ee7a 1 s\u1ed1, hay \u0111\u1ec3 t\u00ecm ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TRUNC ho\u1eb7c h\u00e0m INT \u0111\u1ec1u \u0111\u01b0\u1ee3c. V\u1eady s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa hai h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? C\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Onlin<\/strong><\/a>e t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/em><\/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-674d421917b39\" 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-phan-biet-ham-trunc-voi-ham-int-trong-excel.html#Huong_dan_cach_phan_biet_ham_TRUNC_voi_ham_INT_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e2n bi\u1ec7t h\u00e0m TRUNC v\u1edbi h\u00e0m INT trong Excel\">H\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e2n bi\u1ec7t h\u00e0m TRUNC v\u1edbi h\u00e0m INT 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-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-phan-biet-ham-trunc-voi-ham-int-trong-excel.html#1_Tac_dung\" title=\"1. T\u00e1c d\u1ee5ng\">1. T\u00e1c d\u1ee5ng<\/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\/huong-dan-cach-phan-biet-ham-trunc-voi-ham-int-trong-excel.html#2_Su_khac_nhau_giua_ham_TRUNC_va_ham_INT\" title=\"2. S\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m TRUNC v\u00e0 h\u00e0m INT\">2. S\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m TRUNC v\u00e0 h\u00e0m INT<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_phan_biet_ham_TRUNC_voi_ham_INT_trong_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn c\u00e1ch ph\u00e2n bi\u1ec7t h\u00e0m TRUNC v\u1edbi h\u00e0m INT trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Tac_dung\"><\/span>1. T\u00e1c d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\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 ch\u00ednh l\u00e0: L\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t h\u01b0\u1edbng t\u1edbi s\u1ed1 0. T\u1ee9c l\u00e0 n\u1ebfu s\u1ed1\u00a0\u0111\u00f3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng th\u00ec l\u00e0m tr\u00f2n xu\u1ed1ng, c\u00f2n n\u1ebfu l\u00e0 s\u1ed1\u00a0\u00e2m th\u00ec l\u00e0m tr\u00f2n l\u00ean.<\/p>\n<p>H\u00e0m TRUNC c\u00f3 t\u00e1c d\u1ee5ng ch\u00ednh l\u00e0: L\u00e0m tr\u00f2n 1 s\u1ed1 b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf ph\u1ea7n\u00a0ch\u1eef s\u1ed1\u00a0\u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n v\u1ec1 0<\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y c\u1ea3 2 h\u00e0m\u00a0\u0111\u1ec1u c\u00f3 t\u00e1c d\u1ee5ng gi\u1ed1ng nhau l\u00e0 l\u00e0m tr\u00f2n xu\u1ed1ng c\u1ee7a 1 s\u1ed1. Tuy nhi\u00ean\u00a0\u0111\u1ec3 x\u00e9t s\u1ef1 kh\u00e1c bi\u1ec7t, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u qua v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_khac_nhau_giua_ham_TRUNC_va_ham_INT\"><\/span>2. S\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m TRUNC v\u00e0 h\u00e0m INT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27431\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phan-biet-ham-trunc-int.png\" width=\"524\" height=\"156\" title=\"phan-biet-ham-trunc-int\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta x\u00e9t 1 s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 152.58921<\/p>\n<p>Khi d\u00f9ng h\u00e0m INT, ch\u00fang ta ch\u1ec9 ra\u00a0\u0111\u01b0\u1ee3c duy nh\u1ea5t 1 s\u1ed1 l\u00e0 s\u1ed1 152 (s\u1ed1 ch\u1ec9 c\u00f3 ph\u1ea7n s\u1ed1\u00a0nguy\u00ean).<\/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-107.gif\" title=\"ex101_92019-nho-107\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>a. Khi d\u00f9ng h\u00e0m TRUNC v\u1edbi num_digits = 0<\/strong>, ch\u00fang ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">C2 =TRUNC(A2, 0) ho\u1eb7c<\/p>\n<p style=\"padding-left: 30px\">C2 =TRUNC(A2)<\/p>\n<p>C\u00f3 th\u1ec3 kh\u00f4ng nh\u1eadp tham s\u1ed1 num_ditgits th\u00ec s\u1ebd\u00a0\u0111\u01b0\u1ee3c m\u1eb7c\u00a0\u0111\u1ecbnh tham s\u1ed1\u00a0\u0111\u00f3\u00a0 b\u1eb1ng 0<\/p>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 h\u00e0m TRUNC v\u1edbi num_digits = 0 s\u1ebd gi\u1ed1ng v\u1edbi h\u00e0m INT<\/p>\n<p><strong>b. Khi d\u00f9ng h\u00e0m TRUNC v\u1edbi num_digits kh\u00e1c 0<\/strong><\/p>\n<p>Ch\u00fang ta x\u00e9t ti\u1ebfp 2 tr\u01b0\u1eddng h\u1ee3p:<\/p>\n<ul>\n<li>H\u00e0m TRUNC v\u1edbi num_digits l\u00e0 s\u1ed1 d\u01b0\u01a1ng t\u1ea1i\u00a0\u00f4 C3, khi\u00a0\u0111\u00f3 ta th\u1ea5y h\u00e0m TRUNC ch\u1ec9 gi\u1eef l\u1ea1i 2 s\u1ed1 ph\u1ea7n th\u1eadp ph\u00e2n (t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi tham s\u1ed1\u00a0num_digits = 2), to\u00e0n b\u1ed9 ph\u1ea7n s\u1ed1 ph\u00eda sau 2 ch\u1eef s\u1ed1\u00a0th\u1eadp ph\u00e2n\u00a0\u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/li>\n<li>H\u00e0m TRUNC v\u1edbi num_digits l\u00e0 s\u1ed1\u00a0\u00e2m t\u1ea1i\u00a0\u00f4 C4, ta th\u1ea5y h\u00e0m TRUNC\u00a0\u0111\u00e3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 ph\u1ea7n ch\u1eef s\u1ed1 h\u00e0ng ch\u1ee5c, h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb, ph\u1ea7n th\u1eadp ph\u00e2n (b\u1ecf to\u00e0n b\u1ed9 ch\u1eef s\u1ed1 t\u1eeb h\u00e0ng ch\u1ee5c tr\u1edf v\u1ec1 sau) v\u1ec1 0, l\u00fac\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 ch\u1ec9 c\u00f2n l\u00e0 100<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady h\u00e0m TRUNC\u00a0\u0111a d\u1ea1ng h\u01a1n h\u00e0m INT r\u1ea5t nhi\u1ec1u trong vi\u1ec7c l\u00e0m tr\u00f2n xu\u1ed1ng 1 s\u1ed1, v\u00ec c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n t\u1edbi c\u1ea3 ph\u1ea7n th\u1eadp ph\u00e2n l\u1eabn ph\u1ea7n s\u1ed1 b\u00ean tr\u00e1i d\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n.<\/p>\n<p><strong>K\u1ebft qu\u1ea3 h\u00e0m TRUNC gi\u1ed1ng v\u1edbi h\u00e0m ROUNDDOWN:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27432\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phan-biet-ham-trunc-int-rounddown.png\" width=\"671\" height=\"157\" title=\"phan-biet-ham-trunc-int-rounddown\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft th\u00fa v\u1ecb v\u1ec1 c\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-ham-lam-tron-so-trong-excel-va-cac-nguyen-tac-lam-tron-so.html\">T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u00e0 c\u00e1c nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n s\u1ed1<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-quotient-tra-ve-ket-qua-cua-phep-chia-trong-excel.html\">H\u01b0\u1edbng d\u1eabn h\u00e0m QUOTIENT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p chia trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-lam-tron-round-trong-excel.html\">H\u00e0m l\u00e0m tr\u00f2n ROUND trong Excel<\/a><\/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-107.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1479,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1478","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\/1478","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=1478"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1478\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1479"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}