I want the sheet to read the money remaining for Food (D2) to be $0 and then the money remaining for Savings (D5) to be $39,780.īut things get much more complicated when we find out that we also overspent on Vacations which makes money remaining for Vacations (D4) to be $0 and money remaining in Savings to be $38,280 because it covered the overflow costs of both Food and Vacations (and would have covered any overspending from Clothing as well, if there had been any). So for Food, I budgeted $600 (D2) but spent $820 (D1). Where I really begin to encounter problems is when I do this for more than one expense. I am trying to create a formula that when an expense is above what was budgeted for it, rather than have the budget go negative, it is reduced to zero and the remaining balance if pulled from savings. I have been trying to create a formula for about an hour now and have gotten nowhere so I am looking for some help.
0 kommentar(er)
