What is the formula for cube root on Excel?

T

tbh_29

Any one know how i can do cube roots on excel? i know square root is IMSQRT,
but i do not know what cube root funtion is?
 
A

Aladin Akyurek

=A2^(1/3)

tbh_29 said:
Any one know how i can do cube roots on excel? i know square root is IMSQRT,
but i do not know what cube root funtion is?
Click to expand...

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
 
B

Bernard Liengme

The function for square root is SQRT. The IMSQRT is for complex numbers.
In addition to A1^(1/3) you can use =POWER(A1, 1/3)
best wishes
 
Top