Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to solve the equation T=(11.4L^0.5)(K^0.52)(S^-0.318)(i^-0.38),
where "L, K & S" are constants and "i" is determined from a table based on time. "T" is time in minutes. To solve the equation fully, once "T" is solved for it is compared with the time value used in the table that "i" was determined from. If necessary, a new value of "i" is determined and the equation is solved again. This is repeated until an acceptable tolerance between "T" and the value used to determine "i" is reached. Is there an easy way to set this up in excel to run an iterative process with a table? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
an iterative calculation -- sort of | Excel Worksheet Functions | |||
Excel Iterative calculations | Excel Worksheet Functions | |||
Enable Iterative Calculations | Excel Discussion (Misc queries) | |||
Iterative process, | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |