View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
new to excel new to excel is offline
external usenet poster
 
Posts: 2
Default new to excel need help with function

Total Hours Worked Wage/Hour Regular Pay Overtime Gross Pay

33 $38.00 $1,254.00
40 $29.00 $1,160.00 $-
46 $9.50 $437.00
46.5 $28.75 $1,336.88
40 $7.50 $300.00 $-

Can someone show me the IF that calculates the regular pay and the over
time pay at 1.5 over 40 hours

Thanks