Results 1 to 6 of 6

Help with If statement

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Help with If statement

    The whole document works but the last one i need. I'll post it all just in case i have an error elsewhere.

    Start Time -- Stop Time -- Break -- Total -- Hours Worked -- Average -- Pay
    6:00 -------- 3:00 ------- Yes ---- 1600 -- 8.00 ----------- 200 ------ $xx.xx


    E2 Formula for time: =IF(C2="Yes",(((A2*24+12)-(B2*24+24))+1),((A2*24+12)-(B2*24+24)))

    F2 Formula for average: =D2/E2

    and now for the problem one.

    G2 Formula for pay: =IF(F2<165, E2 * 7.25, IF(F2<180, D2 * 0.07, IF(F2<190, D2*0.08, D2*0.09)))

    Just to break that formula down more:
    0 - 164 = 7.25 * Hours Worked
    165 - 179 = 0.07 * Total
    180 - 189 = 0.08 * Total
    190+ = 0.09 * Total

    it only calculates 7.25 by the hours worked no matter what comes up in F2
    Last edited by Dirtyfifi; 12-15-2009 at 11:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1