{"id":459862,"date":"2025-05-27T09:02:16","date_gmt":"2025-05-27T02:02:16","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=459862"},"modified":"2025-05-27T09:02:16","modified_gmt":"2025-05-27T02:02:16","slug":"cach-lam-tron-so","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so\/","title":{"rendered":"10+ c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 nhanh g\u1ecdn trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"

C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1<\/b> l\u00e0 m\u1ed9t thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 quan tr\u1ecdng trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u b\u1eb1ng Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng kh\u00e1m ph\u00e1 10+ th\u1ee7 thu\u1eadt l\u00e0m tr\u00f2n s\u1ed1 nhanh g\u1ecdn trong Excel, \u0111i k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng t\u00ecnh hu\u1ed1ng.<\/span><\/p>\n

Khi n\u00e0o c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1?<\/b><\/h2>\n

Trong Excel, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 tr\u1edf n\u00ean c\u1ea7n thi\u1ebft khi b\u1ea1n mu\u1ed1n \u0111\u01a1n gi\u1ea3n h\u00f3a th\u00f4ng tin, gi\u1ea3m \u0111\u1ed9 ph\u1ee9c t\u1ea1p ho\u1eb7c \u0111\u1ea3m b\u1ea3o s\u1ef1 r\u00f5 r\u00e0ng, d\u1ec5 hi\u1ec3u cho ng\u01b0\u1eddi \u0111\u1ecdc. \u0110\u1eb7c bi\u1ec7t khi nh\u1eefng con s\u1ed1 c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c cao kh\u00f4ng th\u1ef1c s\u1ef1 c\u1ea7n thi\u1ebft.<\/span><\/p>\n

M\u1ed9t trong nh\u1eefng t\u00ecnh hu\u1ed1ng ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1 l\u00e0 khi t\u1ea1o b\u00e1o c\u00e1o t\u00e0i ch\u00ednh. C\u00e1c con s\u1ed1 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng \u0111\u01a1n v\u1ecb, h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ngh\u00ecn \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi xem d\u1ec5 h\u00ecnh dung b\u1ee9c tranh t\u00e0i ch\u00ednh t\u1ed5ng th\u1ec3 m\u00e0 kh\u00f4ng b\u1ecb r\u1ed1i b\u1edfi c\u00e1c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n nh\u1ecf l\u1ebb. T\u01b0\u01a1ng t\u1ef1, trong c\u00e1c b\u1ea3n th\u1ed1ng k\u00ea, vi\u1ec7c l\u00e0m tr\u00f2n gi\u00fap l\u00e0m g\u1ecdn b\u1ea3ng bi\u1ec3u, l\u00e0m n\u1ed5i b\u1eadt xu h\u01b0\u1edbng thay v\u00ec l\u00e0m ng\u01b0\u1eddi \u0111\u1ecdc b\u1ecb ph\u00e2n t\u00e2m b\u1edfi nh\u1eefng chi ti\u1ebft nh\u1ecf kh\u00f4ng c\u00f3 \u00fd ngh\u0129a l\u1edbn v\u1ec1 m\u1eb7t th\u1ed1ng k\u00ea.<\/span><\/p>\n

\"cach-lam-tron-so-1\"<\/picture><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 c\u0169ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi x\u1eed l\u00fd c\u00e1c ph\u00e9p t\u00ednh d\u00e0i ho\u1eb7c ph\u1ee9c t\u1ea1p, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi k\u1ebft qu\u1ea3 mang l\u1ea1i m\u1ed9t chu\u1ed7i s\u1ed1 th\u1eadp ph\u00e2n qu\u00e1 d\u00e0i. N\u1ebfu kh\u00f4ng c\u1ea7n \u0111\u1ed9 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i (v\u00ed d\u1ee5 nh\u01b0 trong t\u00ednh to\u00e1n t\u00e0i ch\u00ednh vi m\u00f4, ho\u1eb7c khi l\u1eadp k\u1ebf ho\u1ea1ch t\u1ed5ng qu\u00e1t), l\u00e0m tr\u00f2n gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng sai s\u1ed1 nh\u1ecf t\u00edch l\u0169y c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c b\u01b0\u1edbc t\u00ednh ti\u1ebfp theo. Ngo\u00e0i ra, vi\u1ec7c l\u00e0m tr\u00f2n c\u00f2n gi\u00fap \u0111\u1ea3m b\u1ea3o t\u00ednh nh\u1ea5t qu\u00e1n gi\u1eefa c\u00e1c con s\u1ed1 trong b\u1ea3ng t\u00ednh, nh\u1ea5t l\u00e0 khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau.<\/span><\/p>\n

10+ c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 nhanh g\u1ecdn trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/b><\/h2>\n

Excel cung c\u1ea5p r\u1ea5t nhi\u1ec1u h\u00e0m l\u00e0m tr\u00f2n linh ho\u1ea1t, ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3 nh\u01b0 l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n nh\u1ea5t \u0111\u1ecbnh, l\u00e0m tr\u00f2n l\u00ean, l\u00e0m tr\u00f2n xu\u1ed1ng, l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t, ho\u1eb7c th\u1eadm ch\u00ed l\u00e0m tr\u00f2n theo quy t\u1eafc ri\u00eang bi\u1ec7t. V\u00e0 b\u00ean d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb cho b\u1ea1n 10 th\u1ee7 thu\u1eadt l\u00e0m tr\u00f2n s\u1ed1 nhanh g\u1ecdn v\u00e0 chu\u1ea9n x\u00e1c nh\u00e9.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 kh\u00f4ng d\u00f9ng h\u00e0m Excel<\/b><\/h3>\n

Khi s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, Excel s\u1ebd kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1eadt trong \u00f4 m\u00e0 ch\u1ec9 \u0111i\u1ec1u ch\u1ec9nh c\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y, gi\u00fap b\u1ea3ng t\u00ednh tr\u1edf n\u00ean tr\u1ef1c quan, d\u1ec5 nh\u00ecn v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n.<\/span><\/p>\n

\"cach-lam-tron-so-2\"<\/picture><\/p>\n

\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n qu\u00e9t ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n. Sau \u0111\u00f3, tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n v\u00e0o th\u1ebb Home v\u00e0 t\u00ecm \u0111\u1ebfn v\u00f9ng Number. T\u1ea1i \u0111\u00e2y, nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <\/span>Decrease Decimal<\/b> l\u00e0 n\u00fat c\u00f3 h\u00ecnh d\u1ea5u ch\u1ea5m v\u00e0 m\u0169i t\u00ean h\u01b0\u1edbng sang ph\u1ea3i. M\u1ed7i l\u1ea7n nh\u1ea5n s\u1ebd gi\u1ea3m \u0111i m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n nhi\u1ec1u l\u1ea7n \u0111\u1ec3 gi\u1ea3m xu\u1ed1ng c\u00f2n 1 ch\u1eef s\u1ed1, ho\u1eb7c l\u00e0m tr\u00f2n ho\u00e0n to\u00e0n th\u00e0nh s\u1ed1 nguy\u00ean n\u1ebfu mu\u1ed1n.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ROUND<\/b><\/h3>\n

H\u00e0m ROUND l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng nh\u1ea5t trong Excel \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1. \u0110\u00e2y c\u0169ng l\u00e0 <\/span>c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1<\/b> ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau, t\u1eeb vi\u1ec7c l\u00e0m tr\u00f2n c\u00e1c s\u1ed1 li\u1ec7u \u0111\u01a1n gi\u1ea3n cho \u0111\u1ebfn t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u theo quy t\u1eafc l\u00e0m tr\u00f2n c\u1ee5 th\u1ec3.<\/span><\/p>\n

B\u1ea1n ch\u1ec9 c\u1ea7n m\u1edf file Excel v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c <\/span>=ROUND(Number, Num_digits) <\/b>v\u00e0o \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Trong \u0111\u00f3, Number l\u00e0 s\u1ed1 ho\u1eb7c \u00f4 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n, c\u00f2n Num_digits l\u00e0 tham s\u1ed1 x\u00e1c \u0111\u1ecbnh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i sau khi l\u00e0m tr\u00f2n. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp gi\u00e1 tr\u1ecb ho\u1eb7c ch\u1ecdn \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ec3 l\u00e0m tr\u00f2n.<\/span><\/p>\n

N\u1ebfu <\/span>Num_digits b\u1eb1ng 0<\/b>, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5, =ROUND(8.1424240, 0) s\u1ebd tr\u1ea3 v\u1ec1 8, c\u00f2n =ROUND(6.4587600, 0) s\u1ebd tr\u1ea3 v\u1ec1 6.\u00a0<\/span><\/p>\n

\"cach-lam-tron-so-3\"<\/picture><\/p>\n

Khi <\/span>Num_digits l\u1edbn h\u01a1n 0<\/b>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn v\u1ecb tr\u00ed th\u1eadp ph\u00e2n ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n d\u00f9ng =ROUND(8.1424240, 2), k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 8.14, ngh\u0129a l\u00e0 gi\u1eef l\u1ea1i hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.\u00a0<\/span><\/p>\n

\"cach-lam-tron-so-4\"<\/picture><\/p>\n

T\u01b0\u01a1ng t\u1ef1, v\u1edbi <\/span>Num_digits nh\u1ecf h\u01a1n 0<\/b> th\u00ec h\u00e0m t\u00ednh l\u00e0m tr\u00f2n s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb s\u1ed1 b\u00ean tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n v\u00e0 c\u1ee9 th\u1ebf ti\u1ebfp t\u1ee5c.<\/span><\/p>\n

\"cach-lam-tron-so-5\"<\/picture><\/p>\n

C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ROUNDUP<\/b><\/h3>\n

H\u00e0m ROUNDUP trong Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 theo h\u01b0\u1edbng lu\u00f4n l\u00e0m tr\u00f2n l\u00ean, t\u1ee9c l\u00e0 k\u1ebft qu\u1ea3 sau khi l\u00e0m tr\u00f2n s\u1ebd b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb g\u1ed1c. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o s\u1ed1 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n kh\u00f4ng bao gi\u1edd nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb ban \u0111\u1ea7u, v\u00ed d\u1ee5 nh\u01b0 khi t\u00ednh chi ph\u00ed, d\u1ef1 to\u00e1n ho\u1eb7c c\u00e1c con s\u1ed1 t\u00e0i ch\u00ednh c\u1ea7n l\u00e0m tr\u00f2n l\u00ean \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o an to\u00e0n.<\/span><\/p>\n

Theo \u0111\u00f3, b\u1ea1n h\u00e3y m\u1edf file Excel ch\u1ecdn \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c theo c\u00fa ph\u00e1p: <\/span>=ROUNDUP(Number, Num_digits)<\/b>. Trong \u0111\u00f3, Number l\u00e0 s\u1ed1 ho\u1eb7c \u00f4 ch\u1ee9a s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n, c\u00f2n Num_digits x\u00e1c \u0111\u1ecbnh s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i ho\u1eb7c v\u1ecb tr\u00ed l\u00e0m tr\u00f2n. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp s\u1ed1 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u00f3.<\/span><\/p>\n

N\u1ebfu <\/span>Num_digits b\u1eb1ng 0<\/b>, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t, v\u00ed d\u1ee5 =ROUNDUP(8.1424240, 0) cho k\u1ebft qu\u1ea3 9, d\u00f9 s\u1ed1 g\u1ed1c l\u00e0 3.1.<\/span><\/p>\n

\"cach-lam-tron-so-6\"<\/picture><\/p>\n

Khi <\/span>Num_digits l\u1edbn h\u01a1n 0<\/b>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn v\u1ecb tr\u00ed th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5, =ROUNDUP(8.1424240, 2) tr\u1ea3 v\u1ec1 8.15, l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.\u00a0<\/span><\/p>\n

\"cach-lam-tron-so-7\"<\/picture><\/p>\n

\u0110\u1eb7c bi\u1ec7t, n\u1ebfu<\/span> Num_digits nh\u1ecf h\u01a1n 0<\/b>, h\u00e0m ROUNDUP s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 sang b\u00ean 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 ho\u1eb7c h\u00e0ng ngh\u00ecn, t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a Num_digits. V\u00ed d\u1ee5, =ROUNDUP(198.1424240, -1) s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn h\u00e0ng ch\u1ee5c, cho k\u1ebft qu\u1ea3 200.\u00a0<\/span><\/p>\n

\"cach-lam-tron-so-8\"<\/picture><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ROUNDDOWN<\/b><\/h3>\n

Tr\u00e1i ng\u01b0\u1ee3c v\u1edbi h\u00e0m ROUNDUP, h\u00e0m ROUNDDOWN gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 theo h\u01b0\u1edbng gi\u1ea3m, t\u1ee9c l\u00e0 k\u1ebft qu\u1ea3 l\u00e0m tr\u00f2n lu\u00f4n nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb ban \u0111\u1ea7u, b\u1ea5t k\u1ec3 ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 bao nhi\u00eau. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u trong c\u00e1c l\u0129nh v\u1ef1c nh\u01b0 l\u1eadp k\u1ebf ho\u1ea1ch chi ph\u00ed, t\u00ednh gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng, ho\u1eb7c c\u1ea7n ki\u1ec3m so\u00e1t m\u1ee9c \u0111\u1ed9 r\u1ee7i ro khi l\u00e0m tr\u00f2n.<\/span><\/p>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n<\/span> c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1<\/b> b\u1eb1ng h\u00e0m ROUNDDOWN, b\u1ea1n ch\u1ecdn \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c v\u1edbi c\u00fa ph\u00e1p: <\/span>=ROUNDDOWN(Number, Num_digits)<\/b>.\u00a0<\/span><\/p>\n

N\u1ebfu b\u1ea1n \u0111\u1eb7t <\/span>Num_digits = 0<\/b>, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5, =ROUNDDOWN(8.1424240, 0) s\u1ebd tr\u1ea3 v\u1ec1 8, kh\u00f4ng quan t\u00e2m ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 bao nhi\u00eau.\u00a0<\/span><\/p>\n

\"cach-lam-tron-so-9\"<\/picture><\/p>\n

N\u1ebfu <\/span>Num_digits > 0<\/b>, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng. V\u00ed d\u1ee5, =ROUNDDOWN(8.1424240, 2) s\u1ebd cho k\u1ebft qu\u1ea3 l\u00e0 8.14.<\/span><\/p>\n

\"cach-lam-tron-so-10\"<\/picture><\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n, t\u1ee9c l\u00e0 \u0111\u1ebfn h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ngh\u00ecn, h\u00e3y d\u00f9ng gi\u00e1 tr\u1ecb <\/span>Num_digits < 0<\/b>. V\u00ed d\u1ee5, =ROUNDDOWN(198.1424240, -1) s\u1ebd tr\u1ea3 v\u1ec1 190.<\/span><\/p>\n

\"cach-lam-tron-so-11\"<\/picture><\/p>\n

C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m MROUND<\/b><\/h3>\n

Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1 trong Excel, \u0111\u00f4i khi b\u1ea1n kh\u00f4ng ch\u1ec9 c\u1ea7n l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean hay v\u1ecb tr\u00ed th\u1eadp ph\u00e2n, m\u00e0 c\u00f2n c\u1ea7n l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3. \u0110\u00e2y ch\u00ednh l\u00e0 l\u00fac h\u00e0m MROUND ph\u00e1t huy t\u00e1c d\u1ee5ng. H\u00e0m MROUND cho ph\u00e9p b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb do b\u1ea1n x\u00e1c \u0111\u1ecbnh, c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p x\u1eed l\u00fd s\u1ed1 l\u01b0\u1ee3ng \u0111\u00f3ng g\u00f3i, s\u1ea3n ph\u1ea9m theo l\u00f4, ho\u1eb7c khi chu\u1ea9n h\u00f3a s\u1ed1 li\u1ec7u t\u00e0i ch\u00ednh theo b\u1ed9i s\u1ed1 c\u1ed1 \u0111\u1ecbnh.<\/span><\/p>\n

\"cach-lam-tron-so-18\"<\/picture><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MROUND r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c theo c\u00fa ph\u00e1p: <\/span>=MROUND(Number, Multiple)<\/b>. Tr\u01b0\u1eddng h\u1ee3p, Num_digits = 2 th\u00ec h\u00e0m s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 t\u1edbi gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 2. V\u00ed d\u1ee5: H\u00e0m MROUND t\u1ef1 \u0111\u1ed9ng l\u00e0m tr\u00f2n l\u00ean ho\u1eb7c xu\u1ed1ng t\u00f9y theo b\u1ed9i s\u1ed1 n\u00e0o g\u1ea7n h\u01a1n v\u1edbi gi\u00e1 tr\u1ecb g\u1ed1c. Nh\u01b0 v\u1eady, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng =MROUND(19, 2), k\u1ebft qu\u1ea3 l\u00e0 20.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m CEILING<\/b><\/h3>\n

ROUND, v\u1ed1n l\u00e0m tr\u00f2n theo quy t\u1eafc l\u00e0m tr\u00f2n g\u1ea7n nh\u1ea5t, CEILING lu\u00f4n l\u00e0m tr\u00f2n l\u00ean b\u1ea5t k\u1ec3 ph\u1ea7n th\u1eadp ph\u00e2n nh\u1ecf hay l\u1edbn, v\u00e0 \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n ki\u1ec3m so\u00e1t vi\u1ec7c l\u00e0m tr\u00f2n \u0111\u1ebfn m\u1ed9t m\u1ee9c b\u1ed9i s\u1ed1 x\u00e1c \u0111\u1ecbnh. H\u00e0m n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho m\u1ecdi lo\u1ea1i s\u1ed1 \u2013 bao g\u1ed3m s\u1ed1 nguy\u00ean d\u01b0\u01a1ng, s\u1ed1 nguy\u00ean \u00e2m, s\u1ed1 th\u1eadp ph\u00e2n hay ph\u00e2n s\u1ed1.<\/span><\/p>\n

\"cach-lam-tron-so-13\"<\/picture><\/p>\n

B\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 mong mu\u1ed1n v\u1edbi c\u00fa ph\u00e1p: =<\/span>CEILING(Number, Significance)<\/b>. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/span> =CEILING(-19.753, 0.25)<\/b>, Excel s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 -19.753 l\u00ean \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 0.25, v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 19.75.\u00a0<\/span><\/p>\n

H\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n \u0111\u1ea3m b\u1ea3o s\u1ed1 l\u01b0\u1ee3ng ho\u1eb7c chi ph\u00ed \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n v\u01b0\u1ee3t l\u00ean m\u1ee9c t\u1ed1i thi\u1ec3u. Ch\u1eb3ng h\u1ea1n nh\u01b0 l\u00e0m tr\u00f2n th\u1eddi gian l\u00e0m vi\u1ec7c l\u00ean 15 ph\u00fat, l\u00e0m tr\u00f2n s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m \u0111\u00f3ng g\u00f3i th\u00e0nh l\u00f4 ch\u1eb5n, ho\u1eb7c \u0111\u1ea3m b\u1ea3o m\u1ee9c chi ph\u00ed kh\u00f4ng b\u1ecb th\u1ea5p h\u01a1n m\u1ee9c chu\u1ea9n.<\/span><\/p>\n

C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m FLOOR<\/b><\/h3>\n

H\u00e0m \u0111\u1ed1i l\u1eadp v\u1edbi CEILING, t\u1ee9c l\u00e0 thay v\u00ec l\u00e0m tr\u00f2n l\u00ean, FLOOR s\u1ebd lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch trong c\u00e1c t\u00ecnh hu\u1ed1ng nh\u01b0 t\u00ednh to\u00e1n ng\u00e2n s\u00e1ch, ki\u1ec3m so\u00e1t gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng, ho\u1eb7c khi b\u1ea1n c\u1ea7n l\u00e0m tr\u00f2n s\u1ed1 theo h\u01b0\u1edbng an to\u00e0n, tr\u00e1nh v\u01b0\u1ee3t qu\u00e1 m\u1ed9t ng\u01b0\u1ee1ng nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n

\"cach-lam-tron-so-14\"<\/picture><\/p>\n

H\u00e0m FLOOR \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00fa ph\u00e1p r\u1ea5t \u0111\u01a1n gi\u1ea3n: <\/span>=FLOOR(Number, Significance)<\/b>. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/span> =FLOOR(-19.753, 0.25)<\/b>, Excel s\u1ebd tr\u1ea3 v\u1ec1 -19.753, v\u00ec \u0111\u00e2y l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 0.25 g\u1ea7n nh\u1ea5t nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng -20.\u00a0<\/span><\/p>\n

Nh\u01b0 v\u1eady, h\u00e0m FLOOR \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c b\u00e0i to\u00e1n th\u1ef1c t\u1ebf nh\u01b0 t\u00ednh kh\u1ed1i l\u01b0\u1ee3ng h\u00e0ng h\u00f3a \u0111\u00f3ng g\u00f3i theo t\u1eebng ki\u1ec7n, ph\u00e2n b\u1ed5 ng\u00e2n s\u00e1ch, ho\u1eb7c chia \u0111\u1ec1u th\u1eddi gian m\u00e0 kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 m\u1ee9c quy \u0111\u1ecbnh.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m INT<\/b><\/h3>\n

INT (vi\u1ebft t\u1eaft c\u1ee7a Integer) ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t nhi\u1ec7m v\u1ee5 duy nh\u1ea5t: l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 g\u1ed1c. \u0110\u00e2y l\u00e0 m\u1ed9t <\/span>c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1<\/b> r\u1ea5t h\u1eefu \u00edch trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng quan t\u00e2m \u0111\u1ebfn ph\u1ea7n th\u1eadp ph\u00e2n, ho\u1eb7c mu\u1ed1n lo\u1ea1i b\u1ecf ph\u1ea7n d\u01b0 trong c\u00e1c ph\u00e9p chia, t\u00ednh to\u00e1n th\u1eddi gian, x\u1eed l\u00fd s\u1ed1 l\u01b0\u1ee3ng, ho\u1eb7c chia l\u00f4 s\u1ea3n ph\u1ea9m.<\/span><\/p>\n

\"cach-lam-tron-so-15\"<\/picture><\/p>\n

B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb c\u00fa ph\u00e1p c\u1ee7a h\u00e0m l\u00e0 <\/span>=INT(Number)<\/b>. Trong \u0111\u00f3, Number l\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n xu\u1ed1ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp =INT(8.1), k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 8. N\u1ebfu nh\u1eadp =INT(3.1), k\u1ebft qu\u1ea3 l\u00e0 3.<\/span><\/p>\n

\u0110i\u1ec1u th\u00fa v\u1ecb l\u00e0 khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi s\u1ed1 \u00e2m, h\u00e0m INT v\u1eabn gi\u1eef nguy\u00ean quy t\u1eafc l\u00e0m tr\u00f2n xu\u1ed1ng \u2013 t\u1ee9c l\u00e0 v\u1ec1 ph\u00eda \u00e2m v\u00f4 c\u1ef1c. V\u00ed d\u1ee5, =INT(-0.52) s\u1ebd cho ra k\u1ebft qu\u1ea3 -1.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m TRUNC<\/b><\/h3>\n

Trong Excel, khi b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n c\u1ee7a m\u1ed9t s\u1ed1 m\u00e0 kh\u00f4ng th\u1ef1c hi\u1ec7n <\/span>c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 <\/b>l\u00ean hay xu\u1ed1ng, th\u00ec h\u00e0m TRUNC l\u00e0 c\u00f4ng c\u1ee5 l\u00fd t\u01b0\u1edfng \u0111\u1ec3 s\u1eed d\u1ee5ng. TRUNC \u0111\u01a1n gi\u1ea3n ch\u1ec9 c\u1eaft b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n, gi\u1eef l\u1ea1i ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb sau d\u1ea5u ph\u1ea9y.<\/span><\/p>\n

\"cach-lam-tron-so-16\"<\/picture><\/p>\n

H\u00e0m TRUNC c\u00f3 c\u00fa ph\u00e1p l\u00e0 =TRUNC(Number)<\/strong>, trong \u0111\u00f3, Number l\u00e0 s\u1ed1 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n. V\u00ed d\u1ee5, =TRUNC(8.1) s\u1ebd tr\u1ea3 v\u1ec1 8.<\/span><\/p>\n

V\u00e0 khi l\u00e0m vi\u1ec7c v\u1edbi s\u1ed1 \u00e2m, TRUNC v\u1eabn c\u1eaft ph\u1ea7n th\u1eadp ph\u00e2n m\u00e0 kh\u00f4ng l\u00e0m tr\u00f2n, ngh\u0129a l\u00e0 =TRUNC(-19.753) s\u1ebd tr\u1ea3 v\u1ec1 -19, ch\u1ee9 kh\u00f4ng ph\u1ea3i -20 nh\u01b0 h\u00e0m INT v\u1ed1n l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/p>\n

L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ODD<\/b><\/h3>\n

H\u00e0m ODD trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eb7c bi\u1ec7t, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 b\u1ea5t k\u1ef3 (d\u01b0\u01a1ng ho\u1eb7c \u00e2m) \u0111\u1ebfn s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t theo m\u1ed9t h\u01b0\u1edbng nh\u1ea5t \u0111\u1ecbnh. C\u1ee5 th\u1ec3, v\u1edbi s\u1ed1 d\u01b0\u01a1ng, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn s\u1ed1 l\u1ebb l\u1edbn h\u01a1n g\u1ea7n nh\u1ea5t, c\u00f2n v\u1edbi s\u1ed1 \u00e2m, h\u00e0m s\u1ebd l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 l\u1ebb nh\u1ecf h\u01a1n g\u1ea7n nh\u1ea5t.<\/span><\/p>\n

\"cach-lam-tron-so-17\"<\/picture><\/p>\n

B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c theo c\u00fa ph\u00e1p: <\/span>=ODD(Number)<\/b>, v\u1edbi Number l\u00e0 s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n v\u1ec1 s\u1ed1 l\u1ebb. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp =ODD(-19.753), Excel s\u1ebd tr\u1ea3 v\u1ec1 -21 \u2013 s\u1ed1 l\u1ebb l\u1edbn h\u01a1n ti\u1ebfp theo.\u00a0<\/span><\/p>\n

Tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t, n\u1ebfu b\u1ea1n nh\u1eadp =ODD(5), k\u1ebft qu\u1ea3 v\u1eabn l\u00e0 5 v\u00ec 5 \u0111\u00e3 l\u00e0 s\u1ed1 l\u1ebb. \u0110\u1ed1i v\u1edbi s\u1ed1 \u00e2m, h\u00e0m ODD s\u1ebd l\u00e0m tr\u00f2n theo h\u01b0\u1edbng ng\u01b0\u1ee3c l\u1ea1i. V\u00ed d\u1ee5, =ODD(-2.1) s\u1ebd tr\u1ea3 v\u1ec1 -3, c\u00f2n =ODD(-5) s\u1ebd v\u1eabn l\u00e0 -5.<\/span><\/p>\n

K\u1ebft lu\u1eadn<\/b><\/h2>\n

Nh\u01b0 v\u1eady, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n <\/span>TOP 10 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1<\/b> trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n, r\u1ea5t d\u1ec5 th\u1ef1c hi\u1ec7n ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Hy v\u1ecdng th\u1ee7 thu\u1eadt n\u00e0y s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch nh\u00e9.<\/span><\/p>\n

Xem th\u00eam:<\/b><\/p>\n