Creating a cell that is uses a formula to provide dollars based on a % or a manual entry

[frankday]

I am working on a sheet that projects the amount of money each month should be put into an account to reach a goal at the end of the year. Amount transfers into the account is based on sales percentages for each month of the previous year.

Goal $80,000
B2:M2 has a list of months
B3:M3 is the percentage of the total years sales was in that month
A4 is the amount to put into the account based on the % of sales for that month
A5 is the manual adjusted amount

What needs to happen is, if I manually change the amount in March I need the other months to adjust so the total is still the goal amount. Or if I want to manually adjust multiple months the non manual values in line A4 need to self adjust so that the final total is equal to the goal.

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.