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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal Seeking via Excel 0
Cube root function 5
I have lost 6 months work, how can i get my file back 1
is there a way to get a cuberoot function in Excell? 2
Is there a simple worksheet method to determine a cube root? 3
Does excel have a 'cubed root' function? How can it work it out? 1
cube root function 2
Cube root? 6

Top