How do I keep result from 1 iteration cycle to use in next cycle?
I would like to use the result from a previous iteration cycle to solve
another equation that also will undergo an iteration. How do I retain the 'previous' answer from the previous iteration cycle, so that I can then input it in the other equation showing me the 'current ' answer? I have a 30 x 30 matrix, and will probably carry out 50+ iterations. I am using the solver in Excel 2003 with 'iteratiion' enbled in the calculate tab in the options menu. Cheers |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com