Syntax. POWER(number,power)
Definition. This function returns a number raised to a power.
Arguments
number (required) The base number, which can be any real number
power (required) The exponent to which the base number is raised
Background. If a number is raised to a given power, the number is (repeatedly) multiplied with itself.
a • a • a • a •...• a = an
In this equation, the base number a multiplied with itself to the power n. The following apply:
a is called the base or cardinal number.
n is called the exponent.
The result is the power. The logarithm and the root function are inverse functions of POWER().
Instead of the POWER() function, you can use the operator ^ to raise a number; for example, =5^2 instead of =POWER(5,2).
Example. Computers use the dual system for digital processing based on the number 2. The units of digital storage media are the powers to base 2 (power of two). Therefore, 1 kilobyte is 210 bytes = 1024 bytes.
More examples for this function are:
=POWER(3,2) returns 9.
=POWER(3.2,3) returns 32.768.
=POWER(7,1.33) returns 13.3039435426393.