Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need excel formula for equation h=-16t^2+v*x+h_0, please?
my desire is to create an algebraic excel work using the equation
h=16t^2+v*x+h_0. I did not know how to set up formula on excel and hoping someone can help...thanks Dee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need excel formula for equation h=-16t^2+v*x+h_0, please?
Hi,
Assuming you have the value of t in cell A3, v in cell A4, x in cell A5 and h_0 in cell A6, enter the formula as you have entered it below in cell A1 (is equal to sign onwards). Just that you should replace t,v,x and h_0 with the cell references. -- Regards, Ashish Mathur www.ashishmathur.com http://www.linkedin.com/in/excelenthusiasts "Dee" wrote in message ... my desire is to create an algebraic excel work using the equation h=16t^2+v*x+h_0. I did not know how to set up formula on excel and hoping someone can help...thanks Dee |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need excel formula for equation h=-16t^2+v*x+h_0, please?
=16t^2+v*(x+h_0)
Set it up just as a standard formula for a falling body. Use parentheses as you require them If t in in cell b1 and v is in cell c1 and x is in cell d1 and h_0 is in e1 then =(16*b1)^2+c1*(d1+e1). Excel has rules for evaluation. Look in help. It is very simple Tyro "Dee" wrote in message ... my desire is to create an algebraic excel work using the equation h=16t^2+v*x+h_0. I did not know how to set up formula on excel and hoping someone can help...thanks Dee |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need excel formula for equation h=-16t^2+v*x+h_0, please?
Actually 16 * b1^2 etc
"Tyro" wrote in message t... =16t^2+v*(x+h_0) Set it up just as a standard formula for a falling body. Use parentheses as you require them If t in in cell b1 and v is in cell c1 and x is in cell d1 and h_0 is in e1 then =(16*b1)^2+c1*(d1+e1). Excel has rules for evaluation. Look in help. It is very simple Tyro "Dee" wrote in message ... my desire is to create an algebraic excel work using the equation h=16t^2+v*x+h_0. I did not know how to set up formula on excel and hoping someone can help...thanks Dee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex formula/equation | Excel Worksheet Functions | |||
Formula/Equation | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Equation and roundup in the formula bar | Excel Worksheet Functions | |||
Equation for PMT formula | Excel Worksheet Functions |