I need to know how to get this column to say: If the hours worked are more
than 40 then take time and a half and multiply that times the difference
between the hours worked and 40 and in that same cell add the regular hour to
the overtime pay. i've got it about 98% done but cannot get the last part.
please help me with this if you can. my spreadsheet is below and the IF
statement looks like this:

Hours Worked Hourly Pay Commission Earned Hourly Pay Earned
C D E F
1 30.00 $10.00 $562.50 $300.00
2 25.00 $10.00 $300.00 $250.00
3 40.00 $10.00 $825.00 $400.00
4 45.00 $15.00 $- $112.50
5 40.00 $12.50 $- $500.00
6 35.00 $10.00 $267.00 $350.00

In cell F: =IF(C240,((D2/2)+D2)*(C2-40),C2*D2)

Thanks so much in advance!
Raymond