LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 788
Default Iterative Equation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
an iterative calculation -- sort of ali Excel Worksheet Functions 4 July 30th 09 07:57 PM
Excel Iterative calculations petersampson Excel Worksheet Functions 3 December 31st 08 07:30 AM
Enable Iterative Calculations Dean Excel Discussion (Misc queries) 0 August 17th 07 02:03 AM
Iterative process, bioyyy Excel Discussion (Misc queries) 5 December 1st 05 02:07 AM
Equation Editor- problem when editing an equation Gaby L. Excel Discussion (Misc queries) 0 September 27th 05 09:24 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"