transfer cell $ amount to other sheet month-to-month without overc

C

Colin2u

I am trying to do a budget plan for an entire year going into the next. I am
trying to have it transfer the savings ($ amout) of the current month to the
next month and have the that saving be added to any possible savings of the
next if it is to be. here is what i have in theary: If the item in cell "H30"
is possitive but also greater than the item in cell "K42", show a savings and
have it be transfered to the next month budget plan.
is that a possible task?
 
B

Bryan Hessey

For the current sheet, to show the amount that will be transferred,

=if(and(h30>0,h30>k32),h30-k32,0)

or, for the next sheet

=IF(AND(Sheet1!H30>0,Sheet1!H30>Sheet1!K32),Sheet1!H30-Sheet1!K32,0)

et
 
Top