Spreadsheet help please

greebo1


Joined: 21/06/2009
Posts: 17

Message Posted:
03/08/2010 17:10

Could anyone please give me a bit help on how to do formula on a spreadsheet to do very basic things in columns

i.e. income - out goings and balance left

Understand a little and got it to add using auto sum but then it went funny?



Thanks

Hector


Joined: 26/08/2008
Posts: 2352

Message Posted:
03/08/2010 17:17

Have a look at lynda.com there are some free video tutorials on software like Excel

HNComputers


Joined: 23/08/2009
Posts: 472

Message Posted:
03/08/2010 17:18

you would have to do formula's in bracets like =SUM(column number-column number) and press enter - it is best to do it manually rather than autosum. for example, I would like to add up everything I have in 1 column, so I wouldgo to the end of the column and type =SUM(A1+A20) and press enter.



I hope that makes sense....

Hector


Joined: 26/08/2008
Posts: 2352

Message Posted:
03/08/2010 17:20

What software are you using?

HNComputers


Joined: 23/08/2009
Posts: 472

Message Posted:
03/08/2010 17:26

its called brain.com lol

joandjelly


Joined: 24/02/2008
Posts: 2953

Message Posted:
03/08/2010 17:27

If you have your income in column A cell 1 and outgoings starting in cell 1 of column B then in cell 2 of column A you would put the formula =sum(click cell in A [type in minus sign] then click cell in B) and press return. Then in cell 2 of column B your next outgoing and so on. To copy down the formula in column A hovver your mouse over the bottom right corner of the cell until a + sign appears, double click and drag it down for as many cells as you want. Whenever you add a new outgoing in column B the sub-total in column A will change.

Hope you understand this (and more importantly, I hope it works).

HNComputers


Joined: 23/08/2009
Posts: 472

Message Posted:
03/08/2010 17:31

sorry it was meant to say =SUM(A1:A20) would = your total on one column

emineden1


Joined: 22/12/2008
Posts: 512

Message Posted:
03/08/2010 19:10

hi greebo1, i live in karsiyaka. if i can be of any help call me on 0533 862 4001



dennis

scruff


Joined: 15/07/2008
Posts: 1070

Message Posted:
03/08/2010 19:53

Also use * for multiply & / for divide.

e.g enter =A1*C1 in, say E1, to multiply the number in column A by the number in column C & copy this formula right down column E.

Using Excel things soon start to fall in place.

Do all the formatting at the end, when you have the basics of the spreadsheet sorted.

Linnyloos


Joined: 30/11/2008
Posts: 483

Message Posted:
03/08/2010 20:11

I have a spreadsheet if anyone wants it. Arthur you have email.

Pippie


Joined: 02/12/2009
Posts: 1288

Message Posted:
03/08/2010 20:24

If you can't get you're head around the formula you want, write it down longhand first. Put brackets around each section of the formula to keep each 'bit' separate. Then bit by bit, exchange you're longhand formulas in each set of brackets, for their corresponding Excel formulas - don't forget to keep the brackets in place.



eg, where income this month is in A1 and your expenditure is in a list A3 to A20, your balance at the start of the month is in A22, and you want the running total to be displayed in cell A23



In other words, ((add up expenditure or SUM (A3 to A20)) (take it away from income A1)) (add that all to the balance at start of month A22)



type in A23:

=A22+(A1-(sum(A3:A20)))

greebo1


Joined: 21/06/2009
Posts: 17

Message Posted:
03/08/2010 22:38

Thank you very much for all this information.

I am going to have a go at this in the morning - I have read everything through quite a few times and think I've got it

so will let you know how I get on and thanks Dennis I may well be calling you!



G1