{"id":8613,"date":"2024-12-23T00:35:16","date_gmt":"2024-12-23T00:35:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-lam-tron-so-trong-excel-theo-y-muon\/"},"modified":"2024-12-23T00:35:16","modified_gmt":"2024-12-23T00:35:16","slug":"huong-dan-lam-tron-so-trong-excel-theo-y-muon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-lam-tron-so-trong-excel-theo-y-muon\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u00e0m tr\u00f2n s\u1ed1 trong Excel theo \u00fd mu\u1ed1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, vi\u1ec7c xu\u1ea5t hi\u1ec7n nh\u1eefng s\u1ed1 th\u1eadp ph\u00e2n d\u00e0i s\u1ebd l\u00e0m \u1ea3nh h\u01b0\u1edfng nh\u1ea5t \u0111\u1ecbnh t\u1edbi k\u1ebft c\u1ea5u v\u00e0 h\u00ecnh th\u1ee9c c\u1ee7a trang t\u00ednh. \u0110\u1ec3 x\u1eed l\u00fd \u0111i\u1ec1u n\u00e0y, l\u00e0m tr\u00f2n s\u1ed1 trong Excel l\u00e0 c\u00f4ng vi\u1ec7c kh\u00f4ng th\u1ec3 thi\u1ebfu. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u1ec3 hi\u1ec3u h\u01a1n:<\/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-6768b04350b01\" 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\/lam-tron-so-trong-excel-theo-y-muon.html#Lam_tron_so_trong_Excel_tuong_doi_bang_thay_doi_dinh_dang\" title=\"L\u00e0m tr\u00f2n s\u1ed1 trong Excel t\u01b0\u01a1ng \u0111\u1ed1i b\u1eb1ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng\">L\u00e0m tr\u00f2n s\u1ed1 trong Excel t\u01b0\u01a1ng \u0111\u1ed1i b\u1eb1ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng<\/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\/lam-tron-so-trong-excel-theo-y-muon.html#Lam_tron_so_trong_Excel_bang_cach_su_dung_ham\" title=\"L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\">L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-tron-so-trong-excel-theo-y-muon.html#Hang_nghin\" title=\"H\u00e0ng ngh\u00ecn\">H\u00e0ng ngh\u00ecn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/lam-tron-so-trong-excel-theo-y-muon.html#Hang_tram\" title=\"H\u00e0ng tr\u0103m\">H\u00e0ng tr\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/lam-tron-so-trong-excel-theo-y-muon.html#Phan_tram\" title=\"Ph\u1ea7n tr\u0103m\">Ph\u1ea7n tr\u0103m<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Lam_tron_so_trong_Excel_tuong_doi_bang_thay_doi_dinh_dang\"><\/span>L\u00e0m tr\u00f2n s\u1ed1 trong Excel t\u01b0\u01a1ng \u0111\u1ed1i b\u1eb1ng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng c\u1ea7n l\u00e0m tr\u00f2n t\u1edbi \u0111\u01a1n v\u1ecb ch\u00ednh x\u00e1c nh\u1ea5t, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27441\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lam-tron-so-trong-excel-1.png\" width=\"383\" height=\"92\" title=\"lam-tron-so-trong-excel-1\"><\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li>Trong th\u1ebb\u00a0<strong>Home<\/strong>, nh\u00f3m\u00a0<strong>Number<\/strong> ch\u1ecdn\u00a0<strong>Decrease Decimal<\/strong><\/li>\n<\/ol>\n<p>Ho\u1eb7c ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i th\u00e0nh c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nh\u01b0\u00a0<strong>Number, Currency, Percentage\u2026<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_tron_so_trong_Excel_bang_cach_su_dung_ham\"><\/span>L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi h\u00e0m ROUND b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 t\u1edbi s\u1ed1 ch\u1eef s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n. V\u00ed d\u1ee5 v\u1edbi s\u1ed1 <strong>900.8769,<\/strong> \u0111\u1ec3 l\u00e0m tr\u00f2n t\u1edbi \u0111\u01a1n v\u1ecb g\u1ea7n nh\u1ea5t ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\">H\u00e0m Int<\/a> \u2013 H\u00e0m l\u1ea5y ph\u1ea7n nguy\u00ean trong Excel<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Hang_nghin\"><\/span>H\u00e0ng ngh\u00ecn<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi h\u00e0ng ngh\u00ecn, ta nh\u1eadp\u00a0<em>=ROUND(900.8769, -3).<\/em> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 1000.<\/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-795.gif\" title=\"ex101_92019-nho-795\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Hang_tram\"><\/span>H\u00e0ng tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi h\u00e0ng tr\u0103m, ta nh\u1eadp\u00a0<em>=ROUND(900.8769, -2).<\/em> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 900.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Phan_tram\"><\/span>Ph\u1ea7n tr\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 l\u00e0m tr\u00f2n ph\u1ea7n tr\u0103m, ta nh\u1eadp\u00a0<em>=ROUND(900.8769, 2).<\/em> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 900.88.<\/p>\n<p>Nh\u01b0 v\u1eady, \u0111\u1ec3 l\u00e0m tr\u00f2n v\u1ec1 b\u00ean tr\u00e1i d\u1ea5u ng\u0103n c\u00e1ch th\u1eadp ph\u00e2n, ta s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 \u00e2m trong h\u00e0m ROUND v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 ROUNDUP, ROUNDDOWN&lt; INT, TRUNC\u2026 \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c l\u00e0m tr\u00f2n t\u00f9y nhu c\u1ea7u s\u1eed d\u1ee5ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27442\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lam-tron-so-trong-excel2.png\" width=\"429\" height=\"189\" title=\"lam-tron-so-trong-excel2\"><\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-ham-lam-tron-so-trong-excel-va-cac-nguyen-tac-lam-tron-so.html\"><strong>T\u00ecm hi\u1ec3u c\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u00e0 c\u00e1c nguy\u00ean t\u1eafc<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-ham-lam-tron-so-trong-tinh-don-gia-xuat-kho-tren-excel.html\">L\u00e0m tr\u00f2n s\u1ed1 trong t\u00ednh \u0111\u01a1n gi\u00e1 xu\u1ea5t kho<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-dong-lam-tron-mot-day-cac-o-trong-excel.html\"><strong>T\u1ef1 \u0111\u1ed9ng l\u00e0m tr\u00f2n m\u1ed9t d\u00e3y c\u00e1c \u00f4 trong Excel<\/strong><\/a><\/p>\n<p>\u00a0<\/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-795.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8613","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\/8613","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=8613"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8613\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8614"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}