Microsoft Excel Coding Question

[Vigilante_26]

I'm looking for a line of code that can calculate the following:

For each hour worked over 40 (overtime) up to 60 is paid at 50% on top of their base pay (x1.5), while each hour worked over 60 is paid at 100% on top of their base pay (x2).

Any suggestions?

e.g., cells A2-A4 will be generic names, cells B2-B4 will be their base pay and cells C2-C4 will be the hours worked, cells D2-D4 will have said equation.

[Vigilante_26]

My best guess is something like this:

=B2*C2+IF(B2>40&<60*1.5,(B2>40&>60*2(B2-40)*F2,0)

[Rooster]

The simplest way to do this would be to use two more columns after the Hours Worked. One will store the amount of hours worked over 40, but under 60.
Formula in D2 will be "=IF(C2>40,IF(C2>60,20,C2-40),0)"
The E column will store the amount of hours worked over 60.
Formula in E will be "=IF(C2>60,C2-60,0)"
Finally, you can calculate the pay for the period in column F. Formula will be "=(B2*C2)+((B2*1.5)*D2)+(B2*2)*E2)"

Hopefully, that helped.

If this wasn't quite what you were asking for, let me know.