{"id":2600,"date":"2020-03-05T00:00:00","date_gmt":"2020-03-05T00:00:00","guid":{"rendered":"http:\/\/applestore.vn\/7-thu-thuat-lam-tron-so-trong-excel-de-lam-nhat-n60982\/"},"modified":"2021-08-14T15:44:53","modified_gmt":"2021-08-14T08:44:53","slug":"lam-tron-so-trong-excel-ham-round","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/lam-tron-so-trong-excel-ham-round\/","title":{"rendered":"8 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi h\u00e0m Round, Roundup"},"content":{"rendered":"

L\u00e0m tr\u00f2n s\u1ed1 trong Excel<\/strong> trong c\u00e1c b\u00e0i test lu\u00f4n l\u00e0 y\u00eau c\u1ea7u \u0111\u1ea7u ti\u00ean khi l\u00e0m b\u1edfi n\u00f3 s\u1ebd cho th\u1ea5y nh\u1eefng con s\u1ed1 c\u00f3 g\u1ecdn g\u00e0ng hay kh\u00f4ng khi hi\u1ec3n tr\u1ecb tr\u00ean b\u1ea3ng t\u00ednh v\u00e0 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn s\u1ed1 li\u1ec7u t\u00ednh to\u00e1n sau n\u00e0y.<\/p>\n

C\u00f3 nhi\u1ec1u c\u00e1ch th\u1ee9c \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0m tr\u00f2n s\u1ed1 trong Excel<\/strong>, sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t<\/p>\n

\"7<\/p>\n

Theo y\u00eau c\u1ea7u c\u1ee7a m\u1ed7i d\u1eef li\u1ec7u \u0111\u1ec1u s\u1ebd c\u00f3 nh\u1eefng c\u00e1ch l\u00e0m tr\u00f2n \u0111\u1ebfn nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c nhau v\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng c\u1ee5 H\u00e0m kh\u00e1c nhau s\u1ebd \u0111\u00e1p \u1ee9ng nh\u1eefng \u0111\u00f2i h\u1ecfi kh\u00e1c nhau n\u00e0y khi hi\u1ec3n th\u1ecb trong b\u1ea3ng Excel.<\/p>\n

C\u00e1c h\u00e0m hi\u1ec3n th\u1ecb l\u00e0m tr\u00f2n t\u1eeb round up; rounddown; mround; ceiling; floor \u0111\u1ec1u \u0111\u00e1p \u1ee9ng nh\u1eefng th\u00f4ng s\u1ed1 kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 tr\u00ean Excel b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n

1. L\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng H\u00e0m ROUND<\/strong><\/h2>\n

H\u00e0m l\u00e0m tr\u00f2n Round<\/strong> c\u00f3 t\u00e1c d\u1ee5ng \u0111\u1ea9y s\u1ed1 l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 x\u00e1c \u0111\u1ecbnh g\u1ea7n nh\u1ea5t ch\u1ec9 b\u1eb1ng 1 b\u01b0\u1edbc th\u1ed1ng k\u00ea c\u1ed9t \u0111\u01a1n gi\u1ea3n l\u00e0 c\u00f4ng th\u1ee9c:<\/p>\n

= ROUND(s\u1ed1 , s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n)<\/strong><\/div>\n

\"C\u00f4ng<\/p>\n

2. H\u00e0m l\u00e0m tr\u00f2n l\u00ean trong Excel b\u1eb1ng h\u00e0m ROUNDUP<\/strong><\/h2>\n

H\u00e0m l\u00e0m tr\u00f2n Roundup<\/strong> c\u00f3 t\u00e1c d\u1ee5ng s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n s\u1ebd l\u1edbn h\u01a1n s\u1ed1 ban \u0111\u1ea7u l\u1ea5y gi\u00e1 tr\u1ecb cao h\u01a1n, c\u00f2n cao bao nhi\u00eau s\u1ebd t\u00f9y thu\u1ed9c v\u00e0o b\u1ea1n d\u00f9ng h\u00e0m nh\u01b0 n\u00e0o.<\/p>\n

N\u1ebfu nh\u01b0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n cho d\u01b0\u01a1ng gi\u00e1 tr\u1ecb th\u00ec s\u1ed1 ph\u00eda sau s\u1ebd \u0111\u1ea9y s\u1ed1 l\u00e0m tr\u00f2n l\u00ean h\u00e0ng th\u1eadp ph\u00e2n, c\u00f2n \u00e2m gi\u00e1 tr\u1ecb s\u1ebd l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c ho\u1eb7c tr\u0103m v\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n

= Roundup(s\u1ed1, gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n)<\/strong><\/div>\n

\"L\u00e0m<\/p>\n

3. C\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n xu\u1ed1ng trong Excel b\u1eb1ng h\u00e0m ROUNDDOWN<\/strong><\/h2>\n

H\u00e0m l\u00e0m tr\u00f2n Roundup<\/strong> c\u00f3 t\u00e1c d\u1ee5ng cho nh\u1eefng k\u1ebft qu\u1ea3 c\u1ea7n l\u00e0m tr\u00f2n nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb g\u1ed1c \u0111\u1ed1i v\u1edbi nh\u1eefng y\u00eau c\u1ea7u ph\u00f9 h\u1ee3p. K\u1ebft qu\u1ea3 s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e1ch l\u00e0m h\u00e0m v\u1edbi c\u00f4ng th\u1ee9c<\/p>\n

= Rounddown(s\u1ed1, gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n)<\/strong><\/div>\n

Hai h\u00e0m Rounddown, Roundup<\/strong> qua c\u00e1ch th\u1ee9c cho th\u1ea5y ch\u00fang ng\u01b0\u1ee3c nhau v\u1ec1 c\u00f4ng th\u1ee9c m\u1ed9t h\u00e0m \u0111\u1ea9y l\u00e0m tr\u00f2n l\u00ean v\u00e0 m\u1ed9t h\u00e0m s\u1ebd \u0111\u1ea9y l\u00e0m tr\u00f2n xu\u1ed1ng.<\/p>\n

\"L\u00e0m<\/p>\n

4. H\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m MROUND<\/strong><\/h2>\n

H\u00e0m l\u00e0m tr\u00f2n Roundup c\u00f3 t\u00e1c d\u1ee5ng l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a th\u00f4ng s\u1ed1 d\u1eef li\u1ec7u kh\u00e1c trong b\u1ea3ng t\u00ednh. K\u00fd hi\u1ec7u b\u1eb1ng multiple ch\u00ednh l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n t\u00ednh b\u1eb1ng b\u1ed9i. K\u00fd hi\u1ec7u cho gi\u00e1 tr\u1ecb l\u00e0m tr\u00f2n l\u00e0 Number. C\u00f4ng th\u1ee9c t\u00ednh c\u0169ng r\u1ea5t \u0111\u01a1n gi\u1ea3n ch\u1ec9 b\u1eb1ng 1 b\u01b0\u1edbc :<\/p>\n

=Mround(gi\u00e1 tr\u1ecb l\u00e0m tr\u00f2n,s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n t\u00ednh b\u1eb1ng b\u1ed9i).<\/strong><\/div>\n

Bi\u1ec3u hi\u1ec7n n\u1ebfu b\u1ea1n l\u00e0m sai k\u1ebft qu\u1ea3 s\u1ebd cho gi\u00e1 tr\u1ecb #NUM l\u00e0 l\u1ed7i s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n s\u1ebd kh\u00f4ng hi\u1ec7n ra b\u1edfi ch\u00fang \u0111ang kh\u00e1c d\u1ea5u nhau, s\u1ed1 c\u1ea7n hi\u1ec3n th\u1ecb s\u1ebd \u0111\u00fang khi c\u00f9ng d\u1ea5u.<\/p>\n

K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb b\u1eb1ng 0,5 khi S\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n > 0,5 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean v\u00e0 s\u1ed1 l\u00e0m tr\u00f2n s\u1ebd nh\u1ecf khi s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n < 0,5<\/p>\n

Kh\u00e1c d\u1ea5u \u1edf \u0111\u00e2y khi s\u1ed1 Number v\u00e0 s\u1ed1 Multiple m\u1ed9t \u0111\u1ea5u \u00e2m, 1 d\u1ea5u d\u01b0\u01a1ng v\u00ed d\u1ee5 =MROUND(-77;98)=#Num\/Sai<\/p>\n

\"L\u00e0m<\/p>\n

5. H\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m CEILING; FLOOR trong Excel<\/strong><\/h2>\n

C\u0169ng c\u00f3 th\u1ec3 coi l\u00e0 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 l\u00e0 MROUND<\/strong> \u0111\u1ec1u nh\u1eadn gi\u00e1 tr\u1ecb b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a s\u1ed1 n\u00e0o \u0111\u00f3. Nh\u01b0ng h\u00e0m CEILING<\/strong> s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 c\u00e1ch xa 0, c\u00f2n h\u00e0m FLOOR l\u00e0m tr\u00f2n g\u1ea7n v\u1ec1 0 nh\u1ea5t. C\u00f4ng th\u1ee9c d\u1ec5 d\u00e0ng d\u1ee5ng nh\u01b0 sau:<\/p>\n

= CEILING(S\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n g\u1ea7n 0, significance)<\/strong><\/div>\n
\n
= FLOOR(s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n xa 0, significance)<\/strong><\/div>\n<\/div>\n

\"L\u00e0m<\/p>\n

6. C\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m EVEN, h\u00e0m ODD<\/strong><\/h2>\n

N\u1ebfu t\u00ednh \u0111\u1ebfn l\u00e0m tr\u00f2n ch\u1eb5n l\u1ebb th\u00ec kh\u00f4ng h\u00e0m n\u00e0o kh\u00e1c ch\u00ednh l\u00e0 EVEN, h\u00e0m ODD cho c\u00e1c k\u1ebft qu\u1ea3 s\u1ed1 nguy\u00ean c\u1ea7n l\u00e0m tr\u00f2n ch\u1eb5n ho\u1eb7c l\u1ebb nh\u1ea5t v\u00e0 c\u1ea3 hai \u0111\u1ec1u c\u00e1ch xa s\u1ed1 0.
\nTh\u01b0\u1eddng h\u00e0m Even s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u h\u01a1n h\u00e0m ODD. C\u00f4ng th\u1ee9c t\u00ednh l\u00e0:<\/p>\n

=\u00a0 EVEN(gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n) \/ = ODD(gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n).<\/strong><\/div>\n

\"L\u00e0m<\/p>\n

7. H\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m INT, TRUNC<\/strong><\/h2>\n

L\u00e0m INT<\/strong>, TRUNC<\/strong> bi\u1ec3u th\u1ecb c\u1eaft b\u1edbt s\u1ed1 cho s\u1ed1 r\u1ea5t ch\u1eb5n th\u00e0nh m\u1ed9t s\u1ed1 nguy\u00ean tri\u1ec7t \u0111\u1ec3, th\u01b0\u1eddng \u0111\u1ec3 ki\u1ec3m tra danh s\u00e1ch, th\u1ed1ng k\u00ea s\u1ebd d\u00f9ng nhi\u1ec1u h\u00e0m n\u00e0y.<\/span><\/p>\n

\"C\u00f4ng<\/p>\n

\u00a0C\u00f4ng th\u1ee9c nh\u01b0 sau<\/span><\/strong><\/p>\n

\u00a0INT = INT(s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n); TRUNC = TRUNC(s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n [s\u1ed1 nguy\u00ean]).<\/strong><\/div>\n

N\u1ebfu gi\u00e1 tr\u1ecb s\u1ed1 nguy\u00ean l\u1edbn h\u01a1n kh\u00f4ng th\u00ec s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n th\u01b0\u1eddng s\u1ebd d\u00e0i, n\u1ebfu hi\u1ec3n th\u1ecb =0 th\u00ec b\u1ea1n ch\u01b0a nh\u1eadp \u0111\u00fang d\u1eef li\u1ec7u; N\u1ebfu <0 th\u00ec s\u1ed1 l\u00e0m tr\u00f2n s\u1ebd d\u1ecbch sang tr\u00e1i 1 b\u1ed9i s\u1ed1 c\u1ee7a 10.<\/span><\/p>\n

\"C\u00f4ng<\/p>\n

8. L\u00e0m tr\u00f2n s\u1ed1 trong Excel kh\u00f4ng d\u00f9ng h\u00e0m<\/strong><\/h2>\n

N\u1ebfu b\u1ea1n th\u1ea5y vi\u1ec7c d\u00f9ng h\u00e0m qu\u00e1 ph\u1ee9c t\u1ea1p th\u00ec c\u00f3 m\u1ed9t c\u00e1ch r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng \u0111\u1ebfn h\u00e0m. \u0110\u00f3 l\u00e0 d\u00f9ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 d\u1ef1ng s\u1eb5n, thao t\u00e1c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

B\u01b0\u1edbc 2:<\/strong> Trong tab\u00a0Trang \u0111\u00e2\u0300u<\/b>, h\u00e3y b\u1ea5m\u00a0T\u0103ng vi\u0323 tri\u0301 th\u00e2\u0323p ph\u00e2n<\/b>\u00a0ho\u1eb7c\u00a0Gia\u0309m vi\u0323 tri\u0301 th\u00e2\u0323p ph\u00e2n<\/b>\u00a0\u0111\u1ec3 hi\u1ec7n th\u00eam ho\u1eb7c b\u1edbt \u0111i nh\u1eefng ch\u1eef s\u1ed1 sau d\u1ea5u th\u1eadp ph\u00e2n.<\/p>\n

\"C\u00e1ch<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel<\/strong> v\u1edbi c\u00e1c h\u00e0m Round, Roundup, Rounddown, MRound, Celling, Floor, Trunc,…<\/p>\n

Nh\u1eefng h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u00e0m tr\u00f2n s\u1ed1 theo \u00fd mu\u1ed1n nh\u01b0 l\u00e0m tr\u00f2n l\u00ean, l\u00e0m tr\u00f2n xu\u1ed1ng,…<\/p>\n","protected":false},"excerpt":{"rendered":"

L\u00e0m tr\u00f2n s\u1ed1 trong Excel trong c\u00e1c b\u00e0i test lu\u00f4n l\u00e0 y\u00eau c\u1ea7u \u0111\u1ea7u ti\u00ean khi l\u00e0m b\u1edfi n\u00f3 s\u1ebd cho th\u1ea5y nh\u1eefng con s\u1ed1 c\u00f3 g\u1ecdn g\u00e0ng hay kh\u00f4ng khi hi\u1ec3n tr\u1ecb tr\u00ean b\u1ea3ng t\u00ednh v\u00e0 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn s\u1ed1 li\u1ec7u t\u00ednh to\u00e1n sau n\u00e0y. C\u00f3 nhi\u1ec1u c\u00e1ch th\u1ee9c \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0m tr\u00f2n […]<\/p>\n","protected":false},"author":39,"featured_media":2601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[5,11],"tags":[],"class_list":["post-2600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cam-nang-cong-nghe","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/2600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=2600"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/2600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/2601"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=2600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=2600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=2600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}