OpenOffice3.org Calc 3. Mathematical Functions

POWER(Base;Exponent) Function

Returns a numeric value. Raises the argument “Base” to the power indicated by the argument “Exponent”. The argument “Base” contains a numeric value or reference to a cell containing a numeric value. Is the number to be raised. The argument “Exponent” contains a numeric value or a reference to a cell containing a numeric value. Is the number that will raise the first value. For example:

=POWER(5;2) Returns 25. Calculates the square of 5.
=POWER(16;0,5) Returns 4. Calculates the square root of 16.
=POWER(27;1/3) Returns 3. Returns the cube root of 27..

 

Back to the list of mathematical functions