{"id":880,"date":"2023-08-26T11:27:36","date_gmt":"2023-08-26T04:27:36","guid":{"rendered":"https:\/\/trannghiait.com\/?p=880"},"modified":"2023-08-26T11:28:36","modified_gmt":"2023-08-26T04:28:36","slug":"huong-dan-su-dung-ham-round-trong-excel-cu-the-va-chi-tiet-cho-dan-van-phong","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-ham-round-trong-excel-cu-the-va-chi-tiet-cho-dan-van-phong\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel c\u1ee5 th\u1ec3 v\u00e0 chi ti\u1ebft cho d\u00e2n v\u0103n ph\u00f2ng"},"content":{"rendered":"\n<p>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3<\/p>\n\n\n\n<p>Trong Microsoft Excel, h\u00e0m ROUND l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 v\u1edbi \u0111\u1ed9 ch\u00ednh x\u00e1c nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c mu\u1ed1n gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ec3 l\u00e0m cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n d\u1ec5 \u0111\u1ecdc h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u chi ti\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND v\u00e0 cung c\u1ea5p m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROUND:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(number, num_digits)<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>number<\/code> l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/li>\n\n\n\n<li><code>num_digits<\/code> l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb sau khi l\u00e0m tr\u00f2n.<\/li>\n<\/ul>\n\n\n\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u0111\u1ec3 b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND:<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5 1: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/strong><\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 3.1415926535 v\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(3.1415926535, 2)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 3.14.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5 2: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn 0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/strong><\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 5.789 v\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 \u0111\u1ebfn 0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(5.789, 0)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 6.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5 3: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn -1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/strong><\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 12345 v\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 \u0111\u1ebfn -1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 th\u00e0nh h\u00e0ng ch\u1ee5c g\u1ea7n nh\u1ea5t. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(12345, -1)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 12340.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5 4: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u00e2m:<\/strong><\/p>\n\n\n\n<p>H\u00e0m ROUND c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 \u00e2m. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 -3.75 v\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(-3.75, 1)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 -3.8.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5 5: L\u00e0m tr\u00f2n v\u1edbi quy t\u1eafc l\u00e0m tr\u00f2n g\u1ea7n nh\u1ea5t:<\/strong><\/p>\n\n\n\n<p>H\u00e0m ROUND c\u0169ng tu\u00e2n theo quy t\u1eafc l\u00e0m tr\u00f2n g\u1ea7n nh\u1ea5t. Khi s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 n+1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean; n\u1ebfu nh\u1ecf h\u01a1n 5, gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 7.85 v\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n n\u00f3 \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUND(7.85, 1)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 7.9.<\/p>\n\n\n\n<p>Nh\u01b0 v\u1eady, qua c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda tr\u00ean, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3 trong Microsoft Excel. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 theo \u00fd mu\u1ed1n c\u1ee7a b\u1ea1n, t\u1eeb vi\u1ec7c t\u00ednh to\u00e1n t\u00e0i ch\u00ednh \u0111\u1ebfn vi\u1ec7c bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel: L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3 Trong Microsoft Excel, h\u00e0m <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-su-dung-ham-round-trong-excel-cu-the-va-chi-tiet-cho-dan-van-phong\/\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel c\u1ee5 th\u1ec3 v\u00e0 chi ti\u1ebft cho d\u00e2n v\u0103n ph\u00f2ng\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=880"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":881,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/880\/revisions\/881"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}