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 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?

[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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_Carpet" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[B_Carpet]

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

[Ragdyer]

Appreciate the feed-back.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_Carpet" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>