{"id":12241,"date":"2025-01-15T07:44:20","date_gmt":"2025-01-15T07:44:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-lam-tron-round-trong-excel\/"},"modified":"2025-01-15T07:44:20","modified_gmt":"2025-01-15T07:44:20","slug":"ham-lam-tron-round-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-lam-tron-round-trong-excel\/","title":{"rendered":"H\u00e0m l\u00e0m tr\u00f2n ROUND trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh Excel, nh\u1ea5t l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n trong To\u00e1n h\u1ecdc, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd g\u1eb7p nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i l\u00e0m tr\u00f2n s\u1ed1\u00a0\u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t \u0111\u1ec3 t\u1ea1o s\u1ef1 \u0111\u01a1n gi\u1ea3n khi t\u00ednh to\u00e1n h\u01a1n.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/lam-tron-so-trong-excel-theo-y-muon.html\"><strong>h\u00e0m ROUND<\/strong><\/a>, h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 th\u00f4ng d\u1ee5ng nh\u1ea5t trong Excel.<\/p>\n<p style=\"text-align: justify\"><strong>1\/ H\u00e0m ROUND()<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p: <strong>=ROUND(number,n)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>number<\/em>:<\/strong> S\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/li>\n<li><strong><em>n<\/em>:<\/strong> L\u00e0 \u0111\u1ed1i s\u1ed1, \u00a0<strong>n<\/strong> c\u00f3 th\u1ec3 \u00e2m ho\u1eb7c d\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">L\u01b0u \u00fd:<\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Khi n=0:<\/strong> Ta l\u00e0m tr\u00f2n t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\"><em><strong>V\u00ed d\u1ee5<\/strong><\/em>: L\u00e0m tr\u00f2n s\u1ed1 trong b\u1ea3ng sau v\u1edbi n=0, d\u00f9ng h\u00e0m ROUND.<\/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-372.gif\" title=\"ex101_92019-nho-372\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3674 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n0.png\" width=\"600\" height=\"417\" title=\"ham-round-n0\"><\/p>\n<p style=\"text-align: justify\">=&gt; K\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3675 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n0-1.png\" width=\"600\" height=\"418\" title=\"ham-round-n0-1\"><\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Khi n&lt;0:\u00a0<\/strong>\u00a0Ta l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m excel<\/a>\u00a0c\u1ef1c h\u1eefu \u00edch<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><em><strong>V\u00ed d\u1ee5<\/strong><\/em>: L\u00e0m tr\u00f2n s\u1ed1 trong b\u1ea3ng sau v\u1edbi n=-1, d\u00f9ng h\u00e0m ROUND ta \u0111\u01b0\u1ee3c:<br \/>\n<strong>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3678 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n1-2.png\" width=\"600\" height=\"416\" title=\"ham-round-n1-2\"><\/strong>=&gt; K\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3679 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n1-3.png\" width=\"600\" height=\"418\" title=\"ham-round-n1-3\"><\/p>\n<p style=\"text-align: justify\"><strong>\u2013 Khi n&gt;0:<\/strong> Ta l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda b\u00ean ph\u1ea3i d\u1ea5u th\u1eadp ph\u00e2n.<\/p>\n<p style=\"text-align: justify\"><em><strong>V\u00ed d\u1ee5<\/strong><\/em>: L\u00e0m tr\u00f2n s\u1ed1 trong b\u1ea3ng sau v\u1edbi n=1, d\u00f9ng h\u00e0m ROUND.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3676 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n1.png\" width=\"600\" height=\"417\" title=\"ham-round-n1\"><\/p>\n<p style=\"text-align: justify\">=&gt; K\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3677 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-round-n1-1.png\" width=\"600\" height=\"413\" title=\"ham-round-n1-1\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng<\/p>\n<p>Hi\u00ea\u0323n nay, <em>blog.excel.online<\/em> \u0111ang co\u0301 r\u00e2\u0301t nhi\u00ea\u0300u kho\u0301a ho\u0323c v\u00ea\u0300 Excel nh\u01b0: kho\u0301a ho\u0323c Excel c\u01a1 ba\u0309n, Excel n\u00e2ng cao, <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong Excel<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a ho\u0323c Excel k\u00ea\u0301 toa\u0301n<\/a>\u2026. v\u01a1\u0301i ca\u0301c chuy\u00ean gia\u00a0v\u00ea\u0300 Excel ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n t\u01b0\u0300ng chi ti\u00ea\u0301t v\u00ea\u0300 t\u01b0\u0300ng kho\u0301a ho\u0323c cho ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t.<\/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-372.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12242,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12241","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\/12241","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=12241"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12241\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12242"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}