POWER(number, power)

Returns the number raised to a given power.

numberThe base number (any real number).
powerThe 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)".
* You can use the SQRT function to return the positive square root of a number.
* For the Microsoft documentation refer to support.office.com

 A
1=POWER(2,2) = 4
2=POWER(5,2) = 25
3=POWER(98.6,3.2) = 2401077
4=POWER(4,5/4) = 5.657
5=LOG10(POWER(10,3.7)) = 3.7
6=POWER(10,LOG10(3.7)) = 3.7


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top