{"id":1697,"date":"2020-11-03T02:28:34","date_gmt":"2020-11-02T19:28:34","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1697"},"modified":"2020-11-03T02:35:09","modified_gmt":"2020-11-02T19:35:09","slug":"tinh-can-bac-2-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/tinh-can-bac-2-trong-excel\/","title":{"rendered":"C\u00e1ch T\u00ednh C\u0103n B\u1eadc N V\u00e0 C\u0103n B\u1eadc 2 Trong Excel"},"content":{"rendered":"\t\t
Khi s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh Excel, kh\u00f4ng ph\u1ea3i ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u0169ng \u0111\u00e3 t\u1eebng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh l\u0169y th\u1eeba, khai c\u0103n v\u00ec ch\u00fang kh\u00f4ng th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 c\u00e1c ph\u00e9p to\u00e1n c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia.<\/span><\/p> \u00a0<\/span><\/p> Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u c\u00e1ch t\u00ednh c\u0103n b\u1eadc b\u1ea5t k\u1ef3 v\u00e0 c\u0103n b\u1eadc 2 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed ^ (d\u1ea5u m\u0169) v\u00e0 h\u00e0m SQRT.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u0110\u1ea7u ti\u00ean, h\u00e3y c\u00f9ng hoctin.vn t\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 c\u0103n b\u1eadc n v\u00e0 c\u0103n b\u1eadc 2 trong to\u00e1n h\u1ecdc.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u0103n b\u1eadc n c\u1ee7a m\u1ed9t s\u1ed1 a l\u00e0 s\u1ed1 x sao cho x m\u0169 n b\u1eb1ng a: x<\/span>n<\/span><\/span> = a.<\/span><\/p> C\u0103n b\u1eadc n c\u1ee7a m\u1ed9t s\u1ed1 a c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i theo m\u1ed9t c\u00e1ch kh\u00e1c, l\u00e0 l\u0169y th\u1eeba b\u1eadc 1\/n c\u1ee7a a, hay n\u00f3i c\u00e1ch kh\u00e1c th\u00ec a<\/span>1\/n<\/span><\/span> = x.<\/span><\/p> V\u00ed d\u1ee5:<\/span><\/p> \u221b8=2 hay 8<\/span>1\/3<\/span><\/span>=2 v\u00ec 2<\/span>3<\/span><\/span>=8;<\/span><\/p> \u221c16=2 hay 16<\/span>1\/4<\/span><\/span>=2 v\u00ec 2<\/span>4<\/span><\/span> = 16.<\/span><\/p> \u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u0103n b\u1eadc 2 c\u1ee7a m\u1ed9t s\u1ed1 a kh\u00f4ng \u00e2m l\u00e0 s\u1ed1 x sao cho x<\/span>2<\/span><\/span> = a, hay a<\/span>1\/2<\/span><\/span> = x, v\u00ed d\u1ee5 \u221a16 = 4 v\u00ec 4 m\u0169 2 b\u1eb1ng 16.<\/span><\/p> V\u00ec b\u00ecnh ph\u01b0\u01a1ng c\u1ee7a 2 s\u1ed1 \u0111\u1ed1i nhau x v\u00e0 -x \u0111\u1ec1u b\u1eb1ng a n\u00ean s\u1ed1 a kh\u00f4ng \u00e2m c\u00f3 hai c\u0103n b\u1eadc 2:<\/span><\/p> – C\u0103n b\u1eadc 2 c\u1ee7a a l\u00e0 s\u1ed1 d\u01b0\u01a1ng k\u00ed hi\u1ec7u l\u00e0 \u221aa<\/span><\/p> – C\u0103n b\u1eadc 2 c\u1ee7a a l\u00e0 s\u1ed1 \u00e2m k\u00ed hi\u1ec7u l\u00e0 -\u221aa<\/span><\/p> – S\u1ed1 0 c\u00f3 \u0111\u00fang m\u1ed9t c\u0103n b\u1eadc hai l\u00e0 ch\u00ednh n\u00f3: \u221a0 = -\u221a0 = 0.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t T\u1eeb kh\u00e1i ni\u1ec7m to\u00e1n h\u1ecdc \u1edf tr\u00ean, \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc n v\u00e0 c\u0103n b\u1eadc 2 trong Excel, c\u1ea7n s\u1eed d\u1ee5ng to\u00e1n t\u1eed d\u1ea5u m\u0169 (^) thay cho d\u1ea5u c\u0103n trong Excel.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u0110\u1ec3 t\u00ednh a m\u0169 b (a<\/span>b<\/span><\/span>) trong Excel, s\u1eed d\u1ee5ng c\u00fa ph\u00e1p =a^b<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Khai c\u0103n l\u00e0 ph\u00e9p to\u00e1n ng\u01b0\u1ee3c c\u1ee7a l\u0169y th\u1eeba.<\/span><\/p> H\u00e0m c\u0103n b\u1eadc n trong Excel c\u1ee7a 1 s\u1ed1 m b\u1ea5t k\u1ef3: =m^(1\/n)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t T\u01b0\u01a1ng t\u1ef1, c\u00f4ng th\u1ee9c t\u00ednh c\u0103n b\u1eadc 2 trong Excel c\u1ee7a 1 s\u1ed1 a b\u1ea5t k\u1ef3 l\u00e0 =a^(1\/2) ho\u1eb7c =a^0.5<\/span><\/p> C\u0103n b\u1eadc 3 trong Excel c\u1ee7a s\u1ed1 a l\u00e0: =a^(1\/3)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t V\u00ed d\u1ee5 t\u00ednh c\u0103n b\u1eadc 2 v\u00e0 b\u1eadc 3 c\u1ee7a c\u00e1c s\u1ed1 b\u1ea5t k\u1ef3:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t1, C\u0103n B\u1eadc N V\u00e0 C\u0103n B\u1eadc 2 S\u1ed1 H\u1ecdc<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2, C\u00e1ch T\u00ednh L\u0169y Th\u1eeba V\u00e0 C\u0103n B\u1eadc N C\u1ee7a M\u1ed9t S\u1ed1 Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2.1, C\u00e1ch T\u00ednh L\u0169y Th\u1eeba Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2.2, C\u00e1ch T\u00ednh C\u0103n B\u1eadc N C\u1ee7a M\u1ed9t S\u1ed1 Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
V\u00ed d\u1ee5 \u0111\u1ec3 t\u00ednh c\u0103n b\u1eadc 3 c\u1ee7a -125, c\u00f4ng th\u1ee9c =(-125)^(1\/3) ho\u1eb7c =-125^(1\/3) \u0111\u1ec1u s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c.<\/span><\/span>
<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
B\u1ea1n t\u1ef1 \u0111\u1ed9ng th\u00eam d\u1ea5u \u00e2m (-) ra ph\u00eda tr\u01b0\u1edbc c\u00f4ng th\u1ee9c =-a^(1\/2), nh\u01b0ng Excel s\u1ebd kh\u00f4ng hi\u1ec3u theo c\u00e1ch m\u00e0 b\u1ea1n mu\u1ed1n m\u00e0 n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NUM! v\u00ec Excel hi\u1ec3u r\u1eb1ng b\u1ea1n mu\u1ed1n t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a -9.<\/span>
\u0110\u1ec3 t\u00ednh -\u221aa, l\u01b0u \u00fd v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ngo\u1eb7c \u0111\u1ec3 ch\u1ec9 th\u1ee9 t\u1ef1 \u01b0u ti\u00ean ph\u00e9p n\u00e0o \u0111\u01b0\u1ee3c t\u00ednh tr\u01b0\u1edbc, tr\u01b0\u1edbc khi th\u00eam d\u1ea5u -. C\u00f4ng th\u1ee9c \u0111\u00fang s\u1ebd l\u00e0 =-(a^(1\/2)).<\/span>
<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t