cube root

[Guest]

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

 

[Lewis Clark]

One way: Raise to the 1/3 power. The cube root of x would be x^(1/3).

 

[David J. Braden]

For the nth root, use x^(1/n); so in your case, use x^(1/3).
HTH
DaveB

 

[Bob Phillips]

You can also use POWER

=POWER(27,1/3)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[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

 

[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