Help with IF function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

netbrakr - 18 Mar 2006 22:13 GMT

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

Reply to this Message

Peo Sjoblom - 18 Mar 2006 22:46 GMT

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

Signature

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

> Hello all,
>
[quoted text clipped - 13 lines]
>
> JC

Reply to this Message