Would appreciate any help on how to do this!
I have a spreadsheet with the following info:

Name CurrentBase %Increase AmtIncrease NewBase
John 20,000 user input 5% auto calcs $1,000 calcs 21,000
Jay 20,000 auto calc 5% user input $1,000 calcs 21,000

I would like to be able to input a % increase which will automatically calc
the amount of increase, add it to the base and generate the New base OR input
an amount increase which will reversely calculate the % increase and generate
the New base.

Thanks in advance!