Forum Discussion
Danna007
Nov 16, 2022Copper Contributor
Formula for budget
Hello- I am attempting to create a budget and have run into an issue. I have been able to create pretty simple and straight forward formulas for majority of sheet but I can't seem to figure out the c...
OasisBEE
Apr 28, 2023Copper Contributor
Just wanna add that you could use the formula =IF(B2>0,-B2,0) in the savings column, where B2 is the cell containing the savings amount. This formula will deduct the savings amount from your weekly income if it's positive, but leave it as 0 if it's negative.
- Sharmalion8Apr 29, 2023Copper Contributor
I've just stumbled upon this thread while browsing and I couldn't help but offer some advice. It's great to see that you're trying to create a budget and stay on top of your finances.
Have you tried using an app that helps plan finances? It might be able to simplify the process for you and provide you with some helpful tools.
As for your issue with the savings portion, have you considered using an ""if"" formula? You could set it up so that if the savings amount is positive, it deducts it from your weekly income, but if it's negative, it deducts it from your total savings.