Excel if Functions

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

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(B11>0,(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)
 
Back
Top