Excel 2000 in a Nutshell

Name

POWER

Synopsis

You can use POWER to determine the results of raising a numeric value to a specific power. When you raise a number to a value you inidicate that you want to multiply the specified number by itself the number of times specified in the Power argument. For example, 4 raised to the 3 power is same as to 4 x 4 x 4.

To Calculate

=POWER(Number, Power)

The Number and Power arguments are required for this function.

Number

Specifies a numeric value that you want to raise to the value of the Power argument.

Power

Specifies a numeric value that you want to use as the exponent in the equation.

Example

Figure 14-12 illustrates how to use POWER to determine the value of raising a number to a specific power. It also compares the difference between using LOG and LOG10.

Note

Instead of using POWER you can use the power operator ^. For example, =POWER(4,3) is the same as 4^3.