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?
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?
