G
Guest
How can I calculate the cube root of a number? Is there a formula for this?
Thanks!
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
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)
HTH
Kostis Vezerides
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)
exponentiation operator takes precedence over the division op.From my teaching experience: don;t forget the parentheses. The
HTH
Kostis Vezerides
M
Mike Middleton
Scott -
For example, with a number in cell A1, in some other cell enter =A1^(1/3)
- Mike
www.mikemiddleton.com
For example, with a number in cell A1, in some other cell enter =A1^(1/3)
- Mike
www.mikemiddleton.com
B
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
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
G
Guest
Oh yeah - I remember now! Thanks much for your help!
B
Bernard Liengme
And, if you prefer: =POWER(A1, 1/3)
C
Charles Andrews
Scott said: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