POWER()
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.