Help with If statement

[Dirtyfifi]

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

[mewingkitty]

What's with the reference to "E"?

it only calculates 7.25 by the hours worked no matter what comes up in F2

I'm not getting that result at all.

[Dirtyfifi]

What's with the reference to "E"?

E2 is the total hours. 8.00 right now with that setup my Pay shows up as $58.00

[mewingkitty]

D is your total... I thought.... E is your "Hours worked".
If you could post an actual example that might help?

[Dirtyfifi]

the first post is my actual project. I am doing this for my supervisor to limit the amount of information he needs to type on the computer. right now he has to do everything on a calculator then input it into excel.

To clarify more this is a 3 tier pay scale with the exception of not making 165/hr then its hours by minimum wage.

A2-Start
B2-Stop
C2-Break
D2-Total Hours
E2-Total Pick
F2-Average Per Hour
G2-Total Pay

http://img5.gr4f.com/5f14f86304.jpg

[Dirtyfifi]

Hurray figured it out.

changed F2 to =(D2/E2)*(1-2) the way i had the cell formatting it was coming up as a negative number. that fixes all my problems =)

thanks for the semi help and possibly for future help.