Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
"Damon Longworth" wrote...
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
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 -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Damon Longworth" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
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 "Harlan Grove" wrote in message ups.com... "Damon Longworth" wrote... 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
Hi Damon,
And then there is oft forgotten POWER function =POWER(A1,2/3) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Damon Longworth" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
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) "Damon Longworth" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
"Bernard Liengme" wrote...
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
Agreed, but Damon mention "function"
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Harlan Grove" wrote in message oups.com... "Bernard Liengme" wrote... 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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cubed square root
"Bernard Liengme" wrote...
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Square Root Symbol in VBA | Excel Discussion (Misc queries) | |||
what is formula for cubed root | Excel Worksheet Functions | |||
what is the formula for the cubed root of | Excel Discussion (Misc queries) | |||
how do you calculate the 5th square root in MS Excel? | Excel Worksheet Functions | |||
Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions |