How Can I Use IF STATEMENTS IN EXCEL To Get Hourly Wages And Overtime?
Need it quick
1 Answer - Sort by: Date | Rating
| 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_Worke
d)
|Overtime Hours | =IF(Hours_Worked>Hours_until_overtime,Hours_Worked-Hours_until_overtim
e,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
|__________________________________________
|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_Worke
d)
|Overtime Hours | =IF(Hours_Worked>Hours_until_overtime,Hours_Worked-Hours_until_overtim
e,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
0
0
- How Are Numbers And Characters Stored In A Computer?
- Which Are Better Digital Or Analog Filters?
- How To Stored Music On Data D Drive?
- How Does Data Flow Around A Personal Computer?
- I Have 6 Java Updates On My Computer Taking Up Alot Of Disk Space, Can I Delete The Older Ones Without Causing Problems?
- How To Turn On A Built In Web Cam For Windows Vista?
- How To Put New Ink Cartridge In Hp Officejet J3640 Printer?
- How Many Gigabites Does Regualr Computer Hold?
- What Other Factor Did Koppen Use In Classifying Climates?
- What Was The Effects Of The Microprocessor?
- List 4 Peripherals That Provide Input?
- What Do U Mean By Information Architecture?
- What Are Royalty Websites?
- How To Restore Factory Settings For Windows Xp?
- What Dialog Box Inserts A Vertical Line Between Columns?
- How Many Sub Nets Does The Chosen Subnet Mask Produce?
- What Is The Purpose To Have Networking?
- What Is Rp Power?
- What Are The Advantages And Disadvantages Of Using Computers For Along Time?
- How Does Combustion Works In Cars Print In Brochure Form?
- When Printing My Incoming Emails The Letters Are To Small, How Do I Make Them Larger?
- When I Print Out My Emails, The Lettering Is Too Small How Do I Adjust?
- How Do You Write A Report On Someone When All The Computer Gives You Is A Guy Thats Dead? When You Need A Guy Thats Alive Named Benjamin Williams He Is A Politician
- What Are The 3 Most Common Output Devices?
- What Are The Advantages And Disadvantages Of Compurters Electronic?
- Hourly Rate-6.00 ,What Is The Overtime?
- How Much Does 30000 Translate In Hourly Wages?
- How Much Is $40000 Translate In Hourly Wages?
- How Much Does $60000 A Year Translate In Hourly Wages?
- How Much Is $60000 Annual Salary In Hourly Wages?
- How Much Does $30000 A Year Translate In Hourly Wages?
- How Much Does $40000 A Year Translate In Hourly Wages?
- How Much Is 60,000.00 Annual Salary In Hourly Wages?
New Comment - Comments are editable for 5 min.