Documentation/Calc Functions/POWER

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

POWER

Category:

Mathematical

Summary:

Returns a number raised to another number.

Syntax:

POWER(Base; Exponent)

Returns:

Returns an real number which is Base raised to the power of Exponent.

Arguments:

Base is a real number or a reference to the cell containing that number which the base value for the POWER function.

Exponent is a real number or a reference to the cell containing that number which the number, Base is raised to.

  • If Exponent is non-integer and Base is negative, the function returns a numeric value(#NUM!) error.
  • If Exponent is negative and Base is 0, the function returns a numeric value(#NUM!) error.
  • If both Exponent and Base are 0, the function returns 1.

Additional details:

The same result may be achieved by using the exponentiation operator ^ : Base^Exponent

Note pin.svg

POWER(0,0) returns 1.


Examples:

Formula Description Returns
=POWER(5;3) 5 raised to the power 3 125
=POWER(5.5;3.7) 5.5 raised to the power 3.7 548.708832614192
=POWER(5.5;-3.7) 5.5 raised to the power -3.7 0.001822460183912
=POWER(-5;3) -5 raised to the power 3 -125
=POWER(-5;-3) -5 raised to the power -3 -0.008
=POWER(-5.5;3) -5.5 raised to the power 3 -166.375
=POWER(-5.5;3.7) Exponent is non-integer and Base is negative so function returns a numeric value error #NUM!
=POWER(0;-3.7) Exponent is negative and Base is 0 so function returns a numeric value error #NUM!
=POWER(0;0) Exponent and Base both are 0 1

Related LibreOffice functions:

LOG

LOG10

LN

EXP

ODF standard:

Section 6.16.46, part2

Equivalent Excel functions:

POWER