Excel 2002, If Functions Problem

[phorneck]

Can someone help me with entering this IF Function.

If Hours<=40, then Gross Pay = Rate * Hours, otherwise Gross Pay = Rat
* Hours + 0.5 * Rate (Hours - 40)

I have attached the worksheet.

Thank

 

[JE McGimpsey]

One way:

Assume hours in A1, rate in A2:

=(A1+MAX(0,(A1-40)/2))*A2

 

[phorneck]

Thanks it worked. I was wondering if you could help me with a coupl
more?

If (Gross Pay-Dependents * 38.46) > 0, then Federal Tax = 20% * (Gros
Pay - Dependents * 38.46), otherwise Federal Tax = 0


If Soc. Sec. Tax * Gross Pay + YTD Soc. Sec. > Maximum Soc. Sec., the
Maximum Soc. Sec. - YTD Soc. Sec., otherwise Soc. Sec. Tax * Gross Pay

I really appreciate the help!

Thanks Again!!!!

 

[JE McGimpsey]

One way:

=MAX(0,(GrossPay - Dependents * 38.46) * 0.2)

 

[JE McGimpsey]

One way:

=MIN(SST*GP, MAX(0,MAXSST-YTDSST))