Forum Discussion
balance sheet formula
Hi I am trying to set up a formula wherby when I add a payment it automatically adds this to running total ie c3 +c4 is this possible
Here's how I would do it. You'll notice I combined Income and Expense tallying into one set of data; there's really no need to separate them as you did. I have them in separate columns, but this way the running total is the combined running total for all in or out transactions. Start with whatever your opening balance is. Then each row below that takes the value in that preceding row, and adds income and subtracts expense to produce a current running total.