Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mutiply by either REG or OT hours, and SUM!
I am trying to figure out a way to quickly generate a gross payroll number
without the aid of a 'helper' row, which won't work this situation. I have about 60 employees. Sample: NAME(A) PAY(B) REG(C) OT(D) Joe Worker 8 40 Jane Workr 8 Big Slacker 7.5 15 MR No Life 10 80 12 Mr. No Life also gets overtime at 1.5x his normal rate. The correct sum for this would be $1412.50. Any help? |