Basic Caluclations Using a formula

[B_Carpet]

hi i think this is a very basic question but, here goes any way

I have got a basic spreadsheet that i would like to use to do som
accounts it looks like:

Opening

Income
Receipts
TV
Transfer In
Sponsorship
Misc in
Total in

Expenditure
Wages
Maintenance
Transfer Out
Misc_Out
Total out

Closing

Now i'd like to get the closing number so for this on paper i'd just d


opening + Total in - Total out = Closing (total in and total out als
have formulas to get the total. For which i am having the same proble
i am trying to describe) I am sure this is the same for excel but fo
some reason it does not automatically update when i change the number
in the caculation

so if for example the cal was

11000 + 10000 - 3000 = 18000 but then one of the numbers changed so i
should be

11000 + 9500 - 3000 = 17500 all my numbers on my spreadsheet woul
still be showing the first numbers apart from the number i jus
manually changed.

How do i get excel to automatically change the numbers as i change th
spreadsheet

 

[Ragdyer]

Make sure your sheet is set to automatic calculation.

<Tools> <Options> <Calculation> tab,

And make sure "Automatic" is checked.

And maybe check out this link to an old thread as to why it might have
changed:

http://tinyurl.com/anahg

 

[B_Carpet]

ah brilliant thanks. i cannot believe it was that simple lol!

 

[Ragdyer]

Appreciate the feed-back.