{"id":225821,"date":"2023-07-03T20:42:17","date_gmt":"2023-07-03T13:42:17","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=225821"},"modified":"2023-07-03T20:42:17","modified_gmt":"2023-07-03T13:42:17","slug":"cach-dung-ham-chia-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-chia-trong-excel\/","title":{"rendered":"H\u00e0m chia trong excel: H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng"},"content":{"rendered":"

Th\u00f4ng th\u01b0\u1eddng, ng\u01b0\u1eddi d\u00f9ng hay s\u1eed d\u1ee5ng d\u1ea5u (\/) \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p chia trong Excel. Tuy nhi\u00ean, c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft r\u1eb1ng Excel c\u00f3 c\u00e1c h\u00e0m chia v\u1edbi ch\u1ee9c n\u0103ng kh\u00e1c nhau. V\u1eady c\u00e1c h\u00e0m chia n\u00e0y l\u00e0 g\u00ec, c\u00e1ch d\u00f9ng <\/span>h\u00e0m chia trong Excel<\/b> nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.<\/span><\/p>\n

H\u00e0m chia trong Excel k\u00fd hi\u1ec7u l\u00e0 g\u00ec, c\u00f3 m\u1ea5y lo\u1ea1i?<\/b><\/h2>\n

Excel c\u00f3 2 lo\u1ea1i h\u00e0m chia: QUOTIENT (h\u00e0m chia l\u1ea5y ph\u1ea7n nguy\u00ean ph\u00e9p t\u00ednh) v\u00e0 MOD (h\u00e0m chia l\u1ea5y ph\u1ea7n d\u01b0 ph\u00e9p t\u00ednh). C\u1ea3 2 h\u00e0m n\u00e0y \u0111\u1ec1u c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 thay th\u1ebf ph\u00e9p chia (\/) \u0111\u01a1n gi\u1ea3n trong Excel. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m n\u00e0y v\u1edbi nhi\u1ec1u h\u00e0m c\u01a1 b\u1ea3n kh\u00e1c \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p.<\/p>\n

\"ham-chia-trong-excel-1\"<\/p>\n

V\u00ec v\u1eady, thay v\u00ec ch\u1ec9 d\u00f9ng \u0111\u1ebfn ph\u00e9p (\/) nh\u01b0 b\u00ecnh th\u01b0\u1eddng, b\u1ea1n n\u00ean h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng MOD v\u00e0 QUOTIENT \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u linh ho\u1ea1t h\u01a1n. \u0110\u1ec3 bi\u1ebft n\u00ean d\u00f9ng c\u00e1c h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y theo d\u00f5i h\u01b0\u1edbng d\u1eabn chi ti\u1ebft trong ph\u1ea7n sau nh\u00e9.<\/span><\/p>\n

N\u00ean s\u1eed d\u1ee5ng h\u00e0m chia trong Excel hay ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng?<\/b><\/h2>\n

C\u00e1c h\u00e0m v\u00e0 ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng trong Excel c\u00f3 nhi\u1ec1u \u0111i\u1ec3m kh\u00e1c bi\u1ec7t n\u00ean c\u00e1ch d\u00f9ng c\u0169ng kh\u00e1c nhau. C\u1ee5 th\u1ec3:<\/span><\/p>\n

Ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng (\/):<\/b> \u0110\u00e2y l\u00e0 ph\u00e9p chia c\u01a1 b\u1ea3n, s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n chia 5 cho 2 b\u1eb1ng ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 2.5.<\/span><\/p>\n

H\u00e0m QUOTIENT: <\/b>H\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 ph\u1ea7n nguy\u00ean c\u1ee7a k\u1ebft qu\u1ea3 ph\u00e9p chia, v\u00ed d\u1ee5: =QUOTIENT(5, 2) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2, b\u1ecf qua ph\u1ea7n d\u01b0.<\/span><\/p>\n

H\u00e0m MOD: <\/b>H\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p chia, v\u00ed d\u1ee5: =MOD(5, 2) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1.<\/span><\/p>\n

\"ham-chia-trong-excel-17\"<\/p>\n

V\u00ec v\u1eady, n\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea7n nguy\u00ean ho\u1eb7c ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p chia, th\u00ec n\u00ean d\u00f9ng h\u00e0m QUOTIENT v\u00e0 MOD. N\u1ebfu b\u1ea1n c\u1ea7n k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n, h\u00e3y s\u1eed d\u1ee5ng ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng (\/).<\/span><\/p>\n

C\u00e1ch d\u00f9ng h\u00e0m chia trong Excel – h\u00e0m MOD<\/b><\/h2>\n

MOD l\u00e0 h\u00e0m chia Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p t\u00ednh. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong nhi\u1ec1u b\u00e0i to\u00e1n x\u00e1c \u0111\u1ecbnh s\u1ed1 li\u1ec7u ch\u1eb5n\/l\u1ebb ho\u1eb7c x\u00e1c \u0111\u1ecbnh chu k\u1ef3.<\/span><\/p>\n

C\u00fa ph\u00e1p h\u00e0m<\/b><\/h3>\n

C\u00fa ph\u00e1p h\u00e0m MOD r\u1ea5t \u0111\u01a1n gi\u1ea3n, \u0111\u00f3 l\u00e0: <\/span>=MOD(number, divisor)<\/b>. Trong \u0111\u00f3, number l\u00e0 s\u1ed1 chia (t\u1eed s\u1ed1) v\u00e0 divisor l\u00e0 s\u1ed1 b\u1ecb chia (m\u1eabu s\u1ed1) trong ph\u00e9p t\u00ednh.<\/span><\/p>\n

V\u00ed d\u1ee5: =MOD(10,3), ngh\u0129a l\u00e0 chia 10 cho 3 v\u00e0 l\u1ea5y ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p t\u00ednh.<\/span><\/p>\n

\"ham-chia-trong-excel-2\"
C\u00fa ph\u00e1p h\u00e0m chia trong Excel – h\u00e0m MOD (chia l\u1ea5y d\u01b0)<\/em><\/figcaption><\/figure>\n

Ch\u00fa \u00fd:<\/b> B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng d\u1ea5u (,) ho\u1eb7c d\u1ea5u (;) \u0111\u1ec3 ph\u00e2n t\u00e1ch c\u00e1c tham s\u1ed1 trong h\u00e0m MOD t\u00f9y v\u00e0o c\u00e0i \u0111\u1eb7t Excel c\u1ee7a b\u1ea1n.<\/span><\/p>\n

Nguy\u00ean t\u1eafc ho\u1ea1t \u0111\u1ed9ng<\/b><\/h3>\n

K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m MOD trong Excel l\u00e0 ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p chia. C\u1ee5 th\u1ec3, n\u1ebfu l\u1ea5y 10\/3 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 3 v\u00e0 d\u01b0 1. V\u1eady MOD(10,3) s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 1 (t\u1ee9c ch\u1ec9 l\u1ea5y ph\u1ea7n d\u01b0).<\/span><\/p>\n

\"ham-chia-trong-excel-3\"<\/p>\n

\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/b><\/h3>\n

V\u1edbi nguy\u00ean t\u1eafc ho\u1ea1t \u0111\u1ed9ng nh\u01b0 v\u1eady, h\u00e0m MOD c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong nhi\u1ec1u b\u00e0i to\u00e1n t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p trong th\u1ef1c t\u1ebf. Sau \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ec3 \u1ee9ng d\u1ee5ng h\u00e0m chia trong Excel n\u00e0y:<\/span><\/p>\n

V\u00ed d\u1ee5 minh h\u1ecda 1: <\/b>S\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi MOD \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 ch\u1eb5n ho\u1eb7c l\u1ebb.<\/span><\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ed1 trong c\u1ed9t A v\u00e0 b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh s\u1ed1 n\u00e0o l\u00e0 ch\u1eb5n v\u00e0 s\u1ed1 n\u00e0o l\u00e0 l\u1ebb. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi h\u00e0m MOD nh\u01b0 sau:<\/span><\/p>\n

=IF(MOD(A2, 2) = 0, “Ch\u1eb5n”, “L\u1ebb”)<\/span><\/p>\n

\"ham-chia-trong-excel-4\"
\u1ee8ng d\u1ee5ng h\u00e0m MOD Excel \u0111\u1ec3 ki\u1ec3m tra s\u1ed1 ch\u1eb5n hay l\u1ebb nhanh ch\u00f3ng<\/em><\/figcaption><\/figure>\n

Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n