Hot Topics

Very, very simple spreadsheet

  dagbladet 12:34 15 May 2007
Locked

Notwithstand the subject title, I admit I don't know how to achieve what I need.

Which is, the club has a budget of £500, when I make a purchase of stationary for £30, I would like to see the running total now read £470. I've looked at the download section and I have Excel. I just don't know where to start. Any ideas please?

  dagbladet 13:55 15 May 2007

That'll do nicely. Lovely job folks, thanks.

  dagbladet 13:57 15 May 2007

That's it eddie, a simple cashbook. It works fine and to have done it myself...alright, alright, you lot helped. I'm right chuffed with it.

ta.

  Furkin 14:07 15 May 2007

Hope i'm not treading on toes here,,,
What I did was put say £500 in A1.
Left click on A1 & drag down to say A20 (to highlight the row).
Click on Format > cells > numbers > accounting.
this makes all the highlighted column in 'accounting mode'.
Then L-click on A1 again,,, & hold button down & drag to A20 (to highlight row again), & click on Autosum.
You should see £500 in cell A20 as well as A1.
If you put - 30 (minus 30)in cell A2,,,, the number in A20 will show £470. If you put - 25 in A3, the 'sum' will be £445.
Once set up, you don't need to do any anything else each time, except put the deduction figure in below the last.
((if you don't put - (minus) it will 'add' the number instead of deduct it))
This works for me, though I accept that purist Excel users may say that it's the wrong method.
Good Luck

  dagbladet 15:33 15 May 2007

I'll give that a bash as well, thanks.

  dagbladet 15:37 15 May 2007

Furkin

Where is Autosum?

  dagbladet 15:39 15 May 2007

Found it.

  dagbladet 15:54 15 May 2007

Great that works too. Thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei P40 Review

Affinity offers Photo, Designer & Publisher for Free for 3 Months

New iPhone SE could launch 'as early as today'

Les meilleures offres gratuites pendant la période de confinement