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
.
Sample Files
Use the POWER worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.
18.219.34.62