{"id":5470,"date":"2025-11-27T16:11:16","date_gmt":"2025-11-27T09:11:16","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-mod-trong-excel-don-gian-de-hieu\/"},"modified":"2025-11-27T16:11:16","modified_gmt":"2025-11-27T09:11:16","slug":"cach-su-dung-ham-mod-trong-excel-don-gian-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-mod-trong-excel-don-gian-de-hieu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m MOD l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u00ednh ph\u1ea7n d\u01b0, t\u00e1ch chu k\u1ef3 ho\u1eb7c x\u1eed l\u00fd nh\u1eefng ph\u00e9p chia \u0111\u1eb7c th\u00f9 trong Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng MOD t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, k\u00e8m v\u00ed d\u1ee5 tr\u1ef1c quan v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ec3 thao t\u00e1c b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

\"C\u00f4ngH\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/em><\/p>\n

\n

1. C\u00f4ng th\u1ee9c h\u00e0m MOD<\/h2>\n<\/div>\n

Trong Excel, h\u00e0m MOD \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y ph\u1ea7n d\u01b0 c\u1ee7a m\u1ed9t ph\u00e9p chia. Khi b\u1ea1n chia number cho divisor, n\u1ebfu ph\u00e9p chia c\u00f2n d\u01b0 th\u00ec MOD tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u01b0 \u0111\u00f3; ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu chia h\u1ebft th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 0.<\/p>\n

C\u00fa ph\u00e1p:<\/strong> =MOD(number, divisor)<\/p>\n

Gi\u1ea3i th\u00edch tham s\u1ed1:<\/strong><\/p>\n

    \n
  • number: <\/strong>Gi\u00e1 tr\u1ecb b\u1ecb chia, t\u1ee9c s\u1ed1 d\u00f9ng \u0111\u1ec3 t\u00ednh ph\u1ea7n d\u01b0.<\/li>\n
  • divisor:<\/strong> S\u1ed1 chia.<\/li>\n<\/ul>\n

    L\u01b0u \u00fd:<\/strong><\/p>\n

      \n
    • N\u1ebfu divisor b\u1eb1ng 0, Excel s\u1ebd b\u00e1o l\u1ed7i #DIV\/0!<\/li>\n
    • H\u00e0m MOD c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n th\u00f4ng qua h\u00e0m INT (l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia).<\/li>\n<\/ul>\n
      \n

      2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel<\/h2>\n<\/div>\n

      V\u00ed d\u1ee5 1: L\u1ea5y ph\u1ea7n d\u01b0 trong ph\u00e9p chia<\/strong><\/p>\n

      T\u1ea1i \u00f4 C2, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

      =MOD(A2,B2)<\/p>\n

      Trong \u0111\u00f3 A2 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ecb chia v\u00e0 B2 l\u00e0 s\u1ed1 chia.<\/p>\n

      Sau khi nh\u1ea5n Enter<\/strong>, Excel s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

      \"B\u1ea3ngT\u00ednh s\u1ed1 d\u01b0 b\u1eb1ng h\u00e0m MOD trong Excel<\/em><\/p>\n

      V\u00ed d\u1ee5 2: T\u00f4 m\u00e0u nh\u1eefng h\u00e0ng l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 3 trong b\u1ea3ng<\/strong><\/p>\n

      B\u01b0\u1edbc 1: <\/strong>Tr\u00ean thanh Ribbon<\/strong>, v\u00e0o th\u1ebb Home<\/strong>, ch\u1ecdn Conditional Formatting<\/strong>, sau \u0111\u00f3 nh\u1ea5n New Rule<\/strong>.<\/p>\n

      \"Ch\u1ecdnM\u1edf New Rule trong Conditional Formatting<\/em><\/p>\n

      B\u01b0\u1edbc 2: <\/strong>Khi h\u1ed9p tho\u1ea1i New Formatting Rule<\/strong> xu\u1ea5t hi\u1ec7n, ch\u1ecdn t\u00f9y ch\u1ecdn Use a formula to determine which cells to format<\/strong>.<\/p>\n

      \"Ch\u1ecdnCh\u1ecdn quy t\u1eafc d\u00f9ng c\u00f4ng th\u1ee9c<\/em><\/p>\n

      B\u01b0\u1edbc 3: <\/strong>\u1ede ph\u1ea7n Edit the Rule Description<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

      =MOD(ROW(A1),3)=0<\/p>\n

      C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap Excel x\u00e1c \u0111\u1ecbnh c\u00e1c d\u00f2ng c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 chia h\u1ebft cho 3.<\/p>\n

      \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c MOD \u0111\u1ec3 t\u00f4 m\u00e0u d\u00f2ng chia h\u1ebft cho 3<\/em><\/p>\n

      B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n Format\u2026<\/strong> \u0111\u1ec3 thi\u1ebft l\u1eadp m\u00e0u n\u1ec1n, m\u00e0u ch\u1eef ho\u1eb7c ki\u1ec3u hi\u1ec3n th\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng cho c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

      \"Thi\u1ebftCh\u1ecdn Format \u0111\u1ec3 thi\u1ebft l\u1eadp m\u00e0u<\/em><\/p>\n

      B\u01b0\u1edbc 5:<\/strong> B\u1ea5m OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t v\u00e0 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00f4 m\u00e0u nh\u1eefng h\u00e0ng l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 3.<\/p>\n

      \"\u00c1pX\u00e1c nh\u1eadn quy t\u1eafc v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng<\/em><\/p>\n

      V\u00ed d\u1ee5 3: T\u00ednh s\u1ed1 ng\u00e0y l\u1ebb trong m\u1ed9t kho\u1ea3ng th\u1eddi gian<\/strong><\/p>\n

      S\u1ed1 ng\u00e0y l\u1ebb l\u00e0 ph\u1ea7n th\u1eddi gian c\u00f2n l\u1ea1i sau khi tr\u1eeb \u0111i c\u00e1c tu\u1ea7n tr\u00f2n (7 ng\u00e0y). N\u00f3i c\u00e1ch kh\u00e1c, \u0111\u00e2y ch\u00ednh l\u00e0 ph\u1ea7n d\u01b0 khi l\u1ea5y s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch chia cho 7.<\/p>\n

      Gi\u1ea3 s\u1eed c\u1ed9t A l\u00e0 ng\u00e0y Check-in v\u00e0 c\u1ed9t B l\u00e0 ng\u00e0y Check-out.<\/p>\n

      T\u1ea1i \u00f4 D2, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

      =MOD(B2-A2,7)<\/p>\n

      \"T\u00ednhT\u00ednh s\u1ed1 ng\u00e0y l\u1ebb b\u1eb1ng h\u00e0m MOD<\/em><\/p>\n

      C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 ng\u00e0y d\u01b0 sau khi \u0111\u00e3 tr\u1eeb h\u1ebft c\u00e1c tu\u1ea7n \u0111\u1ea7y \u0111\u1ee7.<\/p>\n

      Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n

      \"K\u1ebftK\u1ebft qu\u1ea3 s\u1ed1 ng\u00e0y l\u1ebb sau khi tr\u1eeb c\u00e1c tu\u1ea7n tr\u00f2n<\/em><\/p>\n

      Xem th\u00eam: <\/strong>H\u00e0m INT trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c d\u1ec5 hi\u1ec3u<\/div>\n
      \n

      3. L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel<\/h2>\n<\/div>\n
      \n

      3.1. L\u1ed7i #DIV\/0!<\/h3>\n<\/div>\n

      L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi h\u00e0m MOD th\u1ef1c hi\u1ec7n ph\u00e9p chia m\u00e0 s\u1ed1 chia b\u1eb1ng 0. Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd ph\u00e9p chia cho 0 n\u00ean s\u1ebd b\u00e1o l\u1ed7i #DIV\/0!<\/strong>.<\/p>\n

      \"L\u1ed7iL\u1ed7i #DIV\/0! khi m\u1eabu s\u1ed1 b\u1eb1ng 0 trong h\u00e0m MOD<\/em><\/p>\n

      C\u00e1ch x\u1eed l\u00fd:<\/strong> Ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb l\u00e0m m\u1eabu s\u1ed1 v\u00e0 thay \u0111\u1ed5i sang m\u1ed9t s\u1ed1 kh\u00e1c ngo\u00e0i 0, ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh ph\u00e9p t\u00ednh n\u1ebfu t\u00ecnh hu\u1ed1ng \u0111\u00f3 kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p chia.<\/p>\n

      \n

      3.2. L\u1ed7i #VALUE!<\/h3>\n<\/div>\n

      L\u1ed7i #VALUE! x\u1ea3y ra khi m\u1ed9t trong hai \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m MOD (s\u1ed1 b\u1ecb chia ho\u1eb7c s\u1ed1 chia) kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1. Excel kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p chia n\u1ebfu b\u1ea1n nh\u1eadp v\u00e0o ch\u1eef, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c \u00f4 \u0111ang ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

      V\u00ed d\u1ee5 g\u00e2y l\u1ed7i:<\/strong><\/p>\n

        \n
      • =MOD(“text”, 3)<\/li>\n
      • =MOD(A2, “abc”)<\/li>\n<\/ul>\n

        C\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p \u0111\u1ec1u tr\u1ea3 v\u1ec1 #VALUE!<\/strong> v\u00ec \u0111\u1ed1i s\u1ed1 kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1 h\u1ee3p l\u1ec7.<\/p>\n

        \"V\u00edL\u1ed7i #VALUE! khi \u0111\u1ed1i s\u1ed1 h\u00e0m MOD kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1 h\u1ee3p l\u1ec7<\/em><\/p>\n

        C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Ki\u1ec3m tra l\u1ea1i \u00f4 ch\u1ee9a d\u1eef li\u1ec7u, ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o l\u00e0 s\u1ed1, kh\u00f4ng ph\u1ea3i text.<\/p>\n

        \n

        3.3. L\u1ed7i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng<\/h3>\n<\/div>\n

        L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi \u00f4 d\u1eef li\u1ec7u b\u1ea1n s\u1eed d\u1ee5ng th\u1ef1c ch\u1ea5t \u0111ang mang \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, khi\u1ebfn Excel kh\u00f4ng hi\u1ec3u \u0111\u00f3 l\u00e0 s\u1ed1 v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i khi t\u00ednh to\u00e1n (th\u01b0\u1eddng l\u00e0 #VALUE!).<\/p>\n

        C\u00e1ch kh\u1eafc ph\u1ee5c: <\/strong>Chuy\u1ec3n \u00f4 d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng s\u1ed1 (Number). B\u1ea1n th\u1ef1c hi\u1ec7n nh\u01b0 sau: nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u2192 ch\u1ecdn Format Cells<\/strong> \u2192 v\u00e0o th\u1ebb Number<\/strong> \u2192 ch\u1ecdn Number<\/strong> \u2192 b\u1ea5m OK<\/strong>.<\/p>\n

        \"H\u1ed9pChuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng \u00f4 sang Number \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i ng\u00e0y th\u00e1ng g\u00e2y #VALUE!<\/em><\/p>\n

        Khi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel tr\u00f9ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng h\u1ec7 th\u1ed1ng (Region) v\u00e0 \u0111\u01b0\u1ee3c chuy\u1ec3n v\u1ec1 d\u1ea1ng s\u1ed1 h\u1ee3p l\u1ec7, h\u00e0m MOD s\u1ebd ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng.<\/p>\n

        H\u00e0m MOD gi\u00fap b\u1ea1n x\u1eed l\u00fd ph\u00e9p chia l\u1ea5y d\u01b0, ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u v\u00e0 \u00e1p d\u1ee5ng linh ho\u1ea1t trong nhi\u1ec1u b\u1ea3ng t\u00ednh. Khi hi\u1ec3u r\u00f5 c\u00e1ch d\u00f9ng v\u00e0 c\u00e1ch x\u1eed l\u00fd l\u1ed7i, b\u1ea1n s\u1ebd l\u00e0m vi\u1ec7c v\u1edbi Excel nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. Theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o h\u1eefu \u00edch.<\/p>\n

        N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t thi\u1ebft b\u1ecb g\u1ecdn nh\u1eb9 \u0111\u1ec3 h\u1ecdc Excel, ghi ch\u00fa hay x\u1eed l\u00fd c\u00f4ng vi\u1ec7c linh ho\u1ea1t h\u01a1n, \u0111\u1eebng qu\u00ean tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng \u0111ang c\u00f3 t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Nhi\u1ec1u l\u1ef1a ch\u1ecdn hi\u1ec7u n\u0103ng t\u1ed1t, gi\u00e1 h\u1ee3p l\u00fd \u0111ang ch\u1edd b\u1ea1n kh\u00e1m ph\u00e1.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        \u00a0 H\u00e0m MOD l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u00ednh ph\u1ea7n d\u01b0, t\u00e1ch chu k\u1ef3 ho\u1eb7c x\u1eed l\u00fd nh\u1eefng ph\u00e9p chia \u0111\u1eb7c th\u00f9 trong Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng MOD t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, k\u00e8m v\u00ed d\u1ee5 tr\u1ef1c quan v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c […]<\/p>\n","protected":false},"author":1,"featured_media":5471,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5470","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19482.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5470"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5471"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}