I'm new at excel

heathermm · Apr 18th, 2002, 06:01 PM

If somebody could please help me with this I would appreciate it. I'm know this is very easy for everyone else but I just don't get it. Tutorials read like jibberish
All I need to do is calculate hours and wages.
e.g.
column a name
column b wk 1 hours
column c wk 2 hours
column d total of hours
column e wages
column f hrs multiplied by wages
Also is there a way to apply this function for everyone at the same time or do I need to apply the function for every employee
I would also like to get a total of each column.
Thanks in advance for any help.
Heather

anno · Apr 18th, 2002, 06:40 PM

in column d put =B1+C1 or =SUM(B1:C1). double click on the fill handle (bottom right of cell) to copy the formula down to the last row you have data in.
in column f put =D1*E1 and do the fill handle thing again.
to total all columns, at the bottom of column b put=SUM(B1:B20) [adjust the cell range to suit]. drag the formula across to row f using the fill handle. to total column a put =COUNTA(A1:A20), again adjusting the cell range to suit.
is that what you wanted?

[ This Message was edited by: anno on 2002-04-18 17:41 ]

heathermm · Apr 19th, 2002, 08:10 PM

I appreciate the help you've given me, now just one more REALLY STUPID QUESTION. I've put in all of the formulas but nothing is adding up. It just continues to have the formula in the cell. How do I get it to perform the calculation.

Heather

kinkyparamour · Apr 19th, 2002, 08:16 PM

Did you put the = sign front of the formula? Also you can go to tools/options and be sure formulas does not have a check mark next to it........

Denny

[ This Message was edited by: kinkyparamour on 2002-04-19 19:20 ]

heathermm · Apr 19th, 2002, 08:18 PM

YES WASN'T I SUPPOSED TO.

kinkyparamour · Apr 19th, 2002, 08:21 PM

Sorry, you got ahead of me. Yes, the = sign should be there. now check the tools/options and look at formulas, this should not be checked.....

Denny

[ This Message was edited by: kinkyparamour on 2002-04-19 19:22 ]

Yogi Anand · Apr 19th, 2002, 08:22 PM

Quote:

On 2002-04-19 19:10, heathermm wrote:
I appreciate the help you've given me, now just one more REALLY STUPID QUESTION. I've put in all of the formulas but nothing is adding up. It just continues to have the formula in the cell. How do I get it to perform the calculation.

Heather

Hi Heather:
You did start the formulas with an = sign ... Right! and if it still shows only formulas and not the results of the formulas, chances are your spreadsheet is set up to show formulas and not the results -- if that's the case you can toggle it back to show formula results by
PRESS and HOLD the CTRL Key and then press ` key (the key under the ~ key near top left hand corner of the keyboard)

HTH

Please post back if it works for you ... otherwise explain a little further and then let us take it from there!

heathermm · Apr 19th, 2002, 08:59 PM

Oh my gosh, you guys are great! Yes this worked. I am so thankful, it will save me a lot of manual work. I tried the control ` key and everything just filled in.
Again thanks
Heather

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 06:01 PM	#1
heathermm New Member Join Date: Apr 2002 Posts: 4	If somebody could please help me with this I would appreciate it. I'm know this is very easy for everyone else but I just don't get it. Tutorials read like jibberish All I need to do is calculate hours and wages. e.g. column a name column b wk 1 hours column c wk 2 hours column d total of hours column e wages column f hrs multiplied by wages Also is there a way to apply this function for everyone at the same time or do I need to apply the function for every employee I would also like to get a total of each column. Thanks in advance for any help. Heather

Apr 18th, 2002, 06:40 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	in column d put =B1+C1 or =SUM(B1:C1). double click on the fill handle (bottom right of cell) to copy the formula down to the last row you have data in. in column f put =D1*E1 and do the fill handle thing again. to total all columns, at the bottom of column b put=SUM(B1:B20) [adjust the cell range to suit]. drag the formula across to row f using the fill handle. to total column a put =COUNTA(A1:A20), again adjusting the cell range to suit. is that what you wanted? [ This Message was edited by: anno on 2002-04-18 17:41 ]

Apr 19th, 2002, 08:10 PM	#3
heathermm New Member Join Date: Apr 2002 Posts: 4	I appreciate the help you've given me, now just one more REALLY STUPID QUESTION. I've put in all of the formulas but nothing is adding up. It just continues to have the formula in the cell. How do I get it to perform the calculation. Heather

Apr 19th, 2002, 08:16 PM	#4
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Did you put the = sign front of the formula? Also you can go to tools/options and be sure formulas does not have a check mark next to it........ Denny [ This Message was edited by: kinkyparamour on 2002-04-19 19:20 ]

Apr 19th, 2002, 08:18 PM	#5
heathermm New Member Join Date: Apr 2002 Posts: 4	YES WASN'T I SUPPOSED TO.

Apr 19th, 2002, 08:21 PM	#6
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Sorry, you got ahead of me. Yes, the = sign should be there. now check the tools/options and look at formulas, this should not be checked..... Denny [ This Message was edited by: kinkyparamour on 2002-04-19 19:22 ]

Apr 19th, 2002, 08:59 PM	#8
heathermm New Member Join Date: Apr 2002 Posts: 4	Oh my gosh, you guys are great! Yes this worked. I am so thankful, it will save me a lot of manual work. I tried the control ` key and everything just filled in. Again thanks Heather