{"id":461180,"date":"2025-05-30T20:41:49","date_gmt":"2025-05-30T13:41:49","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=461180"},"modified":"2025-05-30T20:41:49","modified_gmt":"2025-05-30T13:41:49","slug":"ham-round-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/","title":{"rendered":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>H\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap ng\u01b0\u1eddi d\u00f9ng l\u00e0m tr\u00f2n s\u1ed1 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 linh ho\u1ea1t theo nhu c\u1ea7u. Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi x\u1eed l\u00fd c\u00e1c ph\u00e9p t\u00ednh t\u00e0i ch\u00ednh ho\u1eb7c th\u1ed1ng k\u00ea, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 l\u00e0 r\u1ea5t c\u1ea7n thi\u1ebft \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 hi\u1ec3u cho b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND nh\u1eb1m n\u00e2ng cao hi\u1ec7u qu\u1ea3 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u00e0m ROUND trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUND l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 x\u00e1c \u0111\u1ecbnh sau (ho\u1eb7c tr\u01b0\u1edbc) d\u1ea5u th\u1eadp ph\u00e2n. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u s\u1ed1 trong b\u1ea3ng t\u00ednh. Trong th\u1ef1c t\u1ebf, khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n, th\u1ed1ng k\u00ea hay c\u00e1c s\u1ed1 li\u1ec7u c\u00f3 nhi\u1ec1u ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, vi\u1ec7c gi\u1eef nguy\u00ean to\u00e0n b\u1ed9 con s\u1ed1 c\u00f3 th\u1ec3 g\u00e2y kh\u00f3 kh\u0103n trong vi\u1ec7c \u0111\u1ecdc hi\u1ec3u v\u00e0 tr\u00ecnh b\u00e0y k\u1ebft qu\u1ea3. H\u00e0m ROUND gi\u00fap gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y b\u1eb1ng c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ee9c \u0111\u1ed9 ch\u00ednh x\u00e1c mong mu\u1ed1n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-461187 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-1.jpg\" alt=\"ham-round-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed3ng th\u1eddi, h\u00e0m ROUND kh\u00f4ng ch\u1ec9 gi\u00fap l\u00e0m g\u1ecdn d\u1eef li\u1ec7u m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c trong c\u00e1c ph\u00e9p t\u00ednh ti\u1ebfp theo, \u0111\u1eb7c bi\u1ec7t khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p ho\u1eb7c s\u1eed d\u1ee5ng trong c\u00e1c b\u00e1o c\u00e1o. Ngo\u00e0i h\u00e0m ROUND, Excel c\u00f2n cung c\u1ea5p c\u00e1c bi\u1ebfn th\u1ec3 kh\u00e1c nh\u01b0 ROUNDUP (l\u00e0m tr\u00f2n l\u00ean) v\u00e0 ROUNDDOWN (l\u00e0m tr\u00f2n xu\u1ed1ng) \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00fa ph\u00e1p h\u00e0m ROUND trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROUND nh\u01b0 sau: <strong>=ROUND(Number, Num_digits)<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Number: L\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n. \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Num_digits: L\u00e0 s\u1ed1 ch\u1eef s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn. \u0110\u00e2y c\u0169ng l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-461188 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-2.jpg\" alt=\"ham-round-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00f9y v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a Num_digits, c\u00e1ch l\u00e0m tr\u00f2n s\u1ebd kh\u00e1c nhau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits l\u00e0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng, Excel s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits b\u1eb1ng 0, h\u00e0m ROUND s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits l\u00e0 m\u1ed9t s\u1ed1 \u00e2m, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n sang ph\u00eda tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n, t\u1ee9c l\u00e0 l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m, v.v.\u00a0<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>V\u00ed d\u1ee5 minh h\u1ecda cho h\u00e0m ROUND<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n h\u00e3y Ho\u00e0ng H\u00e0 Mobile c\u00f9ng xem qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3. Nh\u1eefng v\u00ed d\u1ee5 n\u00e0y s\u1ebd gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch h\u00e0m ROUND ho\u1ea1t \u0111\u1ed9ng trong t\u1eebng t\u00ecnh hu\u1ed1ng kh\u00e1c nhau, t\u1eeb l\u00e0m tr\u00f2n \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n cho \u0111\u1ebfn l\u00e0m tr\u00f2n v\u1ec1 c\u00e1c b\u1ed9i s\u1ed1 l\u1edbn h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch c\u00e1c y\u00eau c\u1ea7u l\u00e0m tr\u00f2n s\u1ed1 nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 8.15 \u0111\u1ebfn m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 8.149 \u0111\u1ebfn m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 -9.475 \u0111\u1ebfn hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 51.256 sang b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n, \u1edf v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 500.5 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 1000.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 -50.55 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 100.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 4.98 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 10.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-461189 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-3.jpg\" alt=\"ham-round-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi nh\u1eadp c\u00f4ng th\u1ee9c trong Excel, b\u1ea1n s\u1ebd vi\u1ebft nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(8.15, 1) \u2014 k\u1ebft qu\u1ea3 l\u00e0 8.2 v\u00ec ch\u1eef s\u1ed1 ti\u1ebfp theo (5) khi\u1ebfn s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(8.149, 1) \u2014 k\u1ebft qu\u1ea3 l\u00e0 8.1 v\u00ec ch\u1eef s\u1ed1 ti\u1ebfp theo (4) khi\u1ebfn s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(-9.475, 2) \u2014 k\u1ebft qu\u1ea3 l\u00e0 -9.48, h\u00e0m v\u1eabn l\u00e0m tr\u00f2n chu\u1ea9n theo quy t\u1eafc t\u01b0\u01a1ng t\u1ef1 v\u1edbi s\u1ed1 \u00e2m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(51.256, -1) \u2014 k\u1ebft qu\u1ea3 l\u00e0 50, s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n v\u1ec1 h\u00e0ng ch\u1ee5c g\u1ea7n nh\u1ea5t b\u00ean tr\u00e1i d\u1ea5u ph\u1ea9y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(500.5, -3) \u2014 k\u1ebft qu\u1ea3 l\u00e0 1000, l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 1000 g\u1ea7n nh\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(-50.55, -2) \u2014 k\u1ebft qu\u1ea3 l\u00e0 -100, l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 100 g\u1ea7n nh\u1ea5t theo chi\u1ec1u \u00e2m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=ROUND(4.98, -1) \u2014 k\u1ebft qu\u1ea3 l\u00e0 0, l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 10 g\u1ea7n nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>M\u1ed9t s\u1ed1 h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, ngo\u00e0i h\u00e0m ROUND gi\u00fap l\u00e0m tr\u00f2n s\u1ed1 theo quy t\u1eafc l\u00e0m tr\u00f2n th\u00f4ng th\u01b0\u1eddng, c\u00f2n c\u00f3 m\u1ed9t s\u1ed1 h\u00e0m li\u00ean quan kh\u00e1c h\u1ed7 tr\u1ee3 vi\u1ec7c l\u00e0m tr\u00f2n theo c\u00e1c c\u00e1ch kh\u00e1c nhau, ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3 trong x\u1eed l\u00fd d\u1eef li\u1ec7u. Vi\u1ec7c hi\u1ec3u v\u00e0 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n linh ho\u1ea1t h\u01a1n trong vi\u1ec7c qu\u1ea3n l\u00fd s\u1ed1 li\u1ec7u v\u00e0 n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m ROUNDUP<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDUP l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 ph\u1ed5 bi\u1ebfn trong Excel, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 l\u00ean, b\u1ea5t k\u1ec3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ph\u00eda sau nh\u01b0 th\u1ebf n\u00e0o. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb lu\u00f4n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n theo h\u01b0\u1edbng t\u0103ng l\u00ean, r\u1ea5t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n \u0111\u1ea3m b\u1ea3o s\u1ed1 li\u1ec7u kh\u00f4ng b\u1ecb gi\u1ea3m xu\u1ed1ng d\u01b0\u1edbi m\u1ed9t m\u1ee9c nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5 nh\u01b0 t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u1ea7n \u0111\u1eb7t h\u00e0ng ho\u1eb7c d\u1ef1 tr\u00f9 chi ph\u00ed.<\/span><\/p>\n<h4 style=\"text-align: justify;\"><b>C\u00fa ph\u00e1p h\u00e0m<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m: <strong>=ROUNDUP(Number, Num_digits)<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Num_digits l\u00e0 s\u1ed1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n t\u1edbi, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 nguy\u00ean d\u01b0\u01a1ng, \u00e2m ho\u1eb7c b\u1eb1ng 0.<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>C\u00e1ch s\u1eed d\u1ee5ng<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi <\/span><b>h\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c =ROUNDUP(Number, Num_digits) v\u00e0o \u00f4 c\u1ea7n t\u00ednh to\u00e1n. Gi\u00e1 tr\u1ecb Number c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 c\u1ed1 \u0111\u1ecbnh ho\u1eb7c tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n. T\u01b0\u01a1ng t\u1ef1, Num_digits c\u0169ng c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 c\u1ee5 th\u1ec3 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 kh\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits = 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5, 8.1424240 s\u1ebd tr\u1edf th\u00e0nh 9.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461190 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-4.jpg\" alt=\"ham-round-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits &gt; 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean t\u1edbi s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng. V\u00ed d\u1ee5, v\u1edbi Num_digits = 2, s\u1ed1 8.1424240 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n th\u00e0nh 8.15.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461191 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-5.jpg\" alt=\"ham-round-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu Num_digits &lt; 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n sang b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n. V\u00ed d\u1ee5, Num_digits = -1 s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 198.1424240 l\u00ean th\u00e0nh 200 (l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c),\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461192 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-6.jpg\" alt=\"ham-round-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m ROUNDDOWN<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDDOWN \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng, t\u1ee9c l\u00e0 lu\u00f4n l\u00e0m gi\u1ea3m gi\u00e1 tr\u1ecb s\u1ed1 v\u1ec1 ph\u00eda s\u1ed1 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 g\u1ed1c, b\u1ea5t k\u1ec3 ph\u1ea7n th\u1eadp ph\u00e2n sau \u0111\u00f3 nh\u01b0 th\u1ebf n\u00e0o. Kh\u00e1c v\u1edbi <\/span><b>h\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0m tr\u00f2n theo quy t\u1eafc th\u00f4ng th\u01b0\u1eddng (l\u00e0m tr\u00f2n l\u00ean ho\u1eb7c xu\u1ed1ng t\u00f9y thu\u1ed9c v\u00e0o ch\u1eef s\u1ed1 ti\u1ebfp theo), h\u00e0m ROUNDDOWN gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t s\u1ed1 li\u1ec7u theo h\u01b0\u1edbng gi\u1ea3m ho\u1eb7c c\u1ed1 \u0111\u1ecbnh, r\u1ea5t ph\u00f9 h\u1ee3p trong c\u00e1c t\u00ecnh hu\u1ed1ng y\u00eau c\u1ea7u t\u00ednh to\u00e1n an to\u00e0n ho\u1eb7c tr\u00e1nh v\u01b0\u1ee3t qu\u00e1 m\u1ed9t m\u1ee9c gi\u1edbi h\u1ea1n n\u00e0o \u0111\u00f3.<\/span><\/p>\n<h4 style=\"text-align: justify;\"><b>C\u00fa ph\u00e1p h\u00e0m<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m: <strong>=ROUNDDOWN(Number, Num_digits)<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Num_digits l\u00e0 v\u1ecb tr\u00ed l\u00e0m tr\u00f2n m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng, l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean (thu\u1ed9c t\u1eadp s\u1ed1 nguy\u00ean Z) c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 \u00e2m ho\u1eb7c b\u1eb1ng 0.<\/span><\/li>\n<\/ul>\n<p>L\u01b0u \u00fd: Tham s\u1ed1 Number c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 th\u1ef1c thu\u1ed9c t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 th\u1ef1c R, bao g\u1ed3m s\u1ed1 nguy\u00ean (v\u00ed d\u1ee5: -25, -1, 0, 5, 1000), s\u1ed1 th\u1eadp ph\u00e2n (v\u00ed d\u1ee5: -7.2, 0.5) ho\u1eb7c ph\u00e2n s\u1ed1 (v\u00ed d\u1ee5: 2\/3). Tham s\u1ed1 Num_digits l\u00e0 s\u1ed1 nguy\u00ean thu\u1ed9c t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 nguy\u00ean Z, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 \u00e2m, s\u1ed1 d\u01b0\u01a1ng ho\u1eb7c b\u1eb1ng 0 (v\u00ed d\u1ee5: -25, -1, 0, 2, 100). N\u1ebfu Num_digits b\u1eb1ng 0, h\u00e0m l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t; n\u1ebfu l\u00e0 s\u1ed1 d\u01b0\u01a1ng, l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn v\u1ecb tr\u00ed th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng; n\u1ebfu l\u00e0 s\u1ed1 \u00e2m, l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c, tr\u0103m,&#8230; t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<h4 style=\"text-align: justify;\"><b>C\u00e1ch s\u1eed d\u1ee5ng<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c =ROUNDDOWN(Number, Num_digits) v\u00e0o \u00f4 c\u1ea7n t\u00ednh to\u00e1n. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp s\u1ed1 v\u00e0o tham s\u1ed1 Number ho\u1eb7c ch\u1ecdn \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n. T\u01b0\u01a1ng t\u1ef1, v\u1edbi Num_digits, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 v\u1ecb tr\u00ed l\u00e0m tr\u00f2n mong mu\u1ed1n ho\u1eb7c ch\u1ecdn \u00f4 tham chi\u1ebfu.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi Num_digits = 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5, 8.1424240 s\u1ebd tr\u1edf th\u00e0nh 8.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461193 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-7.jpg\" alt=\"ham-round-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi Num_digits &gt; 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng t\u1edbi v\u1ecb tr\u00ed th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng. V\u00ed d\u1ee5, Num_digits = 2 s\u1ebd l\u00e0m tr\u00f2n 8.1424240 th\u00e0nh 8.14.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461194 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-8.jpg\" alt=\"ham-round-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi Num_digits &lt; 0, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng sang b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n. V\u00ed d\u1ee5, Num_digits = -1 s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 198.1424240 th\u00e0nh 190.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461195 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-9.jpg\" alt=\"ham-round-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m MROUND<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00e1c v\u1edbi c\u00e1c h\u00e0m l\u00e0m tr\u00f2n truy\u1ec1n th\u1ed1ng nh\u01b0<\/span><b> h\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\">, ROUNDUP hay ROUNDDOWN, h\u00e0m MROUND t\u1eadp trung v\u00e0o vi\u1ec7c l\u00e0m tr\u00f2n theo b\u1ed9i s\u1ed1, ph\u00f9 h\u1ee3p trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf nh\u01b0 l\u00e0m tr\u00f2n s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m, ti\u1ec1n t\u1ec7 hay c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n ph\u1ea3i tu\u00e2n theo b\u1ed9i s\u1ed1 c\u1ee5 th\u1ec3. Nh\u1edd v\u1eady, h\u00e0m n\u00e0y gi\u00fap t\u0103ng t\u00ednh ch\u00ednh x\u00e1c v\u00e0 t\u00ednh nh\u1ea5t qu\u00e1n trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n<h4 style=\"text-align: justify;\"><b>C\u00fa ph\u00e1p h\u00e0m<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m: =MROUND(Number, Multiple)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Multiple l\u00e0 gi\u00e1 tr\u1ecb b\u1ed9i s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn g\u1ea7n nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><b>C\u00e1ch s\u1eed d\u1ee5ng<\/b><\/h4>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MROUND r\u1ea5t d\u1ec5 d\u00e0ng. Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n ch\u1ec9 c\u1ea7n m\u1edf file b\u1ea3ng t\u00ednh v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =MROUND(Number, Multiple) v\u00e0o \u00f4 mu\u1ed1n t\u00ednh to\u00e1n. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp gi\u00e1 tr\u1ecb s\u1ed1 v\u00e0o tham s\u1ed1 Number ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n. T\u01b0\u01a1ng t\u1ef1, Multiple c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ed9i s\u1ed1 mong mu\u1ed1n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461196 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-10.jpg\" alt=\"ham-round-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 19 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 2, b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c =MROUND(19, 2). K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 20. B\u1ea1n c\u00f3 th\u1ec3 xem qua h\u00ecnh \u1ea3nh minh h\u1ecda \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng nh\u00e9.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc h\u1ebft, c\u1ea7n l\u01b0u \u00fd r\u1eb1ng tham s\u1ed1 Num_digits trong h\u00e0m ROUND ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean v\u00e0 c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 \u00e2m ho\u1eb7c b\u1eb1ng 0. N\u1ebfu b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1 nguy\u00ean ho\u1eb7c b\u1ecf tr\u1ed1ng tham s\u1ed1 n\u00e0y, h\u00e0m s\u1ebd b\u00e1o l\u1ed7i ho\u1eb7c cho k\u1ebft qu\u1ea3 kh\u00f4ng nh\u01b0 mong \u0111\u1ee3i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd quan tr\u1ecdng n\u1eefa l\u00e0 h\u00e0m ROUND l\u00e0m tr\u00f2n theo quy t\u1eafc chu\u1ea9n: c\u00e1c s\u1ed1 c\u00f3 ch\u1eef s\u1ed1 ti\u1ebfp theo t\u1eeb 5 tr\u1edf l\u00ean s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean, c\u00f2n c\u00e1c s\u1ed1 nh\u1ecf h\u01a1n 5 th\u00ec \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p g\u00e2y nh\u1ea7m l\u1eabn ho\u1eb7c kh\u00f4ng ph\u00f9 h\u1ee3p trong c\u00e1c \u1ee9ng d\u1ee5ng \u0111\u00f2i h\u1ecfi s\u1ef1 l\u00e0m tr\u00f2n \u0111\u1eb7c bi\u1ec7t nh\u01b0 t\u00e0i ch\u00ednh ho\u1eb7c k\u1ebf to\u00e1n, khi \u0111\u00f3 b\u1ea1n n\u00ean c\u00e2n nh\u1eafc s\u1eed d\u1ee5ng c\u00e1c h\u00e0m ROUNDUP ho\u1eb7c ROUNDDOWN \u0111\u1ec3 ki\u1ec3m so\u00e1t h\u01b0\u1edbng l\u00e0m tr\u00f2n r\u00f5 r\u00e0ng h\u01a1n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/ham-round-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-461197 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-11.jpg\" alt=\"ham-round-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, khi s\u1eed d\u1ee5ng h\u00e0m ROUND v\u1edbi c\u00e1c s\u1ed1 \u00e2m ho\u1eb7c s\u1ed1 th\u1eadp ph\u00e2n c\u00f3 \u0111\u1ed9 d\u00e0i l\u1edbn, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng \u00f4 trong Excel \u0111\u1ee7 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb c\u00f3 th\u1ec3 b\u1ecb l\u00e0m tr\u00f2n t\u1ef1 \u0111\u1ed9ng b\u1edfi Excel, g\u00e2y hi\u1ec3u l\u1ea7m v\u1ec1 gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf trong \u00f4.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u0169ng n\u00ean l\u01b0u \u00fd r\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m ROUND qu\u00e1 nhi\u1ec1u trong c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p c\u00f3 th\u1ec3 l\u00e0m gi\u1ea3m hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t v\u1edbi c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn. Do \u0111\u00f3, h\u00e3y c\u00e2n nh\u1eafc \u00e1p d\u1ee5ng l\u00e0m tr\u00f2n \u1edf c\u00e1c b\u01b0\u1edbc cu\u1ed1i c\u00f9ng ho\u1eb7c ch\u1ec9 \u1edf nh\u1eefng \u00f4 c\u1ea7n thi\u1ebft \u0111\u1ec3 gi\u1eef hi\u1ec7u su\u1ea5t ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n t\u1ea5t c\u1ea3 nh\u1eefng th\u00f4ng tin li\u00ean quan \u0111\u1ebfn<\/span><b> h\u00e0m ROUND trong Excel<\/b><span style=\"font-weight: 400;\">. Hy v\u1ecdng n\u1ed9i dung n\u00e0y s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n c\u00e1c th\u1ee7 thu\u1eadt Excel h\u1eefu \u00edch nh\u1ea5t nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so\/\"><strong>10+ c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 nhanh g\u1ecdn trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumif-trong-excel\/\"><strong>H\u00e0m SUMIF trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft<\/strong><\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m ROUND trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap ng\u01b0\u1eddi d\u00f9ng l\u00e0m tr\u00f2n s\u1ed1 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 linh ho\u1ea1t theo nhu c\u1ea7u. Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi x\u1eed l\u00fd c\u00e1c ph\u00e9p t\u00ednh t\u00e0i ch\u00ednh ho\u1eb7c th\u1ed1ng k\u00ea, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 l\u00e0 r\u1ea5t [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":461186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-461180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-30T13:41:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daisy Daisy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daisy Daisy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c\"},\"headline\":\"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\",\"datePublished\":\"2025-05-30T13:41:49+00:00\",\"dateModified\":\"2025-05-30T13:41:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\"},\"wordCount\":3077,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\",\"name\":\"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg\",\"datePublished\":\"2025-05-30T13:41:49+00:00\",\"dateModified\":\"2025-05-30T13:41:49+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-round-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-05-30T13:41:49+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c"},"headline":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1","datePublished":"2025-05-30T13:41:49+00:00","dateModified":"2025-05-30T13:41:49+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/"},"wordCount":3077,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/","name":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg","datePublished":"2025-05-30T13:41:49+00:00","dateModified":"2025-05-30T13:41:49+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel, c\u0169ng nh\u01b0 c\u00e1c h\u00e0m li\u00ean quan \u0111\u1ebfn h\u00e0m ROUND c\u00f9ng v\u00ed d\u1ee5 minh h\u1ecda.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/ham-round-trong-excel.jpg","width":1200,"height":628,"caption":"ham-round-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-round-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m ROUND trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/461180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=461180"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/461180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/461186"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=461180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=461180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=461180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}