Forum Discussion
Solved
IF Function to calculate multiple OT rates
I am struggling to write an IF formula that will calculate the gross pay based upon the following information: Dept. 1 employees receive straight time for 40 hours or less and double time for hours ...
With the first name in cell A2, put this formula in cell E2 and copy down:
=IF(D2<=40,D2*C2,(40*C2)+((D2-40)*IF(B2=1,2,3)*C2))
With the first name in cell A2, put this formula in cell E2 and copy down:
=IF(D2<=40,D2*C2,(40*C2)+((D2-40)*IF(B2=1,2,3)*C2))
IngeborgHawighorst Thank you so much for the help on this!