Circular Reference

The 2 easiest approaches I see (and neither of them really involves Macros/VBA):

1) It seems that in a previous thread of yours, I suggested that you first find an algebraic solution to the problem, and you didn't seem to like that suggestion. However, I'm going to suggest it again. Many problems like this can be readily solved if you will examine the equation you are using to see if it can be rearranged to eliminate the circular reference. I haven't looked at it in great detail. If you spend enough time with the algebra, I expect you can come up with rearranged formulas that will allow you to calculate D8/D9 without the circular reference.

2)

For avoiding the circular reference what im doing now is past special the value of Cell D8 in to cell D9 to multiple times to get the value of cell D9=D8.

If you are at all familiar with numerical algorithms, this is one that is often called the method of "successive approximations." If you are willing to turn iteration on (In the Excel options dialog https://support.office.com/en-US/Art...rs=en-US&ad=US ), then you may be able to solve the problem as is with the formula in D9 =D8 (it seems to work just fine for me, since I routinely have iteration enabled). Iterative calculations with circular references require a little extra care when programming them into the spreadsheet, but, with that extra care and thought, they can be quite useful.