If statment problems

QuestionEdit

the problem to fing the overtime formula by if statement if we have overtime =1.25*overtime houre<5+1.5*overtime hours >=5 if we have :

Emplotee Name Marital Status Hourly Wage Regular Hours Overtime Hours

Alice M 8.2 40 0 Jhon M 9.45 40 7 Martha U 9 40 9 Martin M 11.25 35 0 Peter U 14.5 10 2 Sara M 12.25 32 0 Amith U 10.15 40 5 Tony M 9.25 38 0 ineed the formula of overtime?

AnswerEdit

Muneera,

Assume Jhon's data is in row 3 in the cells designated. Then In F3 or another cell in that row, you could use the formula shown to calcualte the

A3: Jhon B3: M C3: 9.45 D3: 40 E3: 7 F3: =If(E3=0,0,(Min(E3,5)*1.25+Max(0,E3-5)*1.5)*C3)

I believe that should give you what you want.