Help with IF function

N

netbrakr

Hello all,

I am doing my Excel hmk, but I having a though time doing the I
function.

I am trying to find the overtime pay. Here is an example.

Name Rate Hrs Regular Overtime
Barker, Bob 9.50 40 380.00

The overtime pay rate 1.5, so which means 14.25

Can anyone help me?

TIA

J
 
P

Peo Sjoblom

There is no OT in your example, otherwise you can get the hours like

=MAX(0,D6-40)

where D6 holds the hours worked

=MAX(0,D6-40)*overtime_rate

will give you the OT pay

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Top