SQRT

[MBJT]

HI

=SQRT(16) gives an answer of 4 that's ok. But how do you find the Cubed Root of say for e.g. 27 which should = 3

Cheers
MBJT.

 

[Frank Kabel]

Hi
try
27^(1/3)

--
Regards
Frank Kabel
Frankfurt, Germany

HI,

=SQRT(16) gives an answer of 4 that's ok. But how do you find the

Cubed Root of say for e.g. 27 which should = 3.

 

[Norman Harker]

Hi MBJT!

Use:

=27^(1/3)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
..

 

[Jason Morin]

A1: 27
B1: =A1^(1/3)

HTH
Jason
Atlanta, GA

-----Original Message-----
HI,

=SQRT(16) gives an answer of 4 that's ok. But how do you

find the Cubed Root of say for e.g. 27 which should = 3.

 

[Bernard V Liengme]

And if you like functions =POWER(A1,1/3)
Bernard

HI,

=SQRT(16) gives an answer of 4 that's ok. But how do you find the Cubed

Root of say for e.g. 27 which should = 3.

 

[Harlan Grove]

And if you like functions =POWER(A1,1/3)

...

Rather bland if the goal is wasting as many cycles as reasonably possible (which
is all functions such as POWER and CONCATENATE provide relative to their
respective work-alike operators ^ and &). How about =EXP(PRODUCT(LN(A1),1/3))?

 

[Scott L Grimes]

HI,

=SQRT(16) gives an answer of 4 that's ok. But how do you find the Cubed Root of say for e.g. 27 which should = 3.

Cheers,
MBJT.

Try this - worked for me: If the number you want the cubed root of is
in A1, then =A1^(1/3).

Best of luck
Scott L. Grimes

 

[Frank Kabel]

[...]

Rather bland if the goal is wasting as many cycles as reasonably possible (which
is all functions such as POWER and CONCATENATE provide relative to their
respective work-alike operators ^ and &). How about

=EXP(PRODUCT(LN(A1),1/3))?

lol
Harlan
I see you're creative this evening.

Best regards
frank

 

[Dana DeLouis]

=EXP(PRODUCT(LN(A1),1/3))?

Internally, isn't that done like this...

=EXP(PRODUCT(LN(A1),POWER(3,-1)))

or this..

=EXP(PRODUCT(LN(A1),PRODUCT(1,POWER(3,-1))))

:>)
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

[...]

Rather bland if the goal is wasting as many cycles as reasonably possible (which
is all functions such as POWER and CONCATENATE provide relative to their
respective work-alike operators ^ and &). How about

=EXP(PRODUCT(LN(A1),1/3))?

lol
Harlan
I see you're creative this evening.

Best regards
frank

 

[Harlan Grove]

Internally, isn't that done like this...

=EXP(PRODUCT(LN(A1),POWER(3,-1)))

or this..

=EXP(PRODUCT(LN(A1),PRODUCT(1,POWER(3,-1))))

...

No, as you should know. Internally, it's

2^(LOG(A1,2)/3)

 

[MBJT]

Thanks to everyone who replied. That was the first time I had ever used the office discussion group and it proved most helpful

Thanks
MBJT