Microsoft Office Tutorials and References

In Depth Information

**Using SQRT and POWER to Calculate Square Roots and Exponents**

Using

Using
SQRT

SQRT
and

and
POWER

POWER
to Calculate Square Roots and Exponents

to Calculate Square Roots and Exponents

Most calculators offer a square root button, so it seems natural that Ex-

cel would offer a SQRT function to do the same thing. To square a number, you

multiply the number by itself, ending up with a square. For example, 5 × 5 = 25.

A square root is a number that, when multiplied by itself, leads to a square.

For example, the square root of 25 is 5, and the square root of 49 is 7. Some

square roots are more difficult to calculate. The square root of 8 is a num-

ber between 2 and 3
—
somewhere close to 2.828. You can calculate the number

with =SQRT(8).

Note

SQRTPI is a specialized version of SQRT. This function is handy for

converting square shapes to equivalent-sized round shapes.

A related function is the POWER function. If you want to write the shorthand

for 6 × 6 × 6 × 6 × 6, you would say
“
six to the fifth power,
”
or 65. Excel can

calculate this with =POWER(6,5).

Syntax

=SQRT(number)

The SQRT function returns a positive square root. The argument number is the

number for which you want the square root. If numberis negative, SQRT re-

turns a #NUM! error.

Syntax

=POWER(number,power)

The POWER function returns the result of a number raised to a power. This

function takes the following arguments:

•
number

number
—
This is the base number. It can be any real number.

•
power

power
—
This is the exponent to which the base number is raised.

The POWER function works with all sorts of irrational numbers, such as

98.2 raised to the 3.4 power.