Powers and Roots in Excel 2007 | excel root square
Software[1]MicrosoftOffice[2]Excel[3]PowersandRootsinExcel2007:ThePOWERandSQRTFunctionsByGregHarvey[4]InExcel2007,youusethePOWERfunctiontoraiseanumbertoacertainpower,andSQRTtofindthesquarerootofanumber.ThesefunctionsarelocatedwiththeMath&TrigfunctionsontheRibbon’sFormulastaborintheSelectaCategorylistintheInsertFunctiondialogbox.POWERAlthoughyoucanusethecaret()operatortobuildaformulathatraisesanumbertoanypower,thePOWERfunctionaccomplishesthesamething.Forexample,tobuildaformulathatraises5....
Software[1]Microsoft Office[2]Excel[3]Powers and Roots in Excel 2007: The POWER and SQRT FunctionsIn Excel 2007, you use the POWER function to raise a number to a certain power, and SQRT to find the square root of a number. These functions are located with the Math & Trig functions on the Ribbon’s Formulas tab or in the Select a Category list in the Insert Function dialog box.
POWERAlthough you can use the caret () operator to build a formula that raises a number to any power, the POWER function accomplishes the same thing. For example, to build a formula that raises 5.9 to the third power (that is, cubes the number), you can use the exponentiation operator as in:
=5.93You can have Excel perform the same calculation with the POWER function by entering this formula:
=POWER(5.9,3)In either case, Excel returns the same result, 205.379. The only difference between using the exponentiation operator and the POWER functi...