I'm new at excel
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: I'm new at excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YES WASN'T I SUPPOSED TO.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com