I'm using Excel for my Budget, and I have a question.
If I put a value at the top of a spreadsheet, lets say $200 (a starting dollar amount), and the column to the left of that will be where I place expense amounts (purchases), how can I put subtraction functions to automatically calculate the amount left (from the original 200) without the 200 showing in all the fields...
That probably makes no sense... Picture it like this:
In H3, I have $200 (the whole H column is for amount left over from the 200)
The G column will have dollar amounts spent, so lets say I buy a DVD and it cost 15, I put that 15 in block G4.
I know how to input a subtraction function in each cell in column H, but how do I put those functions in without 200 showing in all the cells before I actually input the expense amounts...
Hopefully that makes sense...
Please help me put together my budget sheet....
Bookmarks