Cubed square root

[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

 

[Harlan Grove]

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?

 

[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

 

[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

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?

 

[Bernard Liengme]

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

 

[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)

 

[Harlan Grove]

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.

 

[Bernard Liengme]

Agreed, but Damon mention "function"

 

[Harlan Grove]

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.