Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formulas (windows 2000)

    I am having difficulty on putting formulas into this work sheet, any assistance would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: formulas (windows 2000)

    I have moved this post from the Word forum to the Excel forum.

    StuartR

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: formulas (windows 2000)

    Welcome to Woody's Lounge!

    See the attached workbook. The formulas are quite simple, the essential part is the use of relative references to the cells in the payroll table, and of absolute references to the cells in the common parameters area E14:E17. When building a formula, references to cells within the same sheet are relative by default, e.g. D6. By selecting a cell reference and pressing the function key F4, the reference becomes absolute: $D$6. Applying relative and absolute references carefully enable you to enter the formulas in row 4, in F4:J4, then fill them down as far as needed, to row 10 in this example.

    Note: I was confused at first, because you had formatted the overtime rate as as dollar amount.

Posting Permissions

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