Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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 | |
|
|
![]() |
||||
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 |