mutiply by either REG or OT hours, and SUM!
I tried the formula and it did not work. I need to sum and get the total for
about 60 employees, wouldn't some form of sumif be appropriate?
Thanks.
"Dave F" wrote:
Try: =IF(ISBLANK(D1),B1*C1,B1*C1+(D1*B1*1.5))
I'm assuming B is the hourly rate in the equation above.
Dave
--
Brevity is the soul of wit.
"Raza" wrote:
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?
|