aspidistra
New Member
- Joined
- Sep 4, 2015
- Messages
- 2
Hi all,
I came to the conclusion I was never going to work this out on my own, despite reading and experimenting. Here's what I'm trying to do.
I'm creating a spreadsheet which will show me cash available on any given day and for days in the future, based on predicted income and expenditure. Essentially, I have a few columns for known expenses (rent, food, etc) and a column for any income that I receive.
What I can't work out how to do is create a variable which I can add or subtract from at will. Ideally, I'd use a formula within the worksheet to simply pool any income to give me available cash, and the subtractive equivalent to reduce that same pool every time I spend money. I can't seem to use a SUM column, as it simply tries to add a range of cells, as opposed to passing the value from the previous formula forward to the next.
This is probably something really simple but I'm not great with maths and my knowledge of excel is limited. Any help would be greatly appreciated.
I came to the conclusion I was never going to work this out on my own, despite reading and experimenting. Here's what I'm trying to do.
I'm creating a spreadsheet which will show me cash available on any given day and for days in the future, based on predicted income and expenditure. Essentially, I have a few columns for known expenses (rent, food, etc) and a column for any income that I receive.
What I can't work out how to do is create a variable which I can add or subtract from at will. Ideally, I'd use a formula within the worksheet to simply pool any income to give me available cash, and the subtractive equivalent to reduce that same pool every time I spend money. I can't seem to use a SUM column, as it simply tries to add a range of cells, as opposed to passing the value from the previous formula forward to the next.
This is probably something really simple but I'm not great with maths and my knowledge of excel is limited. Any help would be greatly appreciated.
