# Documentation/Calc Functions/POWER

Jump to navigation Jump to search
Other languages:
English • ‎dansk

POWER

Mathematical

## Summary:

Returns a number raised to the power of another number.

## Syntax:

POWER(Base; Exponent)

## Returns:

Returns a 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 is the base value.

Exponent is a real number or a reference to the cell containing that number which the 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

## 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

POWER