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