How Can I Use IF STATEMENTS IN EXCEL To Get Hourly Wages And Overtime?

2 Answers

John Nawrocki Profile
John Nawrocki answered
| A | B
|______
|Hours Worked | 52
|Overtime Rate | 1.5
|Hours until overtime | 40
|Pay rate | 15
|Overtime Rate | =Pay_rate*Overtime_Rate
| |
|Regular Hours | =IF(Hours_Worked>Hours_until_overtime,Hours_until_overtime,Hours_Worked)
|Overtime Hours | =IF(Hours_Worked>Hours_until_overtime,Hours_Worked-Hours_until_overtime,0)
| |
|Regular Pay | =Regular_Hours*Pay_rate
|Overtime Pay | =Overtime_Hours*Overtime_Rate
| |
|Total Pay | =Regular_Pay+Overtime_Pay

The answers to the formulas are:
Regular Pay $600.00
Overtime Pay $270.00

Total Pay $870.00

Use Col A to name ColB

Answer Question

Anonymous