<\/span><\/h2>\n\n\n\nH\u00e0m ROUND trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3. Nh\u1edd kh\u1ea3 n\u0103ng n\u00e0y, h\u00e0m ROUND gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t ch\u00ednh x\u00e1c s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb, qua \u0111\u00f3 l\u00e0m cho d\u1eef li\u1ec7u tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc h\u01a1n v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c y\u00eau c\u1ea7u t\u00ednh to\u00e1n c\u1ee5 th\u1ec3.<\/p>\n\n\n\n
V\u00ed d\u1ee5, khi b\u1ea1n c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb l\u00e0 3.14159<\/strong> v\u00e0 mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m ROUND v\u1edbi c\u00fa ph\u00e1p ch\u00ednh x\u00e1c s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3.14<\/strong>. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u r\u00f5 r\u00e0ng, ch\u1eb3ng h\u1ea1n nh\u01b0 khi l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh ho\u1eb7c th\u1ed1ng k\u00ea khoa h\u1ecdc.<\/p>\n\n\n\nNgo\u00e0i vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n, h\u00e0m ROUND c\u00f2n cho ph\u00e9p l\u00e0m tr\u00f2n \u0111\u1ebfn c\u00e1c s\u1ed1 nguy\u00ean ho\u1eb7c c\u00e1c b\u1ed9i s\u1ed1 c\u1ee5 th\u1ec3 t\u00f9y thu\u1ed9c v\u00e0o c\u00e1ch b\u1ea1n c\u00e0i \u0111\u1eb7t tham s\u1ed1. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 nguy\u00ean l\u00ean b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 10, 100 ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 1.000, \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c nhi\u1ec1u y\u00eau c\u1ea7u kh\u00e1c nhau trong c\u00f4ng vi\u1ec7c.<\/p>\n\n\n\n
Do \u0111\u00f3, h\u00e0m ROUND \u0111\u01b0\u1ee3c xem l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong Excel, \u0111\u1eb7c bi\u1ec7t v\u1edbi nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n ho\u1eb7c c\u00e1c b\u1ea3ng t\u00ednh y\u00eau c\u1ea7u t\u00ednh to\u00e1n chi ti\u1ebft. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND s\u1ebd gi\u00fap b\u1ea1n n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c v\u00e0 gi\u1ea3m thi\u1ec3u r\u1ee7i ro sai s\u00f3t khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn.<\/p>\n\n\n\n![\"H\u00e0m](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel3-1024x640.jpg\" "\\"\\"")
H\u00e0m ROUND trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ee5 th\u1ec3.<\/figcaption><\/figure>\n\n\n\n<\/span>\u1ee8ng D\u1ee5ng C\u1ee7a H\u00e0m ROUND Trong Excel<\/strong><\/span><\/h2>\n\n\n\nH\u00e0m ROUND \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i nh\u1edd t\u00ednh linh ho\u1ea1t v\u00e0 \u0111\u01a1n gi\u1ea3n c\u1ee7a n\u00f3. M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a h\u00e0m ROUND bao g\u1ed3m:<\/p>\n\n\n\n
1. L\u00e0m tr\u00f2n s\u1ed1 li\u1ec7u t\u00e0i ch\u00ednh:<\/strong> Trong c\u00e1c b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, vi\u1ec7c hi\u1ec3n th\u1ecb s\u1ed1 li\u1ec7u v\u1edbi \u0111\u1ed9 ch\u00ednh x\u00e1c v\u1eeba ph\u1ea3i gi\u00fap b\u00e1o c\u00e1o tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/p>\n\n\n\n2. T\u00ednh to\u00e1n ch\u00ednh x\u00e1c:<\/strong> Tr\u00e1nh sai s\u1ed1 do s\u1ed1 li\u1ec7u c\u00f3 qu\u00e1 nhi\u1ec1u ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c cao h\u01a1n trong c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p.<\/p>\n\n\n\n3. T\u0103ng hi\u1ec7u qu\u1ea3 tr\u1ef1c quan:<\/strong> L\u00e0m g\u1ecdn b\u1ea3ng s\u1ed1 li\u1ec7u \u0111\u1ec3 d\u1ec5 nh\u00ecn, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c bi\u1ec3u \u0111\u1ed3 ho\u1eb7c b\u00e1o c\u00e1o ph\u00e2n t\u00edch.<\/p>\n\n\n\n4. X\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn:<\/strong>\u00a0Khi l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3, vi\u1ec7c l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb gi\u00fap gi\u1ea3m t\u1ea3i cho c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u00e0 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd.<\/p>\n\n\n\n![\"Khi](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel4-1024x640.jpg\" "\\"\\"")
4. X\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn:<\/strong>\u00a0Khi l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3, vi\u1ec7c l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb gi\u00fap gi\u1ea3m t\u1ea3i cho c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u00e0 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd.<\/figcaption><\/figure>\n\n\n\n<\/span>C\u00fa Ph\u00e1p C\u1ee7a H\u00e0m ROUND Trong Excel<\/strong><\/span><\/h2>\n\n\n\n\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m. C\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n\n\n\n
=ROUND(number, num_digits)<\/code><\/pre>\n\n\n\n\u2022 number:<\/strong> (B\u1eaft bu\u1ed9c) L\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/p>\n\n\n\n\u2022 num_digits:<\/strong> (B\u1eaft bu\u1ed9c) S\u1ed1 ch\u1eef s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn.<\/p>\n\n\n\n\u00dd Ngh\u0129a C\u1ee7a num_digits:<\/strong><\/p>\n\n\n\n\u2022 N\u1ebfu num_digits > 0<\/strong>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n\u2022 N\u1ebfu num_digits = 0<\/strong>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/p>\n\n\n\n\u2022 N\u1ebfu num_digits < 0<\/strong>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a 10.<\/p>\n\n\n\nV\u00ed d\u1ee5:<\/strong><\/p>\n\n\n\n\u2022 =ROUND(3.14159, 2) tr\u1ea3 v\u1ec1 3.14<\/strong> (l\u00e0m tr\u00f2n \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n).<\/p>\n\n\n\n\u2022 =ROUND(123.456, 0) tr\u1ea3 v\u1ec1 123<\/strong> (l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t).<\/p>\n\n\n\n\u2022 =ROUND(987.65, -2)\u00a0tr\u1ea3 v\u1ec1\u00a01000<\/strong>\u00a0(l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng tr\u0103m).<\/p>\n\n\n\n![\"\u0110\u1ec3](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel5-1024x640.jpg\" "\\"\\"")
\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m.<\/figcaption><\/figure>\n\n\n\n<\/span>C\u00e1c L\u01b0u \u00dd C\u1ea7n Bi\u1ebft Khi D\u00f9ng H\u00e0m ROUND Trong Excel<\/strong><\/span><\/h2>\n\n\n\nH\u00e0m ROUND l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong Excel, nh\u01b0ng \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 v\u00e0 tr\u00e1nh nh\u1eefng sai s\u00f3t kh\u00f4ng \u0111\u00e1ng c\u00f3, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n
1. Kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb g\u1ed1c:<\/strong> Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m ROUND, Excel ch\u1ec9 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh ho\u1eb7c trong b\u00e1o c\u00e1o, nh\u01b0ng gi\u00e1 tr\u1ecb g\u1ed1c trong \u00f4 v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh li\u00ean quan \u0111\u1ebfn gi\u00e1 tr\u1ecb g\u1ed1c, v\u00ec k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng c\u00f3 th\u1ec3 kh\u00e1c bi\u1ec7t n\u1ebfu d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u hi\u1ec3n th\u1ecb.<\/p>\n\n\n\n2. Kh\u00f4ng \u00e1p d\u1ee5ng v\u1edbi chu\u1ed7i:<\/strong> H\u00e0m ROUND ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1. N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng \u00e1p d\u1ee5ng h\u00e0m n\u00e0y cho m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 (text), Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 s\u1ed1 tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m.<\/p>\n\n\n\n3. L\u1ef1a ch\u1ecdn h\u00e0m thay th\u1ebf ph\u00f9 h\u1ee3p:<\/strong> T\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m l\u00e0m tr\u00f2n kh\u00e1c nh\u01b0 ROUNDUP (l\u00e0m tr\u00f2n l\u00ean), ROUNDDOWN (l\u00e0m tr\u00f2n xu\u1ed1ng), ho\u1eb7c MROUND (l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t). M\u1ed7i h\u00e0m c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang, ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng, v\u00ec v\u1eady h\u00e3y c\u00e2n nh\u1eafc k\u1ef9 tr\u01b0\u1edbc khi ch\u1ecdn h\u00e0m ph\u00f9 h\u1ee3p nh\u1ea5t.<\/p>\n\n\n\nVi\u1ec7c hi\u1ec3u r\u00f5 nh\u1eefng l\u01b0u \u00fd n\u00e0y s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh c\u00e1c l\u1ed7i ph\u1ed5 bi\u1ebfn khi s\u1eed d\u1ee5ng h\u00e0m ROUND v\u00e0 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a t\u00ednh n\u0103ng l\u00e0m tr\u00f2n s\u1ed1 trong Excel.<\/p>\n\n\n\n![\"H\u00e0m](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel6-1024x640.jpg\" "\\"\\"")
H\u00e0m ROUND l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd trong Excel, nh\u01b0ng \u0111\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 v\u00e0 tr\u00e1nh nh\u1eefng sai s\u00f3t kh\u00f4ng \u0111\u00e1ng c\u00f3, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng<\/figcaption><\/figure>\n\n\n\n<\/span>V\u00ed D\u1ee5 Minh H\u1ecda C\u00e1ch \u00c1p D\u1ee5ng H\u00e0m ROUND Hi\u1ec7u Qu\u1ea3<\/strong><\/span><\/h2>\n\n\n\nV\u00ed D\u1ee5 1: L\u00e0m Tr\u00f2n S\u1ed1 \u0110\u01a1n Gi\u1ea3n<\/strong><\/p>\n\n\n\nCho m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u sau:<\/p>\n\n\n\nGi\u00e1 Tr\u1ecb<\/strong><\/td>C\u00f4ng Th\u1ee9c<\/strong><\/td>K\u1ebft Qu\u1ea3<\/strong><\/td><\/tr>| 12.567<\/td> | =ROUND(A2, 2)<\/td> | 12.57<\/td><\/tr> | | 345.678<\/td> | =ROUND(A3, 1)<\/td> | 345.7<\/td><\/tr> | | 789.123<\/td> | =ROUND(A4, 0)<\/td> | 789<\/td><\/tr><\/tbody><\/table>L\u00e0m Tr\u00f2n S\u1ed1 \u0110\u01a1n Gi\u1ea3n<\/figcaption><\/figure>\n\n\n\n V\u00ed D\u1ee5 2: L\u00e0m Tr\u00f2n \u0110\u1ebfn H\u00e0ng Ch\u1ee5c<\/strong><\/p>\n\n\n\nGi\u00e1 Tr\u1ecb<\/strong><\/td>C\u00f4ng Th\u1ee9c<\/strong><\/td>K\u1ebft Qu\u1ea3<\/strong><\/td><\/tr>| 123.45<\/td> | =ROUND(A2, -1)<\/td> | 120<\/td><\/tr> | | 678.91<\/td> | =ROUND(A3, -2)<\/td> | 700<\/td><\/tr><\/tbody><\/table>L\u00e0m Tr\u00f2n \u0110\u1ebfn H\u00e0ng Ch\u1ee5c<\/figcaption><\/figure>\n\n\n\n V\u00ed D\u1ee5 3: L\u00e0m Tr\u00f2n Trong B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh<\/strong><\/p>\n\n\n\nTrong tr\u01b0\u1eddng h\u1ee3p t\u1ed5ng doanh thu c\u1ee7a b\u1ea1n l\u00e0 1,234,567.89<\/strong>, s\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n nh\u01b0 sau:<\/p>\n\n\n\n\u2022 =ROUND(1234567.89, -3) tr\u1ea3 v\u1ec1 1,235,000<\/strong>, ph\u00f9 h\u1ee3p \u0111\u1ec3 hi\u1ec3n th\u1ecb trong b\u00e1o c\u00e1o.<\/p>\n\n\n\n<\/span>Nh\u1eefng H\u00e0m Excel S\u1eed D\u1ee5ng K\u1ebft H\u1ee3p V\u1edbi H\u00e0m ROUND Hi\u1ec7u Qu\u1ea3<\/strong><\/span><\/h2>\n\n\n\nKhi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u trong Excel, vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m ROUND v\u1edbi c\u00e1c h\u00e0m l\u00e0m tr\u00f2n kh\u00e1c kh\u00f4ng ch\u1ec9 t\u0103ng c\u01b0\u1eddng \u0111\u1ed9 ch\u00ednh x\u00e1c m\u00e0 c\u00f2n gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n\n\n\n 1. H\u00e0m ROUNDUP<\/strong><\/p>\n\n\n\nH\u00e0m n\u00e0y lu\u00f4n l\u00e0m tr\u00f2n l\u00ean. V\u00ed d\u1ee5:<\/p>\n\n\n\n \u2022 =ROUNDUP(12.34, 1) tr\u1ea3 v\u1ec1 12.4<\/strong>.<\/p>\n\n\n\n2. H\u00e0m ROUNDDOWN<\/strong><\/p>\n\n\n\nH\u00e0m n\u00e0y lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng. V\u00ed d\u1ee5:<\/p>\n\n\n\n \u2022 =ROUNDDOWN(12.34, 1) tr\u1ea3 v\u1ec1 12.3<\/strong>.<\/p>\n\n\n\n3. H\u00e0m MROUND<\/strong><\/p>\n\n\n\nH\u00e0m MROUND l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5:<\/p>\n\n\n\n \u2022 =MROUND(17, 5) tr\u1ea3 v\u1ec1 15<\/strong> (l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 5).<\/p>\n\n\n\n4. H\u00e0m INT<\/strong><\/p>\n\n\n\nH\u00e0m INT tr\u1ea3 v\u1ec1 ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 l\u00e0m tr\u00f2n xu\u1ed1ng:<\/p>\n\n\n\n \u2022 =INT(12.34) tr\u1ea3 v\u1ec1 12<\/strong>.<\/p>\n\n\n\n![\"Khi](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel7-1024x640.jpg\" "\\"\\"") Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u trong Excel, vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m ROUND v\u1edbi c\u00e1c h\u00e0m l\u00e0m tr\u00f2n kh\u00e1c kh\u00f4ng ch\u1ec9 t\u0103ng c\u01b0\u1eddng \u0111\u1ed9 ch\u00ednh x\u00e1c m\u00e0 c\u00f2n gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n<\/figcaption><\/figure>\n\n\n\n<\/span>T\u1ed5ng K\u1ebft<\/strong><\/span><\/h2>\n\n\n\nH\u00e0m ROUND l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 h\u1eefu \u00edch trong Excel, gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c. T\u1eeb vi\u1ec7c hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u t\u00e0i ch\u00ednh chuy\u00ean nghi\u1ec7p \u0111\u1ebfn x\u1eed l\u00fd c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p, h\u00e0m ROUND \u0111\u1ec1u c\u00f3 th\u1ec3 \u0111\u00e1p \u1ee9ng t\u1ed1t.<\/p>\n\n\n\n B\u00ean c\u1ea1nh \u0111\u00f3, vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m ROUND v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 ROUNDUP, ROUNDDOWN hay MROUND s\u1ebd gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel. H\u00e3y \u00e1p d\u1ee5ng ngay h\u00e0m ROUND \u0111\u1ec3 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean hi\u1ec7u qu\u1ea3 h\u01a1n!<\/p>\n","protected":false},"excerpt":{"rendered":" H\u00e0m ROUND trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch, th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 theo c\u00e1ch linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n","protected":false},"author":32,"featured_media":115243,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115225"}],"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\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=115225"}],"version-history":[{"count":3,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115225\/revisions"}],"predecessor-version":[{"id":115242,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115225\/revisions\/115242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/115243"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=115225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=115225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=115225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | | | |
| | | |
![\"H\u00e0m](\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/01\/ham-round-cach-su-dung-ham-round-trong-excel2-1024x640.jpg\" "\\"\\"")