Hi,

The following is extracted from xl2007 help. I think it answers your first
question. (Not the answer you would like but that's life.)

Excel cannot automatically calculate a formula that refers to the cell €”
either directly or indirectly €” that contains the formula.

'Iteration' is the word to look up for repeated calculation. You might find
something helpful between there and the Add-in Solver but you will probably
need to place your assumed value in another cell.

Regards,

OssieMac



"V. K abbey" wrote:

i want to develop a formula where a cell value is first assumed to calculate
parameters of a machine.the parameter assumed is also obtained by calculation
. how to ensure that assumed value is replced with calculated value and all
calculations are repeted till difference between assumed and calculated value
is less than 0.1