cube root

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


"derskell" <[email protected]> wrote in message
news:[email protected]...
>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

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

"derskell" <[email protected]> wrote in message
news:[email protected]...
>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

You can also use POWER

=POWER(27,1/3)

--

HTH

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


"derskell" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
news:%[email protected]...
> You can also use POWER
>
> =POWER(27,1/3)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "derskell" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>

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

"David J. Braden" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > You can also use POWER
> >
> > =POWER(27,1/3)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "derskell" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >
> >
>
>

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

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


"derskell" <[email protected]> wrote in message
news:[email protected]...
>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

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

"derskell" <[email protected]> wrote in message
news:[email protected]...
>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

You can also use POWER

=POWER(27,1/3)

--

HTH

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


"derskell" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
news:%[email protected]...
> You can also use POWER
>
> =POWER(27,1/3)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "derskell" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>

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

"David J. Braden" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > You can also use POWER
> >
> > =POWER(27,1/3)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "derskell" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >
> >
>
>