Whenever Solver or goal seek is ran, the original value is replaced with a new value. How can I keep the old value yet show the new value on a blank cell or a separate sheet automatically?
This is a really basic example,
A1 = 200
A2 = 100
A3 = 100
A3=A1-A2
And if I set A3 to 0 by changing A2 in Solver or Goal Seek, I will get 200 in A2. 200 is the break-even amount I'm looking for but I still want my original data. And I don't want to memorize and write down the new result each time I ran solver/goal seek...and then click cancel to restore to the original data...is there an easier way to do this?
Bookmarks