I'm trying to figure out a formula to make my budget easier to use. Basically, I've set it up that when I make a deposit or payment, I document it under a specific category such as food or rent, etc. and it subtracts it from the set amount I have on budget worksheet. But now I want to set it so I can make note of deposits, but as I withdraw or spend money, the deposit amount goes down. For example: The first row will be Deposit and it will add up as I deposit money into my account and document my deposits. The next row will have a set amount for my rent and as I spend money, it subtracts from that amount. Once the set amount is spent, it should subtract from the next row and so on. I'm basically trying for a cascading effort. I set a max value and when it hits that number, it moves to the next row. The reason I am doing this is to keep better track of how much is in the bank and how much I'm spending.
How should I go about setting this worksheet up? I already have a template budget set up, but I can't figure out how to get the cascade working. Thanks!
Bookmarks