Help with IF function
 

Hello all,

I am doing my Excel hmk, but I having a though time doing the IF
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

JC


--
netbrakr
------------------------------------------------------------------------
netbrakr's Profile: http://www.excelforum.com/member.php...o&userid=32593
View this thread: http://www.excelforum.com/showthread...hreadid=523954

Help with IF function
 

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




"netbrakr" wrote in
message ...

Hello all,

I am doing my Excel hmk, but I having a though time doing the IF
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

JC


--
netbrakr
------------------------------------------------------------------------
netbrakr's Profile:
http://www.excelforum.com/member.php...o&userid=32593
View this thread: http://www.excelforum.com/showthread...hreadid=523954