{"id":100961,"date":"2024-10-09T16:20:44","date_gmt":"2024-10-09T09:20:44","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=100961"},"modified":"2024-10-10T09:41:33","modified_gmt":"2024-10-10T02:41:33","slug":"cach-lam-tron-so-trong-excel-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/","title":{"rendered":"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m ROUND, ROUNDUP"},"content":{"rendered":"\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 r\u1ea5t ph\u1ed5 bi\u1ebfn trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o b\u1ea1n c\u0169ng c\u1ea7n \u0111\u1ed9 ch\u00ednh x\u00e1c cao \u0111\u1ebfn t\u1eebng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. C\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng, d\u1ec5 \u0111\u1ecdc h\u01a1n ho\u1eb7c \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c y\u00eau c\u1ea7u t\u00ednh to\u00e1n c\u1ee5 th\u1ec3. Trong b\u00e0i vi\u1ebft n\u00e0y, h\u00e3y c\u00f9ng <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News <\/a>t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhau, bao g\u1ed3m n\u00fat l\u1ec7nh tr\u00ean thanh c\u00f4ng c\u1ee5, h\u1ed9p tho\u1ea1i Format Cells, v\u00e0 \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c h\u00e0m chuy\u00ean d\u1ee5ng nh\u01b0 ROUND, ROUNDUP, ROUNDDOWN, MROUND, v\u00e0 c\u00e1c h\u00e0m li\u00ean quan kh\u00e1c.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cac-cong-thuc-tinh-tong-trong-excel-don-gian\/\">T\u1ed5ng h\u1ee3p c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-vlookup-trong-excel-huong-dan-su-dung-va-mot-so-luu-y-quan-trong\/\">H\u00e0m VLOOKUP trong Excel \u2013 H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng v\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-tron-excel-don-gian-nhat\/\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a1b46a569da1\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a1b46a569da1\"  type=\"checkbox\" id=\"item-6a1b46a569da1\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#Lam_tron_so_trong_Excel_bang_nut_lenh_Increase_DecimalDecrease_Decimal\" title=\"L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng n\u00fat l\u1ec7nh Increase Decimal\/Decrease Decimal\">L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng n\u00fat l\u1ec7nh Increase Decimal\/Decrease Decimal<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#Su_dung_dinh_dang_so_trong_hop_thoai_Format_Cells_de_lam_tron_so_trong_Excel\" title=\"S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong h\u1ed9p tho\u1ea1i Format Cells \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel\">S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong h\u1ed9p tho\u1ea1i Format Cells \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#Cac_ham_lam_tron_so_trong_Excel_co_the_ban_quan_tam\" title=\"C\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel c\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m\">C\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel c\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#1_Lam_tron_so_trong_Excel_su_dung_ham_ROUND\" title=\"1. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUND\">1. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#2_Lam_tron_so_trong_Excel_su_dung_ham_ROUNDUP\" title=\"2. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDUP\">2. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#3_Lam_tron_so_trong_Excel_su_dung_ham_ROUNDDOWN\" title=\"3. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN\">3. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#4_Lam_tron_so_trong_Excel_su_dung_ham_MROUND\" title=\"4. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m MROUND\">4. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m MROUND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#5_Lam_tron_so_trong_Excel_su_dung_ham_ODD_va_EVEN\" title=\"5. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ODD v\u00e0 EVEN\">5. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ODD v\u00e0 EVEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#6_Lam_tron_so_trong_Excel_bang_ham_INT_va_TRUNC\" title=\"6. L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m INT v\u00e0 TRUNC\">6. L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m INT v\u00e0 TRUNC<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-lam-tron-so-trong-excel-don-gian-nhat\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lam_tron_so_trong_Excel_bang_nut_lenh_Increase_DecimalDecrease_Decimal\"><\/span><a><\/a>L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng n\u00fat l\u1ec7nh Increase Decimal\/Decrease Decimal<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>M\u1ed9t trong nh\u1eefng c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel m\u00e0 kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c l\u00e0 th\u00f4ng qua c\u00e1c n\u00fat l\u1ec7nh Increase Decimal v\u00e0 Decrease Decimal. \u0110\u00e2y l\u00e0 c\u00e1ch l\u00fd t\u01b0\u1edfng khi b\u1ea1n ch\u1ec9 mu\u1ed1n thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a s\u1ed1.<\/p>\n\n\n\n<p><strong>C\u00e1ch s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Ch\u1ecdn \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4 ch\u1ee9a s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li>Tr\u00ean thanh c\u00f4ng c\u1ee5 Ribbon, chuy\u1ec3n \u0111\u1ebfn th\u1ebb Home.<\/li>\n\n\n\n<li>Trong nh\u00f3m Number, b\u1ea1n s\u1ebd th\u1ea5y hai n\u00fat: Increase Decimal (bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean l\u00ean v\u1edbi d\u1ea5u ch\u1ea5m th\u1eadp ph\u00e2n) v\u00e0 Decrease Decimal (bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean xu\u1ed1ng v\u1edbi d\u1ea5u ch\u1ea5m th\u1eadp ph\u00e2n).<\/li>\n\n\n\n<li>Nh\u1ea5n v\u00e0o Increase Decimal \u0111\u1ec3 t\u0103ng s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb, ho\u1eb7c nh\u1ea5n v\u00e0o Decrease Decimal \u0111\u1ec3 gi\u1ea3m s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 s\u1ed1 li\u1ec7u l\u00e0 7,6531 trong \u00f4 I4:<\/li>\n\n\n\n<li>Nh\u1ea5n Decrease Decimal m\u1ed9t l\u1ea7n: s\u1ed1 li\u1ec7u s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 7,653.<\/li>\n\n\n\n<li>Nh\u1ea5n Increase Decimal m\u1ed9t l\u1ea7n: s\u1ed1 li\u1ec7u s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 7,65310.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-1024x640.jpg\" alt=\"\" class=\"wp-image-101030\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-11-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 d\u00e0ng nh\u1ea5t<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Increase Decimal v\u00e0 Decrease Decimal kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a s\u1ed1, m\u00e0 ch\u1ec9 \u0111i\u1ec1u ch\u1ec9nh c\u00e1ch hi\u1ec3n th\u1ecb. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n gi\u1ea3m s\u1ed1 th\u1eadp ph\u00e2n t\u1eeb 3.14159 xu\u1ed1ng 3.14, gi\u00e1 tr\u1ecb g\u1ed1c trong Excel v\u1eabn l\u00e0 3.14159.<\/li>\n\n\n\n<li>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n ki\u1ec3m so\u00e1t s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb m\u00e0 kh\u00f4ng c\u1ea7n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_dinh_dang_so_trong_hop_thoai_Format_Cells_de_lam_tron_so_trong_Excel\"><\/span>S\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong h\u1ed9p tho\u1ea1i Format Cells \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>M\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng h\u00e0m l\u00e0 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Format Cells. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y cho ph\u00e9p b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh c\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 v\u00e0 s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, \u0111\u1ed3ng th\u1eddi cung c\u1ea5p nhi\u1ec1u t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau.<\/p>\n\n\n\n<p><strong>C\u00e1ch s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells, ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + 1.<\/li>\n\n\n\n<li>Trong h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn tab Number.<\/li>\n\n\n\n<li>T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Number trong danh s\u00e1ch Category. Sau \u0111\u00f3, s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Decimal places \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n hi\u1ec3n th\u1ecb.<\/li>\n\n\n\n<li>Nh\u1ea5n OK \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 7.6531 v\u1edbi 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/li>\n\n\n\n<li>Ch\u1ecdn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb 7.6531.<\/li>\n\n\n\n<li>M\u1edf h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn m\u1ee5c Number v\u00e0 \u0111\u1eb7t Decimal places th\u00e0nh 2.<\/li>\n\n\n\n<li>K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb s\u1ebd l\u00e0 7.65.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-1024x640.jpg\" alt=\"Ch\u1ecdn ph\u1ea7n Number trong Format Cells\" class=\"wp-image-100973\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn ph\u1ea7n Number trong Format Cells<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-1024x640.jpg\" alt=\"\" class=\"wp-image-100974\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn l\u00e0m tr\u00f2n s\u1ed1 t\u1edbi ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n mong mu\u1ed1n<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-1024x640.jpg\" alt=\"K\u1ebft qu\u1ea3 sau khi l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng Format Cells\" class=\"wp-image-101031\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">K\u1ebft qu\u1ea3 sau khi l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng Format Cells<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y cho ph\u00e9p b\u1ea1n \u0111\u1ecbnh d\u1ea1ng c\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li>H\u1ed9p tho\u1ea1i Format Cells cung c\u1ea5p nhi\u1ec1u t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00e1c nhau, bao g\u1ed3m s\u1ed1 ti\u1ec1n t\u1ec7, ph\u1ea7n tr\u0103m, v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa, gi\u00fap b\u1ea1n t\u00f9y ch\u1ec9nh d\u1eef li\u1ec7u theo nhu c\u1ea7u.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cac_ham_lam_tron_so_trong_Excel_co_the_ban_quan_tam\"><\/span><a><\/a>C\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel c\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ngo\u00e0i c\u00e1c ph\u01b0\u01a1ng ph\u00e1p l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng v\u00e0 n\u00fat l\u1ec7nh, Excel c\u00f2n cung c\u1ea5p m\u1ed9t s\u1ed1 h\u00e0m m\u1ea1nh m\u1ebd cho vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1. C\u00e1c h\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb m\u00e0 c\u00f2n c\u00f3 th\u1ec3 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a s\u1ed1 trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 ph\u1ed5 bi\u1ebfn m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"1_Lam_tron_so_trong_Excel_su_dung_ham_ROUND\"><\/span><a><\/a>1. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m ROUND l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u1ea5t \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel. N\u00f3 l\u00e0m tr\u00f2n s\u1ed1 theo quy t\u1eafc l\u00e0m tr\u00f2n th\u00f4ng th\u01b0\u1eddng: n\u1ebfu ch\u1eef s\u1ed1 ti\u1ebfp theo l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean, ng\u01b0\u1ee3c l\u1ea1i s\u1ebd l\u00e0m tr\u00f2n xu\u1ed1ng.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>:<\/p>\n\n\n\n<p><strong>=ROUND(number, num_digits)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li><strong>num_digits<\/strong>: S\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i sau khi l\u00e0m tr\u00f2n.<\/li>\n<\/ul>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =ROUND(8,9456; 1) =&gt; K\u1ebft qu\u1ea3: 8,9<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-1024x640.jpg\" alt=\"L\u00e0m tr\u00f2n s\u1ed1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi h\u00e0m ROUND\" class=\"wp-image-100965\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u00e0m tr\u00f2n s\u1ed1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi h\u00e0m ROUND<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Khi num_digits = 0: s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/li>\n\n\n\n<li>Khi num_digits &lt; 0: s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n theo v\u1ecb tr\u00ed th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh.<\/li>\n\n\n\n<li>Khi num_digits &gt; 0: s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda b\u00ean tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n.<\/li>\n\n\n\n<li>N\u1ebfu ch\u1eef s\u1ed1 sau d\u1ea5u th\u1eadp ph\u00e2n nh\u1ecf h\u01a1n 5, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng.<\/li>\n\n\n\n<li>N\u1ebfu ch\u1eef s\u1ed1 sau d\u1ea5u th\u1eadp ph\u00e2n b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 5, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean.<\/li>\n\n\n\n<li>H\u00e0m ROUND s\u1ebd l\u00e0m tr\u00f2n theo quy t\u1eafc l\u00e0m tr\u00f2n th\u00f4ng th\u01b0\u1eddng: N\u1ebfu ch\u1eef s\u1ed1 sau c\u00f9ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean, ng\u01b0\u1ee3c l\u1ea1i s\u1ebd l\u00e0m tr\u00f2n xu\u1ed1ng.<\/li>\n\n\n\n<li>Th\u00edch h\u1ee3p khi b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi \u0111\u1ed9 ch\u00ednh x\u00e1c nh\u1ea5t \u0111\u1ecbnh m\u00e0 kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i gi\u00e1 tr\u1ecb qu\u00e1 nhi\u1ec1u.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"2_Lam_tron_so_trong_Excel_su_dung_ham_ROUNDUP\"><\/span><a><\/a>2. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m ROUNDUP lu\u00f4n l\u00e0m tr\u00f2n l\u00ean, b\u1ea5t k\u1ec3 ch\u1eef s\u1ed1 ti\u1ebfp theo l\u00e0 bao nhi\u00eau. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1ea3m b\u1ea3o r\u1eb1ng s\u1ed1 k\u1ebft qu\u1ea3 lu\u00f4n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 g\u1ed1c.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>:<\/p>\n\n\n\n<p><strong>=ROUNDUP(number, num_digits)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li><strong>num_digits<\/strong>: S\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ea7n gi\u1eef l\u1ea1i.<\/li>\n<\/ul>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =ROUNDUP(7.5623; 1) =&gt; K\u1ebft qu\u1ea3: 8<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-1024x640.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m ROUNDUP \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 theo mong mu\u1ed1n\" class=\"wp-image-100966\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng h\u00e0m ROUNDUP \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 theo mong mu\u1ed1n<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<p>H\u00e0m ROUNDUP lu\u00f4n l\u00e0m tr\u00f2n s\u1ed1 l\u00ean, b\u1ea5t k\u1ec3 gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c ch\u1eef s\u1ed1 \u0111\u1ee9ng sau. H\u00e0m n\u00e0y c\u00f3 kh\u1ea3 n\u0103ng l\u00e0m tr\u00f2n \u1edf c\u1ea3 hai ph\u00eda c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n.<\/p>\n\n\n\n<ul>\n<li><strong>N\u1ebfu num_digits = 0<\/strong>: H\u00e0m s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 l\u00ean t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/li>\n\n\n\n<li><strong>N\u1ebfu num_digits &gt; 0<\/strong>: H\u00e0m l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n theo v\u1ecb tr\u00ed b\u1ea1n ch\u1ec9 \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n n\u1ebfu num_digits = 1 th\u00ec l\u00e0m tr\u00f2n \u0111\u1ebfn m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, c\u00f2n num_digits = 2 th\u00ec l\u00e0m tr\u00f2n \u0111\u1ebfn hai ch\u1eef s\u1ed1.<\/li>\n\n\n\n<li><strong>N\u1ebfu num_digits &lt; 0<\/strong>: H\u00e0m s\u1ebd l\u00e0m tr\u00f2n v\u1ec1 b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n, v\u00ed d\u1ee5 num_digits = -1 s\u1ebd l\u00e0m tr\u00f2n t\u1edbi h\u00e0ng ch\u1ee5c, v\u00e0 num_digits = -2 l\u00e0m tr\u00f2n t\u1edbi h\u00e0ng tr\u0103m.<\/li>\n\n\n\n<li>Kh\u00e1c v\u1edbi h\u00e0m ROUND, h\u00e0m ROUNDUP lu\u00f4n l\u00e0m tr\u00f2n l\u00ean, b\u1ea5t k\u1ec3 ch\u1eef s\u1ed1 sau c\u00f9ng l\u00e0 bao nhi\u00eau.<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng h\u00e0m n\u00e0y khi b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o s\u1ed1 li\u1ec7u lu\u00f4n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 g\u1ed1c.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"3_Lam_tron_so_trong_Excel_su_dung_ham_ROUNDDOWN\"><\/span><a><\/a>3. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>:<\/p>\n\n\n\n<p><strong>=ROUNDDOWN(number, num_digits)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li><strong>num_digits<\/strong>: S\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ea7n gi\u1eef l\u1ea1i.<\/li>\n<\/ul>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =ROUNDDOWN(6.4318; 2) =&gt; K\u1ebft qu\u1ea3: 6.43<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-1024x640.jpg\" alt=\"C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\" class=\"wp-image-100967\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>H\u00e0m ROUNDDOWN s\u1ebd l\u00e0m tr\u00f2n c\u00e1c s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 9 theo chi\u1ec1u h\u01b0\u1edbng gi\u1ea3m. H\u00e0m n\u00e0y c\u00f3 kh\u1ea3 n\u0103ng l\u00e0m tr\u00f2n c\u1ea3 b\u00ean ph\u1ea3i v\u00e0 b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n.<\/li>\n\n\n\n<li>Khi num_digits \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u1eb1ng 0, Excel s\u1ebd chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u0111\u00f3 th\u00e0nh s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/li>\n\n\n\n<li>N\u1ebfu num_digits l\u1edbn h\u01a1n 0, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n \u0111\u1ebfn v\u1ecb tr\u00ed th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh; v\u00ed d\u1ee5, n\u1ebfu num_digits l\u00e0 1, h\u00e0m s\u1ebd gi\u1eef l\u1ea1i m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, c\u00f2n n\u1ebfu l\u00e0 2, h\u00e0m s\u1ebd gi\u1eef l\u1ea1i hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n\n\n\n<li>\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p num_digits nh\u1ecf h\u01a1n 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n. C\u1ee5 th\u1ec3, khi num_digits l\u00e0 -1, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c, v\u00e0 khi l\u00e0 -2, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng tr\u0103m.<\/li>\n\n\n\n<li>H\u00e0m ROUNDDOWN lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng, ngh\u0129a l\u00e0 s\u1ed1 k\u1ebft qu\u1ea3 lu\u00f4n nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 g\u1ed1c.<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n gi\u1ea3m gi\u00e1 tr\u1ecb v\u00e0 \u0111\u1ea3m b\u1ea3o n\u00f3 kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 s\u1ed1 g\u1ed1c.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"4_Lam_tron_so_trong_Excel_su_dung_ham_MROUND\"><\/span><a><\/a>4. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m MROUND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m MROUND gi\u00fap l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u00e3 cho l\u00ean b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t.H\u00e0m MROUND l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh. H\u00e0m n\u00e0y h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t b\u1ed9i s\u1ed1 c\u1ee5 th\u1ec3, ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ed9i s\u1ed1 c\u1ee7a 5, 10, ho\u1eb7c 100. V\u1edbi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c chia s\u1ebb d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c<\/strong>:<\/p>\n\n\n\n<p><strong>=MROUND(number, multiple)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li><strong>multiple<\/strong>: B\u1ed9i s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn.<\/li>\n<\/ul>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>:=MROUND(2.4159; 3) =&gt; K\u1ebft qu\u1ea3: 3<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-1024x640.jpg\" alt=\"B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 d\u1ec5 d\u00e0ng v\u1edbi h\u00e0m MROUND trong Excel\" class=\"wp-image-100968\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 d\u1ec5 d\u00e0ng v\u1edbi h\u00e0m MROUND trong Excel<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>H\u00e0m n\u00e0y l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a gi\u00e1 tr\u1ecb b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a 5, 10, ho\u1eb7c b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o kh\u00e1c.<\/li>\n\n\n\n<li>Th\u00edch h\u1ee3p trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u00e0m tr\u00f2n \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 ho\u1eb7c s\u1ed1 l\u01b0\u1ee3ng.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"5_Lam_tron_so_trong_Excel_su_dung_ham_ODD_va_EVEN\"><\/span><a><\/a>5. L\u00e0m tr\u00f2n s\u1ed1 trong Excel s\u1eed d\u1ee5ng h\u00e0m ODD v\u00e0 EVEN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ngo\u00e0i nh\u1eefng c\u00e1ch tr\u00ean c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ODD v\u00e0 EVEN \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel. H\u00e0m ODD l\u00e0m tr\u00f2n l\u00ean s\u1ed1 nguy\u00ean l\u1ebb g\u1ea7n nh\u1ea5t t\u00ednh t\u1eeb 0 (kh\u00f4ng). Khi s\u1eed d\u1ee5ng h\u00e0m ODD, gi\u00e1 tr\u1ecb lu\u00f4n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean t\u1eeb 0 (kh\u00f4ng), b\u1ea5t k\u1ec3 s\u1ed1 \u0111\u00f3 l\u00e0 d\u01b0\u01a1ng hay \u00e2m. N\u1ebfu s\u1ed1 \u0111\u00f3 l\u00e0 s\u1ed1 nguy\u00ean l\u1ebb ngay t\u1eeb \u0111\u1ea7u th\u00ec k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng t\u1ea1o ra b\u1ea5t k\u1ef3 s\u1ef1 kh\u00e1c bi\u1ec7t n\u00e0o v\u00ec s\u1ebd kh\u00f4ng l\u00e0m tr\u00f2n s\u1ed1.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c h\u00e0m ODD<\/strong>:<\/p>\n\n\n\n<p><strong>=ODD(number)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>number<\/strong>: S\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n v\u1ec1 s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t.<\/li>\n<\/ul>\n\n\n\n<p>**<strong>C\u00f4ng th\u1ee9c<\/strong>:<strong>=EVEN(number)<\/strong> <\/p>\n\n\n\n<p><strong>Trong \u0111\u00f3<\/strong>: numbe l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n v\u1ec1 s\u1ed1 ch\u1eb5n g\u1ea7n nh\u1ea5t.<\/p>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =ODD(7.6531) =&gt; K\u1ebft qu\u1ea3: 9<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-1024x640.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m ODD \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\" class=\"wp-image-100969\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng h\u00e0m ODD \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>: H\u00e0m ODD v\u00e0 EVEN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn s\u1ed1 l\u1ebb ho\u1eb7c ch\u1eb5n g\u1ea7n nh\u1ea5t. Th\u00edch h\u1ee3p khi b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n \u0111\u1ebfn m\u1ed9t con s\u1ed1 r\u00f5 r\u00e0ng \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u c\u1ee5 th\u1ec3.<\/p>\n\n\n\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m ODD, khi s\u1eed d\u1ee5ng h\u00e0m EVEN, c\u00e1c gi\u00e1 tr\u1ecb lu\u00f4n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean t\u1eeb 0 (kh\u00f4ng), b\u1ea5t k\u1ec3 s\u1ed1 \u0111\u00f3 l\u00e0 d\u01b0\u01a1ng hay \u00e2m. N\u1ebfu s\u1ed1 \u0111\u00f3 l\u00e0 s\u1ed1 ch\u1eb5n ngay t\u1eeb \u0111\u1ea7u th\u00ec k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng kh\u00e1c g\u00ec v\u00ec s\u1ebd kh\u00f4ng l\u00e0m tr\u00f2n s\u1ed1.<\/p>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =EVEN(6.9823) =&gt; K\u1ebft qu\u1ea3: 8<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-1024x640.jpg\" alt=\"D\u00f9ng h\u00e0m EVEN \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\" class=\"wp-image-100970\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">D\u00f9ng h\u00e0m EVEN \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"6_Lam_tron_so_trong_Excel_bang_ham_INT_va_TRUNC\"><\/span><a><\/a>6. L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m INT v\u00e0 TRUNC<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>INT v\u00e0 TRUNC c\u0169ng l\u00e0 l\u00e0m tr\u00f2n s\u1ed1 trong Excel m\u00e0n nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. C\u1ea3 hai h\u00e0m \u0111\u1ec1u cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng s\u1ed1 nguy\u00ean. \u0110\u1ec3 ph\u00e2n bi\u1ec7t v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng hai ch\u1ee9c n\u0103ng n\u00e0y, h\u00e3y xem ph\u1ea7n b\u00ean d\u01b0\u1edbi.<\/p>\n\n\n\n<p>**<strong>C\u00f4ng th\u1ee9c h\u00e0m INT<\/strong>:<strong>=INT(number)<\/strong><\/p>\n\n\n\n<p><strong>Trong \u0111\u00f3<\/strong>: number l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n xu\u1ed1ng.<\/p>\n\n\n\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch h\u00e0m INT ho\u1ea1t \u0111\u1ed9ng. \u0110\u1ec3 hi\u1ec3u s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y v\u00e0 h\u00e0m TRUNC khi l\u00e0m tr\u00f2n s\u1ed1 trong Excel, h\u00e3y xem ph\u1ea7n ti\u1ebfp theo.<\/p>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =INT(8.3456) =&gt; K\u1ebft qu\u1ea3: 8<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-1024x640.jpg\" alt=\"C\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m INT\" class=\"wp-image-100971\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m INT<\/figcaption><\/figure>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c h\u00e0m TRUNC<\/strong>:<\/p>\n\n\n\n<p><strong>=TRUNC(number, [num_digits])<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>&nbsp;&nbsp;number<\/strong>: S\u1ed1 c\u1ea7n c\u1eaft.<\/li>\n\n\n\n<li>\u00a0\u00a0<strong>num_digits (t\u00f9y ch\u1ecdn)<\/strong>: S\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i.<\/li>\n<\/ul>\n\n\n\n<p><strong>*V\u00ed d\u1ee5<\/strong>: =TRUNC(9.8745; [9]) =&gt; K\u1ebft qu\u1ea3: 9<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-1024x640.jpg\" alt=\"K\u1ebft qu\u1ea3 sau khi l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m TRUNC\" class=\"wp-image-100972\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/10\/lam-tron-so-trong-excel-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">K\u1ebft qu\u1ea3 sau khi l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m TRUNC<\/figcaption><\/figure>\n\n\n\n<p><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong>:<\/p>\n\n\n\n<ul>\n<li>H\u00e0m INT ch\u1ec9 l\u00e0m tr\u00f2n xu\u1ed1ng v\u1ec1 s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t, trong khi h\u00e0m TRUNC c\u1eaft b\u1edbt c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 kh\u00f4ng l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li>Ph\u00f9 h\u1ee3p khi b\u1ea1n ch\u1ec9 mu\u1ed1n lo\u1ea1i b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn gi\u00e1 tr\u1ecb s\u1ed1 g\u1ed1c.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><a><\/a>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc h\u01a1n m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 trong vi\u1ec7c x\u1eed l\u00fd, t\u00ednh to\u00e1n ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3. B\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn gi\u1eefa c\u00e1c ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng nh\u01b0 s\u1eed d\u1ee5ng n\u00fat l\u1ec7nh Increase\/Decrease Decimal, ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m m\u1ea1nh m\u1ebd nh\u01b0 ROUND, ROUNDUP, ROUNDDOWN, MROUND, v\u00e0 nhi\u1ec1u h\u00e0m kh\u00e1c \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u c\u1ee5 th\u1ec3. M\u1ed7i h\u00e0m \u0111\u1ec1u c\u00f3 \u01b0u \u0111i\u1ec3m ri\u00eang v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c t\u00ecnh hu\u1ed1ng kh\u00e1c nhau, gi\u00fap b\u1ea1n linh ho\u1ea1t h\u01a1n trong vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 li\u1ec7u trong Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 r\u1ea5t ph\u1ed5 bi\u1ebfn trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o b\u1ea1n c\u0169ng c\u1ea7n \u0111\u1ed9 ch\u00ednh x\u00e1c cao \u0111\u1ebfn t\u1eebng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. C\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ec3 k\u1ebft [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":100964,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/100961"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=100961"}],"version-history":[{"count":5,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/100961\/revisions"}],"predecessor-version":[{"id":101033,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/100961\/revisions\/101033"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/100964"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=100961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=100961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=100961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}