I am working on a payrol tracking worsheet. I have everything right but one
step. I need the function not to calculate overtime if there is an amount in
the Salary dell. Here is an example of my data and then an example of the
formula I have written. Under the cell containing the Hourly Pay eran, I have
this fomrula : =IF(C11<=40,C11*D11,IF(B110,(C11-40)*(D11*150%)+40*D11)) Can
someone help me out. I've been trying ot figure this out for 4 hours now.
Thanks

Hourly pay
Employee Sales Hours Worked HourlyPay Commision Earned Payroll Amount
Tommy $3,675.00 45 $10.00 $367.50 $475.00 $475.00

More detail. What is happening, do you want to happen?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Amy" wrote in message
...
I am working on a payrol tracking worsheet. I have everything right but
one
step. I need the function not to calculate overtime if there is an amount
in
the Salary dell. Here is an example of my data and then an example of the
formula I have written. Under the cell containing the Hourly Pay eran, I
have
this fomrula : =IF(C11<=40,C11*D11,IF(B110,(C11-40)*(D11*150%)+40*D11))
Can
someone help me out. I've been trying ot figure this out for 4 hours now.
Thanks

Hourly pay
Employee Sales Hours Worked HourlyPay Commision Earned Payroll
Amount
Tommy $3,675.00 45 $10.00 $367.50 $475.00 $475.00