Microsoft Excel Help!!! Please

Harriets_Mum

Hi All,

I am trying to sort ou our finances (arn't we all?!)

Anyhow will cut to the chase... I am trying to make an excel spread sheet similar to that of a bank statement so I can work out how much were spending and keep a track of things.

My question is would I do the sums? as it doesnt seem to want to let me subtract anything in a sum! Is there a template or this? please help..

I wanted something like this

Date Details Withdrawn Paid in Balance
01.01.09 Money £10.00 £100.00 £90.00
02.01.09 Money £10.00 £0.00 £80.00

How would I get it to do those sums automaticaally so its just a case o me typing whats gone in and out?

Thanks in advance.....

john_s_2

OK...

Say you have £100 in A1 and £10 in A2, and you want the result of adding them together to show in A3. In A3 enter:

=A1+A2

and press enter.

That should get you started.

Oh, hang on, what you pasted shows:

01.01.09 Money £10.00 £100.00 £90.00

Is that all in one cell? You need to show the different information in different cells. (So the date in column A, the description in column B, etc.)

crampo_2

Is this any good , just whipped it up?

http://www.!!!!!!/file/6831818/42a47d0e/BankST.html

When you need more just highlight the last five boxs , so one that one it would be " 8/1/2009 | Money | £10.00 | £10.00 | £70.00 " and there should be a little black square in the bottom right hand corner of the blue highlight cells , when you hover over it , your cursor will become a little plus signm hold and drag that black box down the page to as far as needed

Harriets_Mum

Hi John,

Ihave put all info in different cells and have worked out how to add ie
=sum(A1+A2) however what I wanted to do was similar to that of a bank balance.

The sum I was trying to do was =SUM(E4+C5-D5) it adds the e4 and c5 but then also adds d5 and I wanted it to subtract d5. If I'm making any sense at all? So i can work out monies going in and out.

Any ideas much appreciated.

crampo_2

Harriets_Mum wrote: »

Hi John,

Ihave put all info in different cells and have worked out how to add ie
=sum(A1+A2) however what I wanted to do was similar to that of a bank balance.

The sum I was trying to do was =SUM(E4+C5-D5) it adds the e4 and c5 but then also adds d5 and I wanted it to subtract d5. If I'm making any sense at all?

Any ideas much appreciated.

Have you tried that file i linked to , it will save you time.

Harriets_Mum

Hi Crampo

ooop's no didnt see that, only have a dongle internet working on GPRS!! Trying to look now! Could make a cup of tea in the time this dongle takes to work sometimes!!

crampo_2

Harriets_Mum wrote: »

Hi Crampo

ooop's no didnt see that, only have a dongle internet working on GPRS!! Trying to look now! Could make a cup of tea in the time this dongle takes to work sometimes!!

Lol sounds like a plan.

splishsplash

I would just use the formula =E4+C5-D5

If you want to use SUM, try =SUM((E4+C5)-D5)

Harriets_Mum

For some reason the link you sent crampo doesn't seem to want to open I have thought of smashing this dongle thingy bob, but I suppose if I wanted fast internet I wouldn't live in the countryside! Will keep trying to load it though you never know!!;)

splishsplash wrote: »

I would just use the formula =E4+C5-D5

If you want to use SUM, try =SUM((E4+C5)-D5)

Thanks will give that ago!!

crampo_2

Harriets_Mum wrote: »

For some reason the link you sent crampo doesn't seem to want to open I have thought of smashing this dongle thingy bob, but I suppose if I wanted fast internet I wouldn't live in the countryside! Will keep trying to load it though you never know!!;)



Thanks will give that ago!!

Sorry About that. If you still need it , its at this one as well:
http://www.mediafire.com/download.php?qjvzgmuddvd

Harriets_Mum

Thanks will give that ago...

for some strange reason using the sum wasnt working however crampo finally this link loaded!! Yay wooo!!

Thanks soooo sooo much, you just saved my sanity and computer!! However I'm sure that is the same sum I was using hmmm ahh well I must just be pants!!

Thanks again!!