Microsoft Office Tutorials and References
In Depth Information
Using SQRT and POWER to Calculate Square Roots and Exponents
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
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).
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.
The POWER function returns the result of a number raised to a power. This
function takes the following arguments:
number — This is the base number. It can be any real number.
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.