Documentation/Calc Functions/POWER

Function name:
POWER

Category:
Mathematical

Summary:
Raises one number (the base) to the power of another number (the exponent). This mathematical operation is known as exponentiation.

Syntax:
POWER(Base; Exponent)

Returns:
Returns a real number that is the specified base raised to the power of the given exponent.

Arguments:
Base is a real number, or a reference to a cell containing that number, that is the base value.

Exponent is a real number, or a reference to a cell containing that number, that is the exponent value.


 * If either Base or Exponent is non-numeric, then POWER reports a #VALUE! error.
 * If Base is equal to 0 and Exponent is negative, then POWER reports a #NUM! error.
 * If Base is negative and Exponent is non-integer, then POWER reports a #NUM! error.
 * If both Exponent and Base are 0, then POWER returns 1.

Additional details:

 * The formula for this function is $$\text{POWER}(a; b)\:=\:a^b$$.
 * POWER cannot be used with a negative base and a non-integer exponent. This means, for example, that you cannot use POWER to solve expressions such as $$ (-1)^{0.5}$$ – this is equivalent to $$\sqrt{-1}$$ which has no real solution.
 * Calc's exponentiation operator (^) produces the same result as that obtained from POWER. For example, the formula  gives the same result as.
 * For more background information about the exponentiation operator, visit Wikipedia’s Exponentiation page.

Related LibreOffice functions:
EXP

LN

LOG

LOG10

ODF standard:
Section 6.16.46, part 2

Equivalent Excel functions:
POWER