Microsoft Excel Functions & Formulas

Use the POWER function to calculate the

square and cube roots

To raise numbers to the power of another number, the POWER

function is used. It can also be used to calculate the root.

POWER(number, power)

number: The base number, which can be any real number.

power: The exponent.

Note: The operator ^ can be used instead of POWER, so

=POWER(3,2) could be written like this: =3^2.

4

To calculate roots using the POWER function:

1. In cells A2:A10 list some values.

2. Select cells B2:B10 and type the formula

=POWER((A2),1/2) to calculate the square root.

3. Press <Ctrl+Enter>.

4. Select cells C2:C10 and type the formula

=POWER((A2),1/3) to calculate the cube root. ...