MS Excel, spreadsheet formula.

[James07]

Okay, ive decided, as a new years res, that im going to manage my finances much better so i know exactly where EVERY penny goes...

Now what i need to do is have a start balance, a weeks worth of activity which will total up in the box at the end, and there is a box at the side of that which will now tell me my new account balance.

Is there anyway i can use formulas to get this working, been a long time since i used this..

Is it even possible?



Cheers,

James.

 

[James07]

Yeah but it isnt working..

I want to input my own data through the week and get a total at the end which will then add onto my account balance to make the actual balance on there the same on my account..

i cant explain this easily enough can i.. I dont know to put it..

Ill have a think and come back lol!!

EDIT: The sum isnt working either i.e. in cell N2 i want to add cells B to N.. so.. =SUM(B2+C2 etc..)

Isnt working..

 

[James07]

Snip

Its doing what it was doing before, in N2 its coming up with ##### i can only assume this means there is an error with numbers.

but there isnt thats the thing.

EDIT: you also need to make B3 = $O2, and fill that down.

I dont understand this bit?

Snip

Like the screenshot?

 

[James07]

You want column 0 to have your end of week account balance, so the end of week 1 will be the same as the start of week 2. Using the dollar signs just means you can fill the formulae you want. I've just tried the ones I suggested with your numbers and a random bank balance, and it seems to be working fine.

Do you have msn? I could send you this..

Im having no luck with it at all.

 

[James07]

Its all done now, all sorted, looking brilliant, sure will help me understand my finances now!!

Cheers to all who helped.