Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
New dude in town and don't know how to create the following complex (at least
to me) formula to calculate LV MASS in excel . . . lv mass = 1.05 x {(b+t)^[2/3 (a+1) + d ~ d3 / 3(a+t)^] - b^[2/3 a+d ~ d3 / 3a^]} note that d3 is d cubed any assistance is most helpful ... under pressure to solve this ASAP Someone pls show me the way . . . SF |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To put this into Excel, you need to tell us:
-- What do the tildes (~) mean? -- Does ^ mean "to the power of" (and if so, why not use it for d^3)? -- What does ^ mean when it's at then end of a calculation (as in the two ^]s) -- Where are the variables b, t, a, d and b? Cells a1 to a5 or somewhere else? Regards, Fred. "SilverFox" <u49417@uwe wrote in message news:916295aa72615@uwe... New dude in town and don't know how to create the following complex (at least to me) formula to calculate LV MASS in excel . . . lv mass = 1.05 x {(b+t)^[2/3 (a+1) + d ~ d3 / 3(a+t)^] - b^[2/3 a+d ~ d3 / 3a^]} note that d3 is d cubed any assistance is most helpful ... under pressure to solve this ASAP Someone pls show me the way . . . SF |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for taking an interest in my dilema Fred ...
This is a two part problem where my associate is working on the first formula ... thos results then feed into mine . . . can you contact me via my email then I can show you the actual formula as I cannot (or do not know how to) send attachment image on this board thnks much lad Fred Smith wrote: To put this into Excel, you need to tell us: -- What do the tildes (~) mean? -- Does ^ mean "to the power of" (and if so, why not use it for d^3)? -- What does ^ mean when it's at then end of a calculation (as in the two ^]s) -- Where are the variables b, t, a, d and b? Cells a1 to a5 or somewhere else? Regards, Fred. New dude in town and don't know how to create the following complex (at least [quoted text clipped - 10 lines] SF |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
OK ... I figured out a way to get my problem across ... I have added a
diagram of the formula and it's MUCH clearer than the way I defined it SF |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
SilverFox wrote:
OK ... I figured out a way to get my problem across ... I have added a diagram of the formula and it's MUCH clearer than the way I defined it CHECK OUT MY PHOTO GALLERY <<<<<< SF |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Sun, 08 Feb 2009 07:38:18 GMT, "SilverFox" <u49417@uwe wrote:
SilverFox wrote: OK ... I figured out a way to get my problem across ... I have added a diagram of the formula and it's MUCH clearer than the way I defined it CHECK OUT MY PHOTO GALLERY <<<<<< SF For anyone to do that, you'd have to post a link --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mass add in a column | Excel Discussion (Misc queries) | |||
probability mass function | Excel Worksheet Functions | |||
Formula Mass Copy??? | Excel Discussion (Misc queries) | |||
MASS MAILING | New Users to Excel | |||
mass change table_array Name in VLOOKUP formula | Excel Worksheet Functions |