Basic Caluclations Using a formula
 

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 some
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 do


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

so if for example the cal was

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

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

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


--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile: http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=389695

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_Carpet" wrote in
message ...

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 some
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 do


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

so if for example the cal was

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

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

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


--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile:
http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=389695

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


--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile: http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=389695

Appreciate the feed-back.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_Carpet" wrote in
message ...

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


--
B_Carpet
------------------------------------------------------------------------
B_Carpet's Profile:
http://www.excelforum.com/member.php...o&userid=20207
View this thread: http://www.excelforum.com/showthread...hreadid=389695