Here is my situation (example) in A2 I want to put an amount to transfer. In A3, I have a balance of -$1,406,687.79 In increments of $100,000, i want to use Goal Seek or Scenario Manager or a formula if it is possible, to generate the A2 number that leaves between -$100,000 and -$80,000 in A3.
So, for this example, I would like to be able to generate in A2: $1,300,000 (leaving -$106,687.79 in A3).
Thanks
Bookmarks