How do I keep result from 1 iteration cycle to use in next cycle?

S

sgl8akm

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Solver results of each iteration to a given location in a workbook 1
How do I install Microsoft Equation 3.0 back to Office 365? 0
How to use/create code in MS Word to calculate age? 0
How do I use Excel Solver (for an Iteration in a row) for several no.of times? 0
Can I enforce Goal Seek to perform one iteration only? 2
How do I resolve complex iteration problems in Excel? 7
How to calculate something using equation from Chart' directly? 1
How to stop help from poping up 1

Top