# Documentation/Calc Functions/POWER

Other languages:

POWER

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.

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

 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

LOG

LOG10

LN

EXP

## ODF standard:

Section 6.16.46, part2

POWER