Cube root?

[Guest]

How can I calculate the cube root of a number? Is there a formula for this?
Thanks!

 

[vezerid]

Scott,
you use the math rule that the nth root of a number is the number
raised to the 1/n.
Thus for the cubic root:
=A1^(1/3)

From my teaching experience: don;t forget the parentheses. The

exponentiation operator takes precedence over the division op.

HTH
Kostis Vezerides

 

[Mike Middleton]

Scott -

For example, with a number in cell A1, in some other cell enter =A1^(1/3)

- Mike
www.mikemiddleton.com

 

[Bill Kuunders]

To find the nth root of a number, raise that number to the power of 1/n. For
example, to find the cube root of 8 in a cell, type the following:
=8^(1/3)

from
http://support.microsoft.com/Default.aspx?kbid=271143

 

[Guest]

Oh yeah - I remember now! Thanks much for your help!

 

[Bernard Liengme]

And, if you prefer: =POWER(A1, 1/3)

 

[Charles Andrews]

How can I calculate the cube root of a number? Is there a formula for
this?
Thanks!

Only way I've managed to do it is value^0.33333333333333

Which is pretty good...

Charlie