Excel计算平方、立方、N次方或开方用指数函数(幂函数)Power ... | 開方excel
ExcelУƽNηNݣַһΪPower㣬һΪֺţ㣻㿪ֱַΪSQRTPowerֺţ㡣㸺ƽʱҪظҪָšֺţ㿪ʱҪֺźķҪƽͣSumSQҪƽͺٿSumSQ+Powerʵ֣ҪһĶ֮ͣSum+Rowʵ֡ һExcelƽNηһָݺPower1PowerʽPOWER(Number,Power)NumberΪPowerΪָ2ڼƽNηķҪ5ƽ16η˫B2Ԫѹʽ=POWER(A2,2)ƵB2س5ƽ25˫C2ͬһʽճC22Ϊ3س5125˫D2ͬһʽճD22Ϊ16516η1.52588E+11̲裬ͼ1ʾͼ1 ֺţ൱Powerͬ5ƽ16ηΪ˫B2Ԫѹʽ=A22ƵB2س5ƽ25˫C2ͬһʽճC22Ϊ3س5125˫D2ͬһʽճD22Ϊ16س516η1.52588E+11ȫ̲ͬ裬ͼ2ʾͼ2 㸺ƽ1Ҫ-2ƽֱ˫B2Ԫѹʽ=A22ƵB2س4˫B3ѹʽ=A22ճB3A2ǰ븺ţ-سҲ4˫B4ѹʽ=A22ƵB4ѹʽΪ=-(A22)س-4˫B5ѹʽ=-22ƵB5س4˫B6ѹʽ=-22ճB622ţس-4˫C2ѹʽ=A23ƵC2س-8˫C3ѹʽ=A23ճC3A2ǰ븺ţس8̲裬ͼ3ʾͼ32...
Excel УƽNηNݣַһΪPower㣬һΪֺţ㣻㿪ֱַΪSQRTPowerֺţ㡣㸺ƽʱҪظҪָšֺţ㿪ʱҪֺźķ
ҪƽͣSumSQҪƽͺٿ SumSQ + Power ʵ֣ҪһĶ֮ͣ Sum + Row ʵ֡
һExcelƽNη
һָݺPower
1PowerʽPOWER(Number, Power)Number ΪPower Ϊָ
2ڼƽNηķ
Ҫ 5 ƽ 16 η˫ B2 Ԫѹʽ =POWER(A2,2) Ƶ B2س 5 ƽ 25˫ C2ͬһʽճ C2 2 Ϊ 3س 5 125˫ D2ͬһʽճ D2 2 Ϊ 16 5 16 η1.52588E+11̲裬ͼ1ʾ
ͼ1
ֺţ
൱Powerͬ 5 ƽ 16 ηΪ˫ B2 Ԫѹʽ =A22 Ƶ B2س 5 ƽ 25˫ C2ͬһʽճ C2 2 Ϊ 3س 5 125˫ D2ͬһʽճ D2 2 Ϊ 16س 5 16 η 1.52588E+11ȫ̲ͬ裬ͼ2ʾ
ͼ2
㸺ƽ
1Ҫ -2 ƽֱ˫ B2 Ԫѹʽ =A22 Ƶ B2س 4˫ B3ѹʽ =A22 ճ B3 A2 ǰ븺ţ-سҲ 4˫ B4ѹʽ =A22 Ƶ B4ѹʽΪ =-(A22)س -4˫ B5ѹʽ =-22 Ƶ B5س 4˫ B6ѹʽ =-22 ճ B6 22 ţس -4˫ C2ѹʽ =A23 Ƶ C2س -8˫ C3ѹʽ =A23 ճ C3 A2 ǰ븺ţس 8̲裬ͼ3ʾ
ͼ3
2ʽ =-22 -2 ƽ֮Ϊ 4Ϊţ-ļȨڳ˷ -2 ƽʽ =A22 =-A22 4 ͬһ˼ˣƽҪظҪֺͳ˷ =-(A22) =-(22)
Excel㣨ƽ
һSQRT
1Ҫ 2 3 ƽ˫ B2 Ԫѹʽ =SQRT(A2) Ƶ B2س 2 ƽ ...