From The Document Foundation Wiki
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
|