# Documentation/Calc Functions/POWER

From The Document Foundation Wiki

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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

## ODF standard:

## Equivalent Excel functions:

POWER