{"id":5055,"date":"2025-11-21T11:37:09","date_gmt":"2025-11-21T04:37:09","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-dung-ham-rounddown-trong-excel-de-lam-tron-gia-tri\/"},"modified":"2025-11-21T11:37:09","modified_gmt":"2025-11-21T04:37:09","slug":"cach-dung-ham-rounddown-trong-excel-de-lam-tron-gia-tri","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-dung-ham-rounddown-trong-excel-de-lam-tron-gia-tri\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m ROUNDDOWN trong Excel \u0111\u1ec3 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m ROUNDDOWN trong Excel gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 theo h\u01b0\u1edbng gi\u1ea3m, h\u1ed7 tr\u1ee3 t\u1ed1i \u01b0u khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00e0i ch\u00ednh, t\u00ednh to\u00e1n v\u00e0 th\u1ed1ng k\u00ea. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m ROUNDDOWN v\u1edbi c\u00e1c h\u00e0m nh\u01b0 SUM, AVERAGE, IF, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.<\/p>\n

\"C\u00e1chC\u00e1ch d\u00f9ng h\u00e0m ROUNDDOWN trong Excel \u0111\u1ec3 l\u00e0m tr\u00f2n xu\u1ed1ng gi\u00e1 tr\u1ecb<\/em><\/p>\n

\n

1. H\u00e0m ROUNDDOWN l\u00e0 g\u00ec? \u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m ROUNDDOWN<\/h2>\n<\/div>\n

H\u00e0m ROUNDDOWN trong Excel thu\u1ed9c nh\u00f3m h\u00e0m l\u00e0m tr\u00f2n s\u1ed1, c\u00f3 ch\u1ee9c n\u0103ng l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn m\u1ee9c \u0111\u1ed9 ch\u00ednh x\u00e1c m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 lu\u00f4n nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb ban \u0111\u1ea7u, t\u00f9y theo s\u1ed1 ch\u1eef s\u1ed1 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp trong c\u00f4ng th\u1ee9c.<\/p>\n

H\u00e0m ROUNDDOWN <\/strong>\u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u trong th\u1ef1c t\u1ebf, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c ph\u00e9p t\u00ednh c\u1ea7n \u0111\u1ed9 ch\u00ednh x\u00e1c nh\u01b0ng kh\u00f4ng c\u1ea7n chi ti\u1ebft th\u1eadp ph\u00e2n. M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng ti\u00eau bi\u1ec3u g\u1ed3m:<\/p>\n

    \n
  • T\u00ednh to\u00e1n t\u00e0i ch\u00ednh:<\/strong> L\u00e0m tr\u00f2n s\u1ed1 ti\u1ec1n xu\u1ed1ng \u0111\u01a1n v\u1ecb nh\u1ecf h\u01a1n \u0111\u1ec3 d\u1ec5 qu\u1ea3n l\u00fd v\u00e0 tr\u00e1nh sai l\u1ec7ch.<\/li>\n
  • X\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1: <\/strong>Gi\u00fap b\u1ea3ng t\u00ednh g\u1ecdn g\u00e0ng, d\u1ec5 \u0111\u1ecdc h\u01a1n trong b\u00e1o c\u00e1o k\u1ef9 thu\u1eadt ho\u1eb7c b\u00e1n h\u00e0ng.<\/li>\n
  • Th\u1ed1ng k\u00ea v\u00e0 so s\u00e1nh: <\/strong>H\u1ed7 tr\u1ee3 chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u khi c\u1ea7n ph\u00e2n t\u00edch ho\u1eb7c \u0111\u1ed1i chi\u1ebfu k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n

    \"C\u00faC\u00fa ph\u00e1p h\u00e0m ROUNDDOWN trong Excel<\/em><\/p>\n

    Xem th\u00eam: <\/strong>H\u00e0m LARGE trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/div>\n
    \n

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

    2.1. C\u00fa ph\u00e1p h\u00e0m ROUNDDOWN<\/h3>\n<\/div>\n

    C\u00fa ph\u00e1p h\u00e0m ROUNDDOWN: =ROUNDDOWN(number, num_digits)<\/p>\n

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

      \n
    • number: <\/strong>Gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng.<\/li>\n
    • num_digits:<\/strong> S\u1ed1 ch\u1eef s\u1ed1 mu\u1ed1n gi\u1eef l\u1ea1i.\n
        \n
      • N\u1ebfu l\u00e0 s\u1ed1 d\u01b0\u01a1ng<\/strong>, h\u00e0m l\u00e0m tr\u00f2n ph\u1ea7n sau d\u1ea5u th\u1eadp ph\u00e2n<\/strong>.<\/li>\n
      • N\u1ebfu l\u00e0 0<\/strong>, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1 nguy\u00ean<\/strong>.<\/li>\n
      • N\u1ebfu l\u00e0 s\u1ed1 \u00e2m<\/strong>, h\u00e0m l\u00e0m tr\u00f2n xu\u1ed1ng \u1edf b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
        \n

        2.2. K\u1ebft h\u1ee3p h\u00e0m ROUNDDOWN<\/h3>\n<\/div>\n

        H\u00e0m ROUNDDOWN <\/strong>c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 t\u0103ng t\u00ednh linh ho\u1ea1t khi x\u1eed l\u00fd d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch k\u1ebft h\u1ee3p th\u01b0\u1eddng g\u1eb7p:<\/p>\n

          \n
        • V\u1edbi SUM:<\/strong> =ROUNDDOWN(SUM(B2:B4),1) \u2192 T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3 xu\u1ed1ng 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n
        • V\u1edbi AVERAGE:<\/strong> =ROUNDDOWN(AVERAGE(B2:B4),0) \u2192 T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh v\u00e0 l\u00e0m tr\u00f2n xu\u1ed1ng s\u1ed1 nguy\u00ean.<\/li>\n
        • V\u1edbi IF:<\/strong> =IF(B7>100,ROUNDDOWN(B7,0),B7) \u2192 L\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb khi l\u1edbn h\u01a1n 100, ng\u01b0\u1ee3c l\u1ea1i gi\u1eef nguy\u00ean.<\/li>\n<\/ul>\n

          \"K\u1ebftC\u00e1ch k\u1ebft h\u1ee3p h\u00e0m ROUNDDOWN v\u1edbi SUM, AVERAGE, IF<\/em><\/p>\n

          \n

          2.3. V\u00ed d\u1ee5 v\u1ec1 h\u00e0m ROUNDDOWN<\/h3>\n<\/div>\n

          Gi\u1ea3 s\u1eed c\u00f3 gi\u00e1 tr\u1ecb 235.6789 v\u00e0 c\u1ea7n l\u00e0m tr\u00f2n xu\u1ed1ng v\u1edbi c\u00e1c m\u1ee9c ch\u1eef s\u1ed1: 0, 1, 2, 3, -1, -2, -3.<\/p>\n

            \n
          • L\u00e0m tr\u00f2n xu\u1ed1ng s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t:<\/strong> =ROUNDDOWN(235.6789,0)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/strong> =ROUNDDOWN(235.6789,1)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n:<\/strong> =ROUNDDOWN(235.6789,2)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng 3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n: <\/strong>=ROUNDDOWN(235.6789,3)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng h\u00e0ng ch\u1ee5c:<\/strong> =ROUNDDOWN(235.6789,-1)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng h\u00e0ng tr\u0103m: <\/strong>=ROUNDDOWN(235.6789,-2)<\/li>\n
          • L\u00e0m tr\u00f2n xu\u1ed1ng h\u00e0ng ngh\u00ecn:<\/strong> =ROUNDDOWN(235.6789,-3)<\/li>\n<\/ul>\n

            \"V\u00edT\u00ednh h\u00e0m ROUNDDOWN v\u1edbi c\u00e1c m\u1ee9c l\u00e0m tr\u00f2n kh\u00e1c nhau<\/em><\/p>\n

            K\u1ebft qu\u1ea3:<\/strong><\/p>\n

              \n
            • 235.6789 \u2192 235<\/li>\n
            • 235.6789 \u2192 235.6<\/li>\n
            • 235.6789 \u2192 235.67<\/li>\n
            • 235.6789 \u2192 235.678<\/li>\n
            • 235.6789 \u2192 230<\/li>\n
            • 235.6789 \u2192 200<\/li>\n
            • 235.6789 \u2192 0<\/li>\n<\/ul>\n

              \"K\u1ebftK\u1ebft qu\u1ea3 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb b\u1eb1ng h\u00e0m ROUNDDOWN trong Excel<\/em><\/p>\n

              Nh\u01b0 v\u1eady, h\u00e0m ROUNDDOWN <\/strong>gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb xu\u1ed1ng t\u00f9y theo s\u1ed1 ch\u1eef s\u1ed1 ho\u1eb7c c\u1ea5p \u0111\u1ed9 mong mu\u1ed1n trong Excel.<\/p>\n

              \n

              3. So s\u00e1nh h\u00e0m ROUNDDOWN, h\u00e0m ROUND, h\u00e0m ROUNDUP<\/h2>\n<\/div>\n

              Ba h\u00e0m n\u00e0y \u0111\u1ec1u d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong Excel, nh\u01b0ng c\u00e1ch x\u1eed l\u00fd kh\u00e1c nhau:<\/p>\n

                \n
              • ROUND: <\/strong>L\u00e0m tr\u00f2n theo quy t\u1eafc th\u00f4ng th\u01b0\u1eddng, n\u1ebfu ch\u1eef s\u1ed1 l\u00e0m tr\u00f2n nh\u1ecf h\u01a1n 5 th\u00ec l\u00e0m tr\u00f2n xu\u1ed1ng, t\u1eeb 5 tr\u1edf l\u00ean th\u00ec l\u00e0m tr\u00f2n l\u00ean.<\/li>\n
              • ROUNDDOWN: <\/strong>Lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng b\u1ea5t k\u1ec3 ph\u1ea7n th\u1eadp ph\u00e2n.<\/li>\n
              • ROUNDUP: <\/strong>Lu\u00f4n l\u00e0m tr\u00f2n l\u00ean so v\u1edbi gi\u00e1 tr\u1ecb ban \u0111\u1ea7u.<\/li>\n<\/ul>\n

                V\u00ed d\u1ee5:<\/strong> V\u1edbi s\u1ed1 235.6789<\/strong>, v\u00e0 s\u1ed1 ch\u1eef s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n l\u1ea7n l\u01b0\u1ee3t l\u00e0 0<\/strong>, 1<\/strong>, 2<\/strong>, -1<\/strong>, -2<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u1ea3 ba h\u00e0m \u0111\u1ec3 th\u1ea5y r\u00f5 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang.<\/p>\n

                \"S\u1ef1So s\u00e1nh s\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m ROUND, ROUNDDOWN v\u00e0 ROUNDUP<\/em><\/p>\n

                H\u00e0m ROUNDDOWN l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n thao t\u00e1c s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n khi l\u00e0m vi\u1ec7c v\u1edbi Excel. \u0110\u1ec3 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u m\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt tin h\u1ecdc hay m\u1ed7i ng\u00e0y, 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 b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c, h\u1ecdc t\u1eadp ho\u1eb7c x\u1eed l\u00fd d\u1eef li\u1ec7u Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng ho\u1eb7c \u0111i\u1ec7n tho\u1ea1i c\u1ea5u h\u00ecnh m\u1ea1nh s\u1ebd gi\u00fap thao t\u00e1c nhanh v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n. Kh\u00e1m ph\u00e1 ngay c\u00e1c s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng, gi\u00e1 \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 tr\u1ea3i nghi\u1ec7m hi\u1ec7u qu\u1ea3 v\u01b0\u1ee3t tr\u1ed9i m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                \u00a0 H\u00e0m ROUNDDOWN trong Excel gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 theo h\u01b0\u1edbng gi\u1ea3m, h\u1ed7 tr\u1ee3 t\u1ed1i \u01b0u khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u00e0i ch\u00ednh, t\u00ednh to\u00e1n v\u00e0 th\u1ed1ng k\u00ea. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m ROUNDDOWN v\u1edbi c\u00e1c h\u00e0m nh\u01b0 SUM, AVERAGE, IF, k\u00e8m v\u00ed d\u1ee5 minh […]<\/p>\n","protected":false},"author":1,"featured_media":5056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5055","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\/19407.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5055","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=5055"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5055\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5056"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}