MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Solving an equation


Posted by Dr Neil Grice on December 05, 2001 6:35 AM

Anybody help?
I am attempting to use excel to solve an iterative equation.
I need to adjust one cell, which in turn will alter the value of another cell,
to achieve a balance from a third cell.
Using Goal Seek does not apper to work.

Any clues?


Posted by faster on December 05, 2001 8:19 AM

Try solver, you may need to add it in.
Tools/Add-Ins/Solver

Or allow Excel to use iterations.
Tools/Options/Calculation/Iterations (checked)