Budgeting help please

missymugwump

Hi

I am trying to do a simple :mad: excel spreadsheet to do a monthly household budget
Sadly im not au fait with excel but am trying
Basically I am trying to get

Column E to = Column D minus Column C

Tried inserting this in column E to no avail

=SUM(D2-C2)




Any ideas anybody ?

(dont want the martin lewis one as I want to put the date in the far left column so it changes daily showing my cash flow or lack off ) :rotfl:

Thank you in advance

rusty-london

Try this link for a ready made Excel budget:

http://www.moneysavingexpert.com/banking/Budget-planning

I'm just starting on mine now!

missymugwump

Hi thanks but as I said I dont want the Martin Lewis one
I prefer my simple layout

I just need the help with the formula for excel

taless

Hi Missymugwump,

The formula should be:

=D2-C2

or =SUM(D2,-C2)

Both of which are correct & will give you the desired results.

=SUM(D2,-C2) to the computer becomes =D2+(-C2) which becomes =D2-C2.

missymugwump

Bless you thats great

Im guessing I then need to format the whole column ?
Do I just drag that all the way down ?


Sorry I really am out of my depth but trying LOL

taless

Yes, u'll have to drag the thing down, and Excel will automatically change the things for u... like changing from D2 to D3, C2 to C3 for example.

U may find that occassionally u need to 'lock' them, by pressing the F4 key on your keyboard. If you have $D$2, it will always be D2 no matter where you copy them to, if it is $D2, it will always be of the D column, but it can change from D2 to D3 to D4 etc., and if you have D$2, it will always be Row 2, but it can change to C2, E2, F2 etc.

Hope I haven't confused you!

missymugwump

Just a bit : -)


No seriously that is so helpful
Thank you very much