D
derskell
I would appreciate if someone could tell me how I insert a cube root value
into a formula and what symbol do I use.
Thanks
into a formula and what symbol do I use.
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.
L
Lewis Clark
One way: Raise to the 1/3 power. The cube root of x would be x^(1/3).
D
David J. Braden
For the nth root, use x^(1/n); so in your case, use x^(1/3).
HTH
DaveB
HTH
DaveB
B
Bob Phillips
You can also use POWER
=POWER(27,1/3)
--
HTH
RP
(remove nothere from the email address if mailing direct)
=POWER(27,1/3)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
David J. Braden
Bob,
FWIW, POWER is somewhat slower than what I suggested. Why it is even
included in Excel is one of those Redmond mysteries that I'll never fathom.
DaveB
FWIW, POWER is somewhat slower than what I suggested. Why it is even
included in Excel is one of those Redmond mysteries that I'll never fathom.
DaveB
B
Bob Phillips
You could say the same about CONCATENATE, totally superfluous IMO.
The only redeeming (?) feature (true of POWER also) is that it is more
self-documenting than &.
Bob
The only redeeming (?) feature (true of POWER also) is that it is more
self-documenting than &.
Bob