Goal Seek shows correct answer but won't stop iterations


New Member
I am running goal seek on two different workbooks. WB1 has an interest rate that modifies the value of the other workbook via basic multiplication. I am goal seeking the sum of the products. When I step through the goal seek iterations, it lands precisely on the sum I want. But goal seek continues to iterate as though a solution was not found.

It there a way to preserve he value of a goal seek mid iteration? Is there a reason why it is not thinking it found an answer?

Some videos you may like

This Week's Hot Topics