{"id":5484,"date":"2025-11-27T16:12:55","date_gmt":"2025-11-27T09:12:55","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-sqrt-de-tinh-can-bac-2-trong-excel\/"},"modified":"2025-11-27T16:12:55","modified_gmt":"2025-11-27T09:12:55","slug":"cach-su-dung-ham-sqrt-de-tinh-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-sqrt-de-tinh-can-bac-2-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 trong Excel"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m SQRT trong Excel gi\u00fap b\u1ea1n t\u00ednh c\u0103n b\u1eadc hai nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, ph\u00f9 h\u1ee3p cho nhi\u1ec1u b\u00e0i to\u00e1n x\u1eed l\u00fd d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng SQRT, v\u00ed d\u1ee5 minh h\u1ecda, c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ec3 b\u1ea1n thao t\u00e1c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

\"H\u00e0mC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 trong Excel<\/em><\/p>\n

\n

1. C\u00f4ng th\u1ee9c h\u00e0m SQRT trong Excel<\/h2>\n<\/div>\n

H\u00e0m SQRT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng trong Excel. T\u00ean h\u00e0m xu\u1ea5t ph\u00e1t t\u1eeb c\u1ee5m \u201csquare root\u201d, ngh\u0129a l\u00e0 c\u0103n b\u1eadc hai trong ti\u1ebfng Anh.<\/p>\n

C\u00fa ph\u00e1p s\u1eed d\u1ee5ng:<\/strong><\/p>\n

=SQRT(number)<\/p>\n

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

    \n
  • number: <\/strong>Gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c \u00f4 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y c\u0103n b\u1eadc hai.<\/li>\n<\/ul>\n
    \n

    2. C\u00e1ch d\u00f9ng h\u00e0m SQRT c\u0103n b\u1eadc 2 trong Excel<\/h2>\n<\/div>\n

    S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t s\u1ed1. Trong h\u00ecnh minh h\u1ecda, ta d\u00f9ng h\u00e0m SQRT \u0111\u1ec3 l\u1ea5y c\u0103n b\u1eadc hai c\u1ee7a 25 v\u00e0 50.<\/p>\n

      \n
    • V\u1edbi \u00f4 ch\u1ee9a 25, c\u00f4ng th\u1ee9c: =SQRT(25)<\/li>\n
    • V\u1edbi \u00f4 ch\u1ee9a 50, c\u00f4ng th\u1ee9c: =SQRT(50)<\/li>\n<\/ul>\n

      K\u1ebft qu\u1ea3 l\u1ea7n l\u01b0\u1ee3t l\u00e0 5 v\u00e0 7.071067\u2026 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u0103n b\u1eadc hai c\u1ee7a 25 v\u00e0 50.<\/p>\n

      \"T\u00ednhC\u00f4ng th\u1ee9c SQRT t\u00ednh c\u0103n b\u1eadc hai cho s\u1ed1<\/em><\/p>\n

      \n

      3. C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m SQRT v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c<\/h2>\n<\/div>\n

      H\u00e0m SQRT trong Excel s\u1ebd h\u1eefu \u00edch h\u01a1n khi b\u1ea1n k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m x\u1eed l\u00fd s\u1ed1 kh\u00e1c. M\u1ed9t s\u1ed1 h\u00e0m th\u01b0\u1eddng \u0111i k\u00e8m g\u1ed3m ABS, ROUND, ROUNDUP v\u00e0 ROUNDDOWN, gi\u00fap m\u1edf r\u1ed9ng ph\u1ea1m vi s\u1eed d\u1ee5ng trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng t\u00ednh to\u00e1n.<\/p>\n

      \n

      3.1. K\u1ebft h\u1ee3p SQRT v\u1edbi h\u00e0m ABS<\/h3>\n<\/div>\n

      H\u00e0m ABS tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i, nh\u1edd \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y c\u0103n b\u1eadc hai ngay c\u1ea3 khi d\u1eef li\u1ec7u g\u1ed1c l\u00e0 s\u1ed1 \u00e2m.<\/p>\n

        \n
      • C\u00f4ng th\u1ee9c:<\/strong> =SQRT(ABS(A1))<\/li>\n
      • V\u00ed d\u1ee5: <\/strong>N\u1ebfu \u00f4 A1 ch\u1ee9a gi\u00e1 tr\u1ecb -49, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 7, v\u00ec \u221a|\u221249| = \u221a49 = 7.<\/li>\n<\/ul>\n

        \"D\u00f9ngC\u00f4ng th\u1ee9c SQRT k\u00e8m ABS \u0111\u1ec3 l\u1ea5y c\u0103n b\u1eadc hai c\u1ee7a gi\u00e1 tr\u1ecb \u00e2m<\/em><\/p>\n

        \n

        3.2. K\u1ebft h\u1ee3p SQRT v\u1edbi h\u00e0m ROUND<\/h3>\n<\/div>\n

        H\u00e0m ROUND \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb c\u0103n b\u1eadc hai theo s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb.<\/p>\n

          \n
        • C\u00f4ng th\u1ee9c:<\/strong> =ROUND(SQRT(A1), 2)<\/li>\n
        • V\u00ed d\u1ee5: <\/strong>Gi\u1ea3 s\u1eed \u00f4 A1 ch\u1ee9a s\u1ed1 15, khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean, Excel tr\u1ea3 v\u1ec1 3.87 v\u00ec \u221a15 \u2248 3.872983\u2026 v\u00e0 \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<\/ul>\n

          \"K\u1ebftC\u00f4ng th\u1ee9c ROUND k\u1ebft h\u1ee3p SQRT \u0111\u1ec3 l\u00e0m tr\u00f2n c\u0103n b\u1eadc hai<\/em><\/p>\n

          \n

          3.3. K\u1ebft h\u1ee3p SQRT v\u1edbi h\u00e0m ROUNDUP<\/h3>\n<\/div>\n

          H\u00e0m ROUNDUP \u0111\u01b0\u1ee3c d\u00f9ng khi b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n l\u00ean k\u1ebft qu\u1ea3 c\u0103n b\u1eadc hai, c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean ho\u1eb7c s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n t\u00f9y \u00fd.<\/p>\n

            \n
          • C\u00f4ng th\u1ee9c:<\/strong> =ROUNDUP(SQRT(A1), 0)<\/li>\n
          • V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed \u00f4 A1 ch\u1ee9a s\u1ed1 18, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd tr\u1ea3 v\u1ec1 5. Nguy\u00ean nh\u00e2n l\u00e0 \u221a18 \u2248 4.24264\u2026 v\u00e0 khi l\u00e0m tr\u00f2n l\u00ean v\u1edbi tham s\u1ed1 0 (l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean), Excel s\u1ebd cho k\u1ebft qu\u1ea3 l\u00e0 5.<\/li>\n<\/ul>\n

            \"V\u00edH\u00e0m ROUNDUP l\u00e0m tr\u00f2n l\u00ean k\u1ebft qu\u1ea3 t\u1eeb SQRT<\/em><\/p>\n

            Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m FIND, FINDB trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u<\/div>\n
            \n

            3.4. K\u1ebft h\u1ee3p SQRT v\u1edbi h\u00e0m ROUNDDOWN<\/h3>\n<\/div>\n

            H\u00e0m ROUNDDOWN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n xu\u1ed1ng gi\u00e1 tr\u1ecb c\u0103n b\u1eadc hai, \u0111\u01b0a k\u1ebft qu\u1ea3 v\u1ec1 m\u1ee9c th\u1eadp ph\u00e2n ho\u1eb7c s\u1ed1 nguy\u00ean t\u00f9y ch\u1ecdn.<\/p>\n

              \n
            • C\u00f4ng th\u1ee9c: <\/strong>=ROUNDDOWN(SQRT(A1), 0)<\/li>\n
            • V\u00ed d\u1ee5: <\/strong>N\u1ebfu \u00f4 A1 c\u00f3 gi\u00e1 tr\u1ecb 22, Excel s\u1ebd tr\u1ea3 v\u1ec1 4 v\u00ec \u221a22 \u2248 4.69041\u2026 v\u00e0 khi l\u00e0m tr\u00f2n xu\u1ed1ng v\u1edbi tham s\u1ed1 0, k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u1ea5y l\u00e0 4.<\/li>\n<\/ul>\n

              \"V\u00edH\u00e0m ROUNDDOWN l\u00e0m tr\u00f2n xu\u1ed1ng k\u1ebft qu\u1ea3 t\u1eeb SQRT<\/em><\/p>\n

              \n

              4. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p c\u1ee7a h\u00e0m SQRT<\/h2>\n<\/div>\n
              \n

              4.1. L\u1ed7i #NUM!<\/h3>\n<\/div>\n

              \u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p nh\u1ea5t khi d\u00f9ng h\u00e0m SQRT. Nguy\u00ean nh\u00e2n l\u00e0 do b\u1ea1n c\u1ed1 t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m.<\/p>\n

              Ch\u1eb3ng h\u1ea1n, v\u1edbi c\u00f4ng th\u1ee9c: =SQRT(-9)<\/p>\n

              Excel s\u1ebd b\u00e1o #NUM! <\/strong>v\u00ec kh\u00f4ng th\u1ec3 l\u1ea5y c\u0103n b\u1eadc hai c\u1ee7a s\u1ed1 \u00e2m.<\/p>\n

              \"L\u1ed7iL\u1ed7i #NUM! xu\u1ea5t hi\u1ec7n khi t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a s\u1ed1 \u00e2m<\/em><\/p>\n

              C\u00e1ch x\u1eed l\u00fd:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m ABS \u0111\u1ec3 chuy\u1ec3n s\u1ed1 \u00e2m th\u00e0nh gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i tr\u01b0\u1edbc khi t\u00ednh.<\/p>\n

              C\u00f4ng th\u1ee9c thay th\u1ebf: <\/strong>=SQRT(ABS(-9))<\/p>\n

              K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 3, v\u00ec c\u0103n b\u1eadc hai c\u1ee7a 9 b\u1eb1ng 3.<\/p>\n

              \n

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

              L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi h\u00e0m SQRT nh\u1eadn m\u1ed9t \u0111\u1ed1i s\u1ed1 kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp:<\/p>\n

              =SQRT(“text”)<\/p>\n

              Excel s\u1ebd tr\u1ea3 v\u1ec1 #VALUE! <\/strong>v\u00ec kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p c\u0103n b\u1eadc hai cho chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n

              \"L\u1ed7iL\u1ed7i #VALUE! khi SQRT nh\u1eadn d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i s\u1ed1<\/em><\/p>\n

              \u0110\u1ec3 tr\u00e1nh l\u1ed7i, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb d\u00f9ng trong h\u00e0m SQRT l\u00e0 s\u1ed1 h\u1ee3p l\u1ec7, kh\u00f4ng ph\u1ea3i v\u0103n b\u1ea3n hay k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<\/p>\n

              \n

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

              Trong m\u1ed9t s\u1ed1 t\u00ecnh hu\u1ed1ng, h\u00e0m SQRT c\u00f3 th\u1ec3 ph\u00e1t sinh l\u1ed7i do \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3 \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb m\u1ed9t ph\u00e9p chia kh\u00f4ng h\u1ee3p l\u1ec7. Ch\u1eb3ng h\u1ea1n, n\u1ebfu \u00f4 A1 = 12 v\u00e0 \u00f4 B1 = 0, khi b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c:<\/p>\n

              =SQRT(A1\/B1)<\/p>\n

              Excel s\u1ebd tr\u1ea3 v\u1ec1 #DIV\/0!<\/strong>. Nguy\u00ean nh\u00e2n l\u00e0 ph\u00e9p chia 12\/0 kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n, n\u00ean gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o c\u1ee7a SQRT c\u0169ng kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc hai.<\/p>\n

              \"L\u1ed7iL\u1ed7i #DIV\/0! khi SQRT t\u00ednh tr\u00ean ph\u00e9p chia cho 0<\/em><\/p>\n

              N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m SQRT s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian khi l\u00e0m vi\u1ec7c v\u1edbi Excel. N\u1ebfu b\u1ea1n mu\u1ed1n kh\u00e1m ph\u00e1 th\u00eam c\u00e1c th\u1ee7 thu\u1eadt, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft kh\u00e1c, \u0111\u1eebng qu\u00ean gh\u00e9 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\u01b0\u1eddng xuy\u00ean.<\/p>\n

              B\u1ea1n mu\u1ed1n thao t\u00e1c Excel nhanh g\u1ecdn h\u01a1n? Tham kh\u1ea3o ngay c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7u n\u0103ng m\u1ea1nh, m\u00e0n h\u00ecnh l\u1edbn t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c ti\u1ec7n l\u1ee3i h\u01a1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              \u00a0 H\u00e0m SQRT trong Excel gi\u00fap b\u1ea1n t\u00ednh c\u0103n b\u1eadc hai nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, ph\u00f9 h\u1ee3p cho nhi\u1ec1u b\u00e0i to\u00e1n x\u1eed l\u00fd d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng SQRT, v\u00ed d\u1ee5 minh h\u1ecda, c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ec3 […]<\/p>\n","protected":false},"author":1,"featured_media":5485,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5484","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\/19481.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5484","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=5484"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5484\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5485"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}