{"id":24365,"date":"2021-05-11T09:49:27","date_gmt":"2021-05-11T02:49:27","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24365"},"modified":"2021-08-12T15:15:56","modified_gmt":"2021-08-12T08:15:56","slug":"ham-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-can-bac-2-trong-excel\/","title":{"rendered":"H\u00e0m c\u0103n b\u1eadc 2 trong Excel: C\u00f4ng th\u1ee9c v\u00e0 V\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"<p><strong>H\u00e0m c\u0103n b\u1eadc 2<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel l\u00e0 h\u00e0m SQRT. H\u00e0m Excel n\u00e0y \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u0111\u1ea7u ti\u00ean tr\u00ean Excel 2010 v\u00e0 \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m to\u00e1n h\u1ecdc, \u0111\u01b0\u1ee3c s\u1eed \u0111\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 d\u01b0\u01a1ng. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u chi ti\u1ebft cho b\u1ea1n v\u1ec1 c\u00fa ph\u00e1p <strong>h\u00e0m c\u0103n b\u1eadc 2 trong Excel SQRT<\/strong> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y.<\/p>\n<h2><strong>H\u00e0m c\u0103n b\u1eadc 2 trong Excel<\/strong><\/h2>\n<p>H\u00e0m SQRT trong Excel l\u00e0 h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 trong b\u1ea3ng t\u00ednh Excel. B\u00ean c\u1ea1nh \u0111\u00f3 h\u00e0m SQRTPI c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 nh\u00e2n v\u1edbi s\u1ed1 pi.<\/p>\n<h3><strong>C\u00f4ng th\u1ee9c h\u00e0m SQRT trong Excel<\/strong><\/h3>\n<p>C\u00fa ph\u00e1p h\u00e0m SQRT, h\u00e0m c\u0103n b\u1eadc 2 trong Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=SQRT(number)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3 h\u00e0m SQRT s\u1eed d\u1ee5ng tham s\u1ed1:<\/p>\n<p><strong>\u2013 Number<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 s\u1ed1 m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ecm c\u0103n b\u1eadc hai. Tham s\u1ed1 n\u00e0y ph\u1ea3i l\u00e0 s\u1ed1 th\u1ef1c d\u01b0\u01a1ng, n\u1ebfu kh\u00f4ng h\u00e0m Excel c\u0103n b\u1eadc 2 s\u1ebd tr\u1ea3 v\u1ec1 th\u00f4ng b\u00e1o l\u1ed7i.<\/p>\n<h3><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 trong Excel<\/strong><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u0111\u1ec3 b\u1ea1n d\u1ec5 h\u00ecnh dung c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SQRT, h\u00e0m c\u0103n b\u1eadc 2 trong Excel:<\/p>\n<p><strong>V\u00ed d\u1ee5 1<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed cho c\u00e1c gi\u00e1 tr\u1ecb sau \u0111\u00e2y, nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c s\u1ed1, c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y l\u1ea7n l\u01b0\u1ee3t l\u00e0: 25,\u00a049, 900, 121, 100.<\/p>\n<p>C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c h\u00e0m c\u0103n b\u1eadc 2 Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><strong>= SQRT(tham chi\u1ebfu).<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"296\" class=\"aligncenter wp-image-17467 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-22.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-22-300x182.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-22.png 487w\" alt=\"1 22 - C\u00fa ph\u00e1p h\u00e0m c\u0103n b\u1eadc 2 trong Excel - Ben Computer\" \/><\/p>\n<p><strong>V\u00ed d\u1ee5 2<\/strong><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu tham s\u1ed1 number hay s\u1ed1 m\u00e0 ch\u00fang ta c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 l\u00e0 m\u1ed9t s\u1ed1 \u00e2m th\u00ec h\u00e0m SQRT s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i l\u00e0 #NUM!. \u0110i\u1ec1u n\u00e0y l\u00e0 b\u1edfi v\u00ec c\u0103n b\u1eadc c\u1ee7a m\u1ed9t s\u1ed1 \u00e2m kh\u00f4ng t\u1ed3n t\u1ea1i.<\/p>\n<p>Tuy nhi\u00ean ch\u00fang ta c\u00f3 th\u1ec3 l\u1ea5y c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 \u00e2m nh\u01b0 th\u1ec3 n\u00f3 l\u00e0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ABS.<\/p>\n<p>Gi\u1ea3 s\u1eed cho d\u1eef li\u1ec7u nh\u01b0 trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"148\" class=\"aligncenter wp-image-17468 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-19.png\" alt=\"2 19 - C\u00fa ph\u00e1p h\u00e0m c\u0103n b\u1eadc 2 trong Excel - Ben Computer\" \/><\/p>\n<p>\u0110\u1ec3 t\u00ecm c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m SQRT c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:\u00a0<strong>= SQRT(ABS (ref)):<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"252\" class=\"aligncenter wp-image-17469 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-16.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-16-300x133.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-16.jpg 568w\" alt=\"3 16 - C\u00fa ph\u00e1p h\u00e0m c\u0103n b\u1eadc 2 trong Excel - Ben Computer\" \/><\/p>\n<p>Khi \u0111\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"295\" class=\"aligncenter wp-image-17470 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-13.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-13-300x161.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-13.jpg 549w\" alt=\"4 13 - C\u00fa ph\u00e1p h\u00e0m c\u0103n b\u1eadc 2 trong Excel - Ben Computer\" \/><\/p>\n<h3><strong>H\u00e0m SQRTPI trong Excel<\/strong><\/h3>\n<p>H\u00e0m SQRTPI trong Excel t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m SQRT, ch\u1ec9 c\u00f3 \u0111i\u1ec1u h\u00e0m SQRTPI nh\u00e2n th\u00eam v\u1edbi s\u1ed1 pi \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SQRTPI c\u0169ng t\u01b0\u01a1ng t\u1ef1 h\u00e0m SQRT.<\/p>\n<h3><strong>Vi\u1ebft s\u1ed1 m\u0169 trong Excel<\/strong><\/h3>\n<p>C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 vi\u1ebft s\u1ed1 m\u0169 trong b\u1ea3ng t\u00ednh Excel l\u00e0 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft. Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>M\u0169 2:<\/strong> Nh\u1ea5n v\u00e0 gi\u1eef \u0111\u1ed3ng th\u1eddi c\u00e1c ph\u00edm: <strong>Alt+ 0 + 1 + 7 + 8.<\/strong><\/li>\n<li><strong>M\u0169 3:<\/strong> Nh\u1ea5n v\u00e0 gi\u1eef \u0111\u1ed3ng th\u1eddi c\u00e1c ph\u00edm: <strong>Alt+ 0 + 1 + 7 + 9.<\/strong><\/li>\n<\/ul>\n<h2><strong>H\u00e0m POWER t\u00ednh c\u0103n b\u1eadc 2<\/strong><\/h2>\n<p>Ngo\u00e0i h\u00e0m SQRT, Excel c\u00f2n \u0111\u01b0\u1ee3c b\u1ed5 sung th\u00eam h\u00e0m Power, c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 trong b\u1ea3ng t\u00ednh.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m c\u0103n b\u1eadc 2 Power trong Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>= POWER (s\u1ed1 n, power)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>Tham s\u1ed1 \u0111\u1ea7u ti\u00ean <strong>(s\u1ed1 n)<\/strong>\u00a0c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 th\u1ef1c ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u1ea7n t\u00ednh.<\/li>\n<li>Tham s\u1ed1<strong>\u00a0power<\/strong>\u00a0l\u00e0 l\u0169y th\u1eeba, s\u1ed1 m\u0169 m\u00e0 s\u1ed1 n \u0111\u01b0\u1ee3c n\u00e2ng l\u00ean.<\/li>\n<\/ul>\n<p>H\u00e0m Power tr\u1ea3 v\u1ec1 l\u1ed7i #NUM n\u1ebfu m\u1ed9t trong s\u1ed1 c\u00e1c tham s\u1ed1 m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng l\u00e0 s\u1ed1 \u00e2m.<\/p>\n<p>Kh\u00e1c v\u1edbi SQRT, h\u00e0m Power Excel c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2, c\u0103n b\u1eadc 3 v\u00e0 th\u1eadm ch\u00ed l\u00e0 c\u0103n b\u1eadc N.<\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 trong Excel<\/strong><\/h2>\n<ol>\n<li>H\u00e0m SRQT tr\u1ea3 v\u1ec1 l\u1ed7i #NUM! n\u1ebfu tham s\u1ed1, s\u1ed1 c\u1ea7n t\u00ecm c\u0103n b\u1eadc 2 \u0111\u00e3 cho l\u00e0 m\u1ed9t s\u1ed1 \u00e2m.<\/li>\n<li>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SQRT k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c nh\u01b0 ABS, ROUND, ROUNDUP v\u00e0 ROUNDDOWN.<\/li>\n<li>H\u00e0m SQRT v\u1ec1 c\u01a1 b\u1ea3n ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 h\u00e0m POWER, ch\u1ec9 c\u00f3 \u0111i\u1ec1u h\u00e0m POWER ho\u1ea1t \u0111\u1ed9ng nh\u01b0 s\u1ed1 m\u0169 trong ph\u01b0\u01a1ng tr\u00ecnh to\u00e1n h\u1ecdc.<\/li>\n<\/ol>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t t\u1ea7n t\u1eadt c\u00fa ph\u00e1p <strong>h\u00e0m c\u0103n b\u1eadc 2 trong Excel<\/strong> c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o. Hy v\u1ecdng sau b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y c\u1ee7a Ben Computer s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c h\u00e0m Excel n\u00e0y.<\/p>\n<p><span style=\"font-size: 14pt\"><strong>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7 \u0111\u1ec1:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-countifs-trong-excel\/\">H\u00e0m Countifs trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-dsum-trong-excel\/\">H\u00e0m Dsum trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-average-trong-excel\/\">H\u00e0m Average trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-right-trong-excel\/\">H\u00e0m Right trong Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m c\u0103n b\u1eadc 2 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel l\u00e0 h\u00e0m SQRT. H\u00e0m Excel n\u00e0y \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u0111\u1ea7u ti\u00ean tr\u00ean Excel 2010 v\u00e0 \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m to\u00e1n h\u1ecdc, \u0111\u01b0\u1ee3c s\u1eed \u0111\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 d\u01b0\u01a1ng. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u chi [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24366,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24365"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24366"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}