Not quite sure what you are after and how iteration is necessary to
obtaining the solution.

Clarification: So you know A and C4 and you are trying to solve for
E4?

Assuming this is the problem:

Solution 1: Solver can do this, but it can be tedious running solver
manually when you have several equations to solve. Depending on your
math skills, this might be the easiest to implement in spite of its
tediousness.

Solution 2: Algebraically manipulate the equation into something of
the form 0=a*E4^2+b*E4+c, then use the quadratic equation to solve
[-b+/-sqrt(b^2-4ac)]/2/a.

Solution 3: Set up an set of iterative functions using the
Newton-Raphson's method (or other numerical root finding technique)
that will find the roots of the equation in solution 2. You would need
to turn iteration on (Tool - Options - calculation tab). This is the
same way that Solver works, only you can get it set up and not have to
call the Solver dialog each time you want a new solution.

Any way you try to do it, recognize that there will be two possible
solutions, they aren't always unique, and they aren't always real (and
Excel doesn't inherently know how to handle complex numbers).


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=399607