View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sgl8akm sgl8akm is offline
external usenet poster
 
Posts: 1
Default 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