POWER

POWER(number, power)

Returns the number raised to a given power.

number	The base number (any real number).
power	The exponent to which you want the base raised to.

REMARKS

* The "^" operator can be used instead of this function to indicate to what power the base number is to be raised, such as in 5^2.
* There are two ways to calculate the power of a number typing "10^4" or "=POWER(10,4)".
* If "power" < 0, the reciprocal of the number raised to the positive power.
* If "number" = 0 and "power" < 0, then #DIV/0! is returned.
* If "number" < 0 and "power" is a decimal, then #NUM! is returned.
* If "number" < 0 and "power" is a decimal, this would be a complex number.
* You can use the LN function to return the natural logarithm of a number (to the base e).
* You can use the LOG function to return the logarithm of a number to any base.
* You can use the LOG10 function to return the logarithm of a number to the base 10.
* You can use the SQRT function to return the positive square root of a number.
* You can use the IMPOWER function return the complex number raised to an integer number.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=POWER(1, 10) = 1
2	=POWER(2, 2) = 4
3	=POWER(5, 2) = 25
4	=POWER(10, 3) = 1000
5	=POWER(123, 1) = 123
6	=POWER(4, 1/2) = 2
7	=POWER(27, 1/3) = 3
8	=POWER(64, 1/3) = 4
9	=POWER(4, -1) = 0.25
10	=POWER(10, -2) = 0.01
11	=POWER(-2, 3) = -8
12	=POWER(-2, -3) = -0.125
13	=LOG10(10 * 10 * 10 * 10) = 4
14	=POWER(5,2) = 5^2
15	=POWER(-1, 1/2) = #NUM!
16	=POWER(0, 0) = #NUM!
17	=POWER(0, -1) = #DIV/0!
18	=POWER("text", 1) = #VALUE!

1 - What is 1 to the power of 10. (1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1)
2 - What is 2 to the power of 2. (2 x 2)
3 - What is 5 to the power of 2. (5 x 5)
4 - What is 10 to the power of 3. (10 x 10 x 10)
5 - What is 123 to the power of 1. Any number to the power of 1 is itself.
6 - What is 4 to the power of 1/2. (4 / 2 = 2)
7 - What is 27 to the power of 1/3. ( (27 / 3) / 3 = 3 )
8 - What is 64 to the power of 1/3. ( (64 / 3) / 3 = 4 )
9 - What is 4 to the power of -1. Divide 1 by the number. (1/4)
10 - What is 10 to the power of -2. Divide 1 by the number raised to the positive power. 1 divided by 10 squared. (1 / (10 x 10))
11 - What is -2 to the power of 3. (-2 x -2 x -2)
12 - What is -2 to the power of -3. Divide 1 by the number raised to the positive power. 1 divided by (-2) cubed. (1 / (-2 x -2 x -2))
13 - For multiples of 10, the LOG10 function will tell you what the power is.
14 - What is 5 to the power of 2. (5 x 5)
15 - What is -1 to the power of 1/2. This is the square root of minus one which is a complex number.
16 - What is 0 to the power of 0.
17 - What is 0 to the power of -1.
18 - What if "number" is not numeric.