What is the formula for cube root on Excel?
 

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?

=A2^(1/3)

tbh_29 wrote:
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?

--

[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.

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tbh_29" wrote in message
...
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?

If working with Complex numbers...

=IMPOWER(A1,1/3)

HTH.
--
Dana DeLouis
Win XP & Office 2003


"tbh_29" wrote in message
...
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?