Cube root?
 

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

Cube root?
 

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

Cube root?
 

Scott -

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

- Mike
www.mikemiddleton.com

"Scott" wrote in message
...
How can I calculate the cube root of a number? Is there a formula for
this?
Thanks!

Cube root?
 

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


--
Greetings from New Zealand
Bill K
"Scott" wrote in message
...
How can I calculate the cube root of a number? Is there a formula for
this?
Thanks!

Cube root?
 

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

"vezerid" wrote:

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

Cube root?
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott" wrote in message
...
How can I calculate the cube root of a number? Is there a formula for
this?
Thanks!

Cube root?
 

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