Cubed square root

D

Damon Longworth

I know the SQRT function, but how would I create an Excel function for an
equation similar to:

______
_ 3 / 2
\ / 25



--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html
 
H

Harlan Grove

Damon Longworth said:
I know the SQRT function, but how would I create an Excel function
for an equation similar to:

______
_ 3 / 2
\ / 25
....

So this can't wait until the Excel &c User Conference?

Perhaps =25^(2/3) ?

IOW, who needs a function?
 
M

Martin Fishlock

Hi Damon,

You can you the power (^) to get squares (x^2) and for roots use ^(1/root)
in brackets as the association would only do the power to 1:

=(25^2)^(1/3)

ie
=8^(1/3)=2
=8^1/3= 8/3=2.66667
 
D

Damon Longworth

No, it could not wait. ;-)

Thanks Harland. I could not find a built in function, but thought there
might be one buried in there somewhere.

--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html

Damon Longworth said:
I know the SQRT function, but how would I create an Excel function
for an equation similar to:

______
_ 3 / 2
\ / 25
....

So this can't wait until the Excel &c User Conference?

Perhaps =25^(2/3) ?

IOW, who needs a function?
 
B

Bernard Liengme

Hi Damon,
And then there is oft forgotten POWER function
=POWER(A1,2/3)
best wishes
 
C

Chip Pearson

Do you mean

=A1^1.5
or
=SQRT(A1)^3

E.g,. if A1 is 25, the result is 125, which SQRT(25)^3 = 5^3 = 125

which is the same as

=SQRT(A1^3)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



(email address is on the web site)
 
H

Harlan Grove

Bernard Liengme said:
And then there is oft forgotten POWER function
....

And forgotten & unused is what it should continue to be, along with
CONCATENATE. Pointless functions that duplicate available operators (^
and &, respectively), make formulas longer and slower, and
unnecessarily eat a function call level. There's not even the
convenience of LN and LOG10 vs LOG.
 
H

Harlan Grove

Bernard Liengme said:
Agreed, but Damon mention "function"
....

In which case it's beneficial to point out that functions aren't
always ideal. There are situations (like this) in which they're
objectively inferior to operators.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top