{"id":288344,"date":"2023-12-05T21:21:08","date_gmt":"2023-12-05T14:21:08","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=288344"},"modified":"2025-10-08T14:20:24","modified_gmt":"2025-10-08T07:20:24","slug":"ham-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &#038; V\u00ed D\u1ee5"},"content":{"rendered":"<p>Vi\u1ec7c t\u00ednh c\u0103n b\u1eadc 2 l\u00e0 m\u1ed9t nhu c\u1ea7u ph\u1ed5 bi\u1ebfn trong c\u00e1c t\u00e1c v\u1ee5 t\u1eeb t\u00e0i ch\u00ednh, k\u1ef9 thu\u1eadt \u0111\u1ebfn th\u1ed1ng k\u00ea. Microsoft Excel cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p hi\u1ec7u qu\u1ea3.<\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd l\u00e0 c\u1ea9m nang to\u00e0n t\u1eadp, h\u01b0\u1edbng d\u1eabn b\u1ea1n\u00a0<strong>t\u1eeb A-Z v\u1ec1 c\u0103n b\u1eadc 2 trong Excel<\/strong>. Ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u kh\u00f4ng ch\u1ec9 m\u1ed9t, m\u00e0 l\u00e0 nhi\u1ec1u c\u00e1ch t\u00ednh kh\u00e1c nhau t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao: s\u1eed d\u1ee5ng h\u00e0m\u00a0SQRT, h\u00e0m\u00a0POWER, c\u00f4ng th\u1ee9c m\u0169, v\u00e0 c\u1ea3 Power Query. B\u00ean c\u1ea1nh \u0111\u00f3, b\u00e0i vi\u1ebft c\u0169ng ch\u1ec9 ra c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 nh\u1eefng m\u1eb9o h\u1eefu \u00edch nh\u01b0 c\u00e1ch ch\u00e8n k\u00fd hi\u1ec7u c\u0103n (\u221a) v\u00e0o trang t\u00ednh. H\u00e3y c\u00f9ng b\u1eaft \u0111\u1ea7u!<\/p>\n<h2><b>H\u00e0m c\u0103n b\u1eadc 2 trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m SQRT trong Excel \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m c\u0103n b\u1eadc 2 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 kh\u00f4ng \u00e2m. Khi \u00e1p d\u1ee5ng h\u00e0m n\u00e0y, Excel s\u1ebd t\u00ednh to\u00e1n m\u0169 1\/2 c\u1ee7a s\u1ed1 \u0111\u00f3 v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 gi\u00e1 tr\u1ecb c\u0103n b\u1eadc 2 t\u01b0\u01a1ng \u1ee9ng. C\u00f4ng d\u1ee5ng ch\u00ednh c\u1ee7a h\u00e0m n\u00e0y l\u00e0 gi\u00fap b\u1ea1n t\u00ednh to\u00e1n d\u1ec5 d\u00e0ng c\u00e1c gi\u00e1 tr\u1ecb c\u0103n b\u1eadc 2 trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m c\u0103n b\u1eadc 2 SQRT trong Excel nh\u01b0 sau: <\/span><b>SQRT(number)<\/b><span style=\"font-weight: 400;\">. Trong \u0111\u00f3 <\/span><b>number<\/b><span style=\"font-weight: 400;\"> l\u00e0 s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2.<\/span><\/p>\n<p><b>V\u00ed d\u1ee5<\/b><span style=\"font-weight: 400;\">, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a s\u1ed1 9, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau: <\/span><b>=SQRT(9)<\/b><span style=\"font-weight: 400;\">. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <\/span><b>3<\/b><span style=\"font-weight: 400;\">, v\u00ec c\u0103n b\u1eadc 2 c\u1ee7a 9 l\u00e0 3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-292378 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>L\u01b0u \u00fd:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m SQRT ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0a v\u00e0o l\u00e0 s\u1ed1 th\u1ef1c d\u01b0\u01a1ng. N\u1ebfu b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb \u00e2m v\u00e0o h\u00e0m, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i <\/span><b>#NUM!<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi ph\u1ea7n <\/span><b>Number<\/b><span style=\"font-weight: 400;\"> b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n tr\u1ef1c ti\u1ebfp m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 th\u1ef1c d\u01b0\u01a1ng ch\u1eb3ng h\u1ea1n 4,9,36,&#8230; ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn \u0111\u01b0a v\u00e0o \u0111\u1ecba ch\u1ec9 c\u1ee7a m\u1ed9t \u00f4 t\u00ednh c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadn k\u1ebft qu\u1ea3 c\u0103n b\u1eadc 2.<\/span><\/li>\n<\/ul>\n<h2><b>L\u1ee3i \u00edch khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 (SQRT) trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 trong Excel mang \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi s\u1ed1 li\u1ec7u v\u00e0 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n to\u00e1n h\u1ecdc ph\u1ee9c t\u1ea1p. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m n\u00e0y:<\/span><\/p>\n<p><b>Gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n nhanh g\u1ecdn v\u1edbi con s\u1ed1 c\u0103n b\u1eadc 2 l\u1edbn:<\/b><span style=\"font-weight: 400;\"> Khi g\u1eb7p ph\u1ea3i c\u00e1c gi\u00e1 tr\u1ecb c\u0103n b\u1eadc 2 l\u1edbn, vi\u1ec7c t\u00ednh to\u00e1n b\u1eb1ng tay c\u00f3 th\u1ec3 tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p v\u00e0 m\u1ea5t th\u1eddi gian. S\u1eed d\u1ee5ng h\u00e0m SQRT trong Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c s\u1ed1 l\u1edbn m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-292384 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>Hi\u1ec7u qu\u1ea3 h\u01a1n khi gi\u1ea3i quy\u1ebft b\u00e0i t\u1eadp li\u00ean quan:<\/b><span style=\"font-weight: 400;\"> \u0110\u1ed1i v\u1edbi c\u00e1c b\u00e0i t\u1eadp to\u00e1n li\u00ean quan \u0111\u1ebfn c\u0103n b\u1eadc 2, s\u1eed d\u1ee5ng h\u00e0m SQRT trong Excel gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c v\u00e0 t\u00ednh to\u00e1n c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, gi\u00fap b\u1ea1n ho\u00e0n th\u00e0nh b\u00e0i t\u1eadp nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/span><\/p>\n<p><b>\u00c1p d\u1ee5ng tr\u1ef1c ti\u1ebfp, kh\u00f4ng c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m:<\/b><span style=\"font-weight: 400;\"> H\u00e0m SQRT trong Excel cho ph\u00e9p b\u1ea1n t\u00ednh to\u00e1n c\u0103n b\u1eadc 2 tr\u1ef1c ti\u1ebfp v\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p v\u1edbi b\u1ea5t k\u1ef3 h\u00e0m n\u00e0o kh\u00e1c. B\u1ea1n ch\u1ec9 c\u1ea7n cung c\u1ea5p s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c, gi\u00fap \u0111\u01a1n gi\u1ea3n h\u00f3a quy tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 t\u0103ng c\u01b0\u1eddng hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h2>C\u00e1c C\u00e1ch T\u00ednh C\u0103n B\u1eadc 2 Trong Excel (K\u00e8m v\u00ed d\u1ee5)<\/h2>\n<p>T\u00f9y v\u00e0o nhu c\u1ea7u v\u00e0 lo\u1ea1i d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc hai trong Excel.<\/p>\n<h4>2.1. S\u1eed d\u1ee5ng h\u00e0m SQRT &#8211; Ph\u1ed5 bi\u1ebfn nh\u1ea5t<\/h4>\n<p>\u0110\u00e2y l\u00e0 h\u00e0m chuy\u00ean d\u1ee5ng v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng nh\u1ea5t \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc hai.<\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0=SQRT(number)<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-292370 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li><strong>Trong \u0111\u00f3:<\/strong>\u00a0number\u00a0l\u00e0 s\u1ed1 kh\u00f4ng \u00e2m c\u1ea7n t\u00ednh c\u0103n. S\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4.<\/li>\n<li><strong>V\u00ed d\u1ee5:<\/strong>\u00a0\u0110\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a s\u1ed1 trong \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0=SQRT(A2).<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-292371 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li><strong>L\u01b0u \u00fd v\u1edbi s\u1ed1 \u00e2m:<\/strong>\u00a0N\u1ebfu\u00a0number\u00a0l\u00e0 s\u1ed1 \u00e2m, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i\u00a0#NUM!. \u0110\u1ec3 t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i (b\u1ecf qua d\u1ea5u \u00e2m), h\u00e3y k\u1ebft h\u1ee3p v\u1edbi h\u00e0m ABS:\u00a0=SQRT(ABS(A2)).<\/li>\n<\/ul>\n<h4>2.2. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c M\u0169 (L\u0169y th\u1eeba 1\/2) &#8211; Linh ho\u1ea1t<\/h4>\n<p>V\u1ec1 m\u1eb7t to\u00e1n h\u1ecdc, c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t s\u1ed1 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi vi\u1ec7c n\u00e2ng s\u1ed1 \u0111\u00f3 l\u00ean l\u0169y th\u1eeba 1\/2. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y r\u1ea5t linh ho\u1ea1t v\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ednh c\u00e1c c\u0103n b\u1eadc kh\u00e1c (b\u1eadc 3, b\u1eadc 4&#8230;) b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i s\u1ed1 m\u0169.<\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0=number^(1\/2)<\/li>\n<li><strong>V\u00ed d\u1ee5:<\/strong>\u00a0\u0110\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0=A2^(1\/2).<\/li>\n<li><strong>M\u1edf r\u1ed9ng:<\/strong>\u00a0\u0110\u1ec3 t\u00ednh c\u0103n b\u1eadc 3 c\u1ee7a \u00f4 A2, d\u00f9ng:\u00a0=A2^(1\/3).<\/li>\n<\/ul>\n<h4>2.3. S\u1eed d\u1ee5ng h\u00e0m POWER &#8211; T\u01b0\u01a1ng t\u1ef1 c\u00f4ng th\u1ee9c M\u0169<\/h4>\n<p>H\u00e0m\u00a0POWER\u00a0c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 to\u00e1n t\u1eed m\u0169 (^), gi\u00fap n\u00e2ng m\u1ed9t s\u1ed1 l\u00ean m\u1ed9t l\u0169y th\u1eeba cho tr\u01b0\u1edbc.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-292374 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0=POWER(number, power)<\/li>\n<li><strong>V\u00ed d\u1ee5:<\/strong>\u00a0\u0110\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a \u00f4 A2, d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0=POWER(A2, 1\/2).<\/li>\n<\/ul>\n<h4>2.4. S\u1eed d\u1ee5ng Power Query &#8211; D\u00e0nh cho d\u1eef li\u1ec7u l\u1edbn (N\u00e2ng cao)<\/h4>\n<p>Khi b\u1ea1n c\u1ea7n t\u00ednh c\u0103n b\u1eadc hai cho c\u1ea3 m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u l\u1edbn v\u00e0 mu\u1ed1n qu\u00e1 tr\u00ecnh n\u00e0y t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, Power Query l\u00e0 c\u00f4ng c\u1ee5 l\u00fd t\u01b0\u1edfng.<\/p>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, v\u00e0o tab\u00a0<strong>Data<\/strong>\u00a0&gt;\u00a0<strong>From Table\/Range<\/strong>.<\/li>\n<li>Trong c\u1eeda s\u1ed5 Power Query Editor, ch\u1ecdn c\u1ed9t ch\u1ee9a s\u1ed1 c\u1ea7n t\u00ednh c\u0103n.<\/li>\n<li>V\u00e0o tab\u00a0<strong>Transform<\/strong>, nh\u00f3m\u00a0<strong>Number Column<\/strong>, ch\u1ecdn\u00a0<strong>Scientific<\/strong>\u00a0&gt;\u00a0<strong>Square Root<\/strong>.<\/li>\n<li>M\u1ed9t c\u1ed9t m\u1edbi v\u1edbi k\u1ebft qu\u1ea3 c\u0103n b\u1eadc hai s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o ra.<\/li>\n<li>Nh\u1ea5n\u00a0<strong>Close &amp; Load<\/strong>\u00a0\u0111\u1ec3 \u0111\u01b0a k\u1ebft qu\u1ea3 tr\u1edf l\u1ea1i trang t\u00ednh Excel.<\/li>\n<\/ol>\n<h3><b>S\u1eed d\u1ee5ng h\u00e0m SQRTPI t\u00ednh c\u0103n b\u1eadc 2 trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m c\u0103n b\u1eadc 2 trong Excel SQRT, h\u00e0m SQRTPI c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u01b0\u01a1ng t\u1ef1, tuy nhi\u00ean, h\u00e0m SQRTPI c\u00f3 th\u00eam s\u1ed1 pi v\u00e0o k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng h\u00e0m SQRTPI trong Excel t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SQRT. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m theo c\u00fa ph\u00e1p sau: <\/span><b>=SQRTPI(\u0111\u1ecba ch\u1ec9 \u00f4). <\/b><span style=\"font-weight: 400;\">Trong \u0111\u00f3, \u0111\u1ecba ch\u1ec9 \u00f4 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 nh\u00e2n th\u00eam s\u1ed1 pi v\u00e0o k\u1ebft qu\u1ea3.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-292376 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a s\u1ed1 4, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau: =SQRTPI(A1). Trong \u0111\u00f3, A1 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb 4. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 2\u03c0, v\u00ec c\u0103n b\u1eadc 2 c\u1ee7a 4 nh\u00e2n th\u00eam s\u1ed1 pi l\u00e0 2\u03c0. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m SQRT, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m SQRTPI cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi s\u1ed1 9: =SQRTPI(A2) (k\u1ebft qu\u1ea3 = 3\u03c0).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi s\u1ed1 16: =SQRTPI(A3) (k\u1ebft qu\u1ea3 = 4\u03c0).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi s\u1ed1 25: =SQRTPI(A4) (k\u1ebft qu\u1ea3 = 5\u03c0).<\/span><\/li>\n<\/ul>\n<h2><b>K\u1ebft h\u1ee3p h\u00e0m SQRT v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m c\u0103n b\u1eadc 2 trong Excel SQRT v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c nh\u01b0 ROUND, ROUNDUP, ABS hay ROUNDDOWN \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng k\u1ebft qu\u1ea3 theo \u00fd mu\u1ed1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SQRT k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c:<\/span><\/p>\n<p><b>H\u00e0m ABS:<\/b><span style=\"font-weight: 400;\"> H\u00e0m ABS \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a m\u1ed9t s\u1ed1. B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m ABS v\u00e0 h\u00e0m SQRT. V\u00ed d\u1ee5: =SQRT(ABS(A1)). Trong \u0111\u00f3, A1 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i.<\/span><\/p>\n<p><b>H\u00e0m ROUND:<\/b><span style=\"font-weight: 400;\"> H\u00e0m ROUND \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n x\u00e1c \u0111\u1ecbnh. B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m SQRT v\u1edbi h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3 c\u1ee7a c\u0103n b\u1eadc 2. V\u00ed d\u1ee5: =ROUND(SQRT(A1), 2). Trong \u0111\u00f3, A1 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 2 l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-292377 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>H\u00e0m ROUNDUP:<\/b><span style=\"font-weight: 400;\"> H\u00e0m ROUNDUP \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c s\u1ed1 th\u1eadp ph\u00e2n x\u00e1c \u0111\u1ecbnh. V\u00ed d\u1ee5: =ROUNDUP(SQRT(A1), 0). Trong \u0111\u00f3, A1 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 0 l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/p>\n<p><b>H\u00e0m ROUNDDOWN:<\/b><span style=\"font-weight: 400;\"> H\u00e0m ROUNDDOWN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t ho\u1eb7c s\u1ed1 th\u1eadp ph\u00e2n x\u00e1c \u0111\u1ecbnh. V\u00ed d\u1ee5: =ROUNDDOWN(SQRT(A1), 0). Trong \u0111\u00f3, A1 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 0 l\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/p>\n<h2>\u00a0M\u1eb9o: C\u00e1ch G\u00f5\/Ch\u00e8n K\u00fd Hi\u1ec7u C\u0103n B\u1eadc Hai (\u221a) V\u00e0o Excel<\/h2>\n<p>\u0110\u00f4i khi b\u1ea1n c\u1ea7n hi\u1ec3n th\u1ecb k\u00fd hi\u1ec7u c\u0103n b\u1eadc hai trong \u00f4 t\u00ednh cho m\u1ee5c \u0111\u00edch tr\u00ecnh b\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 3 c\u00e1ch \u0111\u01a1n gi\u1ea3n:<\/p>\n<ul>\n<li><strong>C\u00e1ch 1: D\u00f9ng ph\u00edm t\u1eaft Alt:<\/strong>\u00a0Nh\u1ea5n gi\u1eef ph\u00edm\u00a0Alt\u00a0v\u00e0 g\u00f5\u00a0251\u00a0tr\u00ean b\u00e0n ph\u00edm s\u1ed1 (Numpad).<\/li>\n<li><strong>C\u00e1ch 2: D\u00f9ng h\u00e0m UNICHAR:<\/strong>\u00a0G\u00f5 c\u00f4ng th\u1ee9c\u00a0=UNICHAR(8730)\u00a0v\u00e0o m\u1ed9t \u00f4.<\/li>\n<li><strong>C\u00e1ch 3: D\u00f9ng menu Symbol:<\/strong>\u00a0V\u00e0o tab\u00a0<strong>Insert<\/strong>\u00a0&gt;\u00a0<strong>Symbol<\/strong>. Trong h\u1ed9p tho\u1ea1i, ch\u1ecdn font ch\u1eef &#8220;Symbol&#8221; v\u00e0 t\u00ecm k\u00fd hi\u1ec7u \u221a, sau \u0111\u00f3 nh\u1ea5n\u00a0<strong>Insert<\/strong>.<\/li>\n<\/ul>\n<h2><b>C\u1ea7n l\u01b0u \u00fd g\u00ec khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 (SQRT) trong Excel, c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh c\u00e1c l\u1ed7i kh\u00f4ng mong mu\u1ed1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec3m quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2:<\/span><\/p>\n<p><b>S\u1ed1 d\u01b0\u01a1ng v\u00e0 s\u1ed1 \u00e2m:<\/b><span style=\"font-weight: 400;\"> H\u00e0m c\u0103n b\u1eadc 2 trong Excel ch\u1ec9 ch\u1ea5p nh\u1eadn t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a c\u00e1c s\u1ed1 kh\u00f4ng \u00e2m (d\u01b0\u01a1ng ho\u1eb7c b\u1eb1ng 0). N\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 \u00e2m, Excel s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #NUM!. V\u00ec v\u1eady, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n ch\u1ec9 s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 cho c\u00e1c s\u1ed1 kh\u00f4ng \u00e2m.<\/span><\/p>\n<p><b>\u0110\u1ecbnh d\u1ea1ng k\u1ebft qu\u1ea3:<\/b><span style=\"font-weight: 400;\"> Khi s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng \u00f4 k\u1ebft qu\u1ea3 c\u00f3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00edch h\u1ee3p. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n kh\u00f4ng ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n.<\/span><\/p>\n<p><b>Ki\u1ec3m tra k\u1ebft qu\u1ea3:<\/b><span style=\"font-weight: 400;\"> Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m c\u0103n b\u1eadc 2 trong Excel, h\u00e3y ki\u1ec3m tra k\u1ef9 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c. So s\u00e1nh k\u1ebft qu\u1ea3 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 bi\u1ebft tr\u01b0\u1edbc ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c \u0111\u1ec3 x\u00e1c nh\u1eadn t\u00ednh \u0111\u00fang \u0111\u1eafn.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-292379 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21.jpg\" alt=\"ham-can-bac-2-trong-excel-la-gi-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>C\u00e1c L\u1ed7i Th\u01b0\u1eddng G\u1eb7p Khi T\u00ednh C\u0103n B\u1eadc 2 v\u00e0 C\u00e1ch Kh\u1eafc Ph\u1ee5c<\/h2>\n<ul>\n<li><strong>L\u1ed7i\u00a0#NUM!:<\/strong>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n:<\/strong>\u00a0X\u1ea3y ra khi b\u1ea1n c\u1ed1 g\u1eafng t\u00ednh c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t\u00a0<strong>s\u1ed1 \u00e2m<\/strong>.<\/li>\n<li><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong>\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh c\u0103n c\u1ee7a gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i, h\u00e3y l\u1ed3ng h\u00e0m\u00a0ABS\u00a0v\u00e0o b\u00ean trong:\u00a0=SQRT(ABS(A2)). N\u1ebfu kh\u00f4ng, h\u00e3y ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o.<\/li>\n<\/ul>\n<\/li>\n<li><strong>L\u1ed7i\u00a0#VALUE!:<\/strong>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n:<\/strong>\u00a0X\u1ea3y ra khi \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t s\u1ed1 (v\u00ed d\u1ee5: m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 &#8220;abc&#8221;).<\/li>\n<li><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong>\u00a0\u0110\u1ea3m b\u1ea3o \u00f4 tham chi\u1ebfu ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m\u00a0ISNUMBER\u00a0\u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u tr\u01b0\u1edbc khi t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><b>T\u1ea1m k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, h\u00e0m c\u0103n b\u1eadc 2 (SQRT) trong Excel kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n h\u1eefu \u00edch m\u00e0 c\u00f2n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1. Qua v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a t\u1eebng tr\u01b0\u1eddng h\u1ee3p m\u00e0<\/span><a href=\"https:\/\/hoanghamobile.com\/\"> <span style=\"font-weight: 400;\">Ho\u00e0ng H\u00e0 Mobile<\/span><\/a><span style=\"font-weight: 400;\"> \u0111\u00e3 t\u1ed5ng h\u1ee3p trong b\u00e0i vi\u1ebft tr\u00ean, ch\u00fang ta \u0111\u00e3 th\u1ea5y r\u00f5 s\u1ef1 linh ho\u1ea1t v\u00e0 t\u00ednh \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y trong vi\u1ec7c gi\u1ea3i quy\u1ebft c\u00e1c v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn con s\u1ed1. Vi\u1ec7c hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc 2 trong Excel gi\u00fap ch\u00fang ta t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c, gi\u1ea3i quy\u1ebft c\u00e1c nhi\u1ec7m v\u1ee5 t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p v\u00e0 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-trim\/\"><b>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRIM trong Excel c\u00f3 v\u00ed d\u1ee5 minh ho\u1ea1<\/b><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-concatenate\/\"><b>C\u00e1ch d\u00f9ng h\u00e0m CONCATENATE trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft<\/b><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Vi\u1ec7c t\u00ednh c\u0103n b\u1eadc 2 l\u00e0 m\u1ed9t nhu c\u1ea7u ph\u1ed5 bi\u1ebfn trong c\u00e1c t\u00e1c v\u1ee5 t\u1eeb t\u00e0i ch\u00ednh, k\u1ef9 thu\u1eadt \u0111\u1ebfn th\u1ed1ng k\u00ea. Microsoft Excel cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3i quy\u1ebft c\u00e1c [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":292368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-288344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 C\u00e1ch T\u00ednh C\u0103n B\u1eadc 2 Trong Excel (SQRT, POWER,...) &amp; X\u1eed L\u00fd L\u1ed7i Chi Ti\u1ebft<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &amp; V\u00ed D\u1ee5\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-05T14:21:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-08T07:20:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98\"},\"headline\":\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &#038; V\u00ed D\u1ee5\",\"datePublished\":\"2023-12-05T14:21:08+00:00\",\"dateModified\":\"2025-10-08T07:20:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\"},\"wordCount\":3081,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\",\"name\":\"5 C\u00e1ch T\u00ednh C\u0103n B\u1eadc 2 Trong Excel (SQRT, POWER,...) & X\u1eed L\u00fd L\u1ed7i Chi Ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg\",\"datePublished\":\"2023-12-05T14:21:08+00:00\",\"dateModified\":\"2025-10-08T07:20:24+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-can-bac-2-trong-excel-la-gi-11\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &#038; V\u00ed D\u1ee5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 C\u00e1ch T\u00ednh C\u0103n B\u1eadc 2 Trong Excel (SQRT, POWER,...) & X\u1eed L\u00fd L\u1ed7i Chi Ti\u1ebft","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng & V\u00ed D\u1ee5","og_description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-12-05T14:21:08+00:00","article_modified_time":"2025-10-08T07:20:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98"},"headline":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &#038; V\u00ed D\u1ee5","datePublished":"2023-12-05T14:21:08+00:00","dateModified":"2025-10-08T07:20:24+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/"},"wordCount":3081,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/","name":"5 C\u00e1ch T\u00ednh C\u0103n B\u1eadc 2 Trong Excel (SQRT, POWER,...) & X\u1eed L\u00fd L\u1ed7i Chi Ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg","datePublished":"2023-12-05T14:21:08+00:00","dateModified":"2025-10-08T07:20:24+00:00","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 5 c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng h\u00e0m SQRT, POWER, c\u00f4ng th\u1ee9c m\u0169 v\u00e0 Power Query. K\u00e8m c\u00e1ch s\u1eeda l\u1ed7i #NUM!, #VALUE! v\u00e0 ch\u00e8n d\u1ea5u \u221a.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-can-bac-2-trong-excel-11.jpg","width":1200,"height":628,"caption":"ham-can-bac-2-trong-excel-la-gi-11"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng D\u1eabn To\u00e0n T\u1eadp V\u1ec1 C\u0103n B\u1eadc 2 Trong Excel: C\u00f4ng Th\u1ee9c, C\u00e1ch D\u00f9ng &#038; V\u00ed D\u1ee5"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bc2d94dde92f5ae5c9cfdd919216cd98","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/288344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=288344"}],"version-history":[{"count":2,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/288344\/revisions"}],"predecessor-version":[{"id":496577,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/288344\/revisions\/496577"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/292368"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=288344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=288344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=288344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}