{"id":5438,"date":"2025-11-27T13:37:19","date_gmt":"2025-11-27T06:37:19","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-int-trong-excel-cong-thuc-va-cach-su-dung-cuc-de-hieu\/"},"modified":"2025-11-27T13:37:19","modified_gmt":"2025-11-27T06:37:19","slug":"ham-int-trong-excel-cong-thuc-va-cach-su-dung-cuc-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-int-trong-excel-cong-thuc-va-cach-su-dung-cuc-de-hieu\/","title":{"rendered":"H\u00e0m INT trong Excel: C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ef1c d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m INT trong Excel l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap t\u00e1ch ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1, h\u1ed7 tr\u1ee3 x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh v\u00e0 ch\u00ednh x\u00e1c trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng nh\u01b0 t\u00ednh to\u00e1n, ph\u00e2n t\u00e1ch gi\u00e1 tr\u1ecb hay x\u00e1c \u0111\u1ecbnh tu\u1ea7n l\u00e0m vi\u1ec7c. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00f4ng th\u1ee9c, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n, c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p INT v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u thao t\u00e1c.<\/p>\n

\"C\u00e1chC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INT trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u<\/em><\/p>\n

\n

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

H\u00e0m INT trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t s\u1ed1 v\u00e0 l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch khi c\u1ea7n x\u1eed l\u00fd k\u1ebft qu\u1ea3 ph\u00e9p chia ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh.<\/p>\n

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

Trong \u0111\u00f3, number c\u00f3 th\u1ec3 l\u00e0:<\/p>\n

    \n
  • M\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n tr\u1ef1c ti\u1ebfp, v\u00ed d\u1ee5: 9.6, 7.2<\/li>\n
  • M\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb, ch\u1eb3ng h\u1ea1n: A7, D3<\/li>\n
  • M\u1ed9t ph\u00e9p t\u00ednh ho\u1eb7c ph\u00e9p chia, v\u00ed d\u1ee5: 9\/4, D3\/C1<\/li>\n<\/ul>\n
    \n

    2. C\u00e1ch d\u00f9ng h\u00e0m INT trong Excel<\/h2>\n<\/div>\n
    \n

    2.1. D\u00f9ng h\u00e0m INT l\u1ea5y ph\u1ea7n nguy\u00ean<\/h3>\n<\/div>\n

    L\u1ea5y ph\u1ea7n nguy\u00ean t\u1eeb m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3<\/strong><\/p>\n

    B\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a 12.98. H\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: =INT(12.98)<\/p>\n

    Nh\u1ea5n Enter<\/strong>, Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 12.<\/p>\n

    \"D\u00f9ngC\u00e1ch d\u00f9ng h\u00e0m INT \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t s\u1ed1<\/em><\/p>\n

    L\u1ea5y ph\u1ea7n nguy\u00ean t\u1eeb m\u1ed9t \u00f4 d\u1eef li\u1ec7u<\/strong><\/p>\n

    \u00d4 D5 ch\u1ee9a gi\u00e1 tr\u1ecb 14.6. \u0110\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 n\u00e0y, d\u00f9ng c\u00f4ng th\u1ee9c: =INT(D5)<\/p>\n

    K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 14.<\/p>\n

    \"L\u00e0m\u1ee8ng d\u1ee5ng h\u00e0m INT \u0111\u1ec3 t\u00e1ch ph\u1ea7n nguy\u00ean t\u1eeb gi\u00e1 tr\u1ecb trong \u00f4 d\u1eef li\u1ec7u<\/em><\/p>\n

    L\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t ph\u00e9p chia<\/strong><\/p>\n

    C\u1ea7n l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia E4\/F4, v\u00ed d\u1ee5 E4 = 45 v\u00e0 F4 = 8. C\u00f4ng th\u1ee9c nh\u1eadp v\u00e0o:<\/p>\n

    =INT(E4\/F4)<\/p>\n

    N\u1ebfu 45\/8 = 5.625, h\u00e0m INT s\u1ebd tr\u1ea3 v\u1ec1 5.<\/p>\n

    \"\u00c1pL\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia b\u1eb1ng h\u00e0m INT<\/em><\/p>\n

    \n

    2.2. D\u00f9ng h\u00e0m INT l\u1ea5y ph\u1ea7n nguy\u00ean kh\u00f4ng l\u00e0m tr\u00f2n s\u1ed1 \u00e2m<\/h3>\n<\/div>\n

    H\u00e0m INT c\u00f3 xu h\u01b0\u1edbng l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ed1i v\u1edbi s\u1ed1 \u00e2m, d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb ph\u1ea7n nguy\u00ean th\u1ef1c t\u1ebf. \u0110\u1ec3 l\u1ea5y \u0111\u00fang ph\u1ea7n nguy\u00ean m\u00e0 kh\u00f4ng b\u1ecb l\u00f9i v\u1ec1 ph\u00eda \u00e2m h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch x\u1eed l\u00fd sau:<\/p>\n

    =INT(Number * -1) * -1<\/p>\n

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

      \n
    • Number * -1: <\/strong>chuy\u1ec3n s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 d\u01b0\u01a1ng t\u1ea1m th\u1eddi.<\/li>\n
    • INT(…): <\/strong>l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a gi\u00e1 tr\u1ecb d\u01b0\u01a1ng.<\/li>\n
    • … * -1: <\/strong>\u0111\u01b0a k\u1ebft qu\u1ea3 v\u1ec1 l\u1ea1i s\u1ed1 \u00e2m \u0111\u00fang gi\u00e1 tr\u1ecb ph\u1ea7n nguy\u00ean.<\/li>\n<\/ul>\n

      V\u00ed d\u1ee5:<\/strong> =INT(-7.3 * -1) * -1<\/p>\n

      Ph\u1ea7n nguy\u00ean c\u1ee7a 7.3 l\u00e0 7 \u2192 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1: -7<\/p>\n

      \"V\u00edC\u00e1ch x\u1eed l\u00fd s\u1ed1 \u00e2m \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean \u0111\u00fang b\u1eb1ng h\u00e0m INT<\/em><\/p>\n

      Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m OFFSET trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u<\/div>\n
      \n

      2.3. D\u00f9ng h\u00e0m INT t\u00ednh s\u1ed1 tu\u1ea7n<\/h3>\n<\/div>\n

      B\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 tu\u1ea7n gi\u1eefa hai m\u1ed1c th\u1eddi gian b\u1eb1ng c\u00e1ch l\u1ea5y ch\u00eanh l\u1ec7ch ng\u00e0y v\u00e0 chia cho 7, sau \u0111\u00f3 d\u00f9ng h\u00e0m INT \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean. C\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng:<\/p>\n

      =INT((Ng\u00e0y k\u1ebft th\u00fac – Ng\u00e0y b\u1eaft \u0111\u1ea7u) \/ 7)<\/p>\n

      Trong \u0111\u00f3:<\/strong><\/p>\n

        \n
      • Ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0 m\u1ed1c th\u1eddi gian \u0111\u1ea7u ti\u00ean.<\/li>\n
      • Ng\u00e0y k\u1ebft th\u00fac l\u00e0 m\u1ed1c th\u1eddi gian sau \u0111\u00f3.<\/li>\n<\/ul>\n

        V\u00ed d\u1ee5:<\/strong> N\u1ebfu A1 = 01\/01\/2025 v\u00e0 B1 = 14\/01\/2025, c\u00f4ng th\u1ee9c:<\/p>\n

        =INT((B1 – A1) \/ 7)<\/p>\n

        K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 1 tu\u1ea7n. N\u1ebfu A1 = 01\/01\/2025 v\u00e0 B1 = 15\/01\/2025, c\u00f4ng th\u1ee9c tr\u00ean cho k\u1ebft qu\u1ea3 2 tu\u1ea7n, v\u00ec s\u1ed1 ng\u00e0y c\u00e1ch nhau \u0111\u00e3 v\u01b0\u1ee3t qu\u00e1 14.<\/p>\n

        \"B\u1ea3ngC\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m INT t\u00ednh s\u1ed1 tu\u1ea7n gi\u1eefa hai ng\u00e0y<\/em><\/p>\n

        \n

        3. H\u00e0m INT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MOD trong Excel<\/h2>\n<\/div>\n

        H\u00e0m MOD \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y ph\u1ea7n d\u01b0 c\u1ee7a m\u1ed9t ph\u00e9p chia v\u1edbi c\u00fa ph\u00e1p: =MOD(n, d)<\/p>\n

        Trong \u0111\u00f3 n l\u00e0 s\u1ed1 b\u1ecb chia v\u00e0 d l\u00e0 s\u1ed1 chia.<\/p>\n

        Khi ph\u1ed1i h\u1ee3p MOD c\u00f9ng INT, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1ch s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch gi\u1eefa hai m\u1ed1c th\u1eddi gian th\u00e0nh s\u1ed1 tu\u1ea7n tr\u1ecdn v\u1eb9n v\u00e0 s\u1ed1 ng\u00e0y l\u1ebb. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda c\u00e1ch t\u00ednh t\u1ed5ng th\u1eddi gian l\u00e0m vi\u1ec7c theo tu\u1ea7n v\u00e0 ng\u00e0y:<\/p>\n

        B\u01b0\u1edbc 1: <\/strong>M\u1ed9t tu\u1ea7n t\u01b0\u01a1ng \u1ee9ng 7 ng\u00e0y, v\u00ec v\u1eady \u0111\u1ec3 t\u00ednh s\u1ed1 tu\u1ea7n ho\u00e0n ch\u1ec9nh, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

        =INT((B11 – A11) \/ 7)<\/p>\n

        Trong \u0111\u00f3 A11 l\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u, B11 l\u00e0 ng\u00e0y k\u1ebft th\u00fac.<\/p>\n

        \"T\u00ednhNh\u1eadp c\u00f4ng th\u1ee9c INT t\u00ednh s\u1ed1 tu\u1ea7n trong Excel<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter <\/strong>\u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3, sau \u0111\u00f3 k\u00e9o ch\u1ed1t Fill Handle<\/strong> (d\u1ea5u c\u1ed9ng nh\u1ecf m\u00e0u \u0111en) \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/p>\n

        \"K\u1ebftT\u00ednh s\u1ed1 tu\u1ea7n ho\u00e0n ch\u1ec9nh b\u1eb1ng h\u00e0m INT<\/em><\/p>\n

        B\u01b0\u1edbc 3: <\/strong>S\u1ed1 ng\u00e0y l\u1ebb l\u00e0 ph\u1ea7n d\u01b0 sau khi l\u1ea5y tr\u1ecdn tu\u1ea7n, n\u00ean d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n

        =MOD(B11 – A11, 7)<\/p>\n

        B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 s\u1ed1 ng\u00e0y d\u01b0.<\/p>\n

        \"T\u00ednhD\u00f9ng h\u00e0m MOD t\u00ednh s\u1ed1 ng\u00e0y l\u1ebb sau khi tr\u1eeb s\u1ed1 tu\u1ea7n<\/em><\/p>\n

        \n

        4. So s\u00e1nh h\u00e0m INT v\u00e0 h\u00e0m QUOTIENT<\/h2>\n<\/div>\n

        C\u1ea3 INT v\u00e0 QUOTIENT \u0111\u1ec1u d\u00f9ng \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia, nh\u01b0ng c\u00e1ch x\u1eed l\u00fd s\u1ed1 \u00e2m c\u1ee7a hai h\u00e0m l\u1ea1i kh\u00e1c nhau, d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng gi\u1ed1ng nhau trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p.<\/p>\n

        Quan s\u00e1t b\u1ea3ng v\u00ed d\u1ee5:<\/p>\n

          \n
        • Khi A v\u00e0 B \u0111\u1ec1u d\u01b0\u01a1ng, INT v\u00e0 QUOTIENT cho k\u1ebft qu\u1ea3 gi\u1ed1ng nhau.<\/li>\n
        • Khi A l\u00e0 s\u1ed1 \u00e2m, k\u1ebft qu\u1ea3 gi\u1eefa hai h\u00e0m b\u1eaft \u0111\u1ea7u kh\u00e1c:<\/li>\n
        • INT lu\u00f4n l\u00e0m tr\u00f2n v\u1ec1 ph\u00eda \u00e2m v\u00f4 c\u00f9ng (l\u00f9i xu\u1ed1ng s\u1ed1 nguy\u00ean nh\u1ecf h\u01a1n).<\/li>\n
        • QUOTIENT ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u1ea5y ph\u1ea7n nguy\u00ean tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y, kh\u00f4ng quan t\u00e2m chi\u1ec1u \u00e2m hay d\u01b0\u01a1ng.<\/li>\n<\/ul>\n

          \"B\u1ea3ngSo s\u00e1nh k\u1ebft qu\u1ea3 gi\u1eefa h\u00e0m INT v\u00e0 QUOTIENT<\/em><\/p>\n

          H\u00e0m INT lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng n\u00ean cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c h\u01a1n khi x\u1eed l\u00fd s\u1ed1 \u00e2m. Trong khi \u0111\u00f3, QUOTIENT ch\u1ec9 c\u1eaft ph\u1ea7n th\u1eadp ph\u00e2n n\u00ean \u0111\u00f4i l\u00fac s\u1ebd cho gi\u00e1 tr\u1ecb kh\u00e1c. T\u00f9y m\u1ee5c \u0111\u00edch t\u00ednh to\u00e1n, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t ch\u1ecdn h\u00e0m ph\u00f9 h\u1ee3p \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 \u0111\u00fang v\u1edbi y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c.<\/p>\n

          H\u00e0m INT l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi c\u1ea7n l\u1ea5y ph\u1ea7n nguy\u00ean, x\u1eed l\u00fd th\u1eddi gian hay k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u t\u00ednh to\u00e1n trong Excel. \u0110\u1ec3 xem th\u00eam nhi\u1ec1u m\u1eb9o hay v\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft, h\u00e3y 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.<\/p>\n

          N\u1ebfu c\u1ea7n m\u1ed9t thi\u1ebft b\u1ecb g\u1ecdn nh\u1eb9 \u0111\u1ec3 h\u1ecdc t\u1eadp, l\u00e0m vi\u1ec7c Excel hi\u1ec7u qu\u1ea3 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng \u0111ang \u0111\u01b0\u1ee3c gi\u1ea3m t\u1ed1t t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          \u00a0 H\u00e0m INT trong Excel l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap t\u00e1ch ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1, h\u1ed7 tr\u1ee3 x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh v\u00e0 ch\u00ednh x\u00e1c trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng nh\u01b0 t\u00ednh to\u00e1n, ph\u00e2n t\u00e1ch gi\u00e1 tr\u1ecb hay x\u00e1c \u0111\u1ecbnh tu\u1ea7n l\u00e0m vi\u1ec7c. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00f4ng th\u1ee9c, c\u00e1ch d\u00f9ng c\u01a1 b\u1ea3n, […]<\/p>\n","protected":false},"author":1,"featured_media":5439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5438","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\/19480.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5438","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=5438"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5438\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5439"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}