IF Function to Calculate Overtime Pay in Excel
Loading...
Link to this comment:
Uploader Comments (rrphillips)
All Comments (33)
-
Thanks so much!!
-
Thank you so much! Very clear explanations...More than I've learned from my professor who I actually pay to teach me.
-
Awesome videos. Thanks a ton.
-
This is a great video for calculating the overtime pay, its good Thanks for ur good video
-
Ralph, as an online instructor in Excel I am always on the lookout for nicely done video references on different calculation techniques. This is a very well done instructional video. Thank you.
-
I would rather had you explained how to calculate the whole formula in one. I have to find commission as well as one employee's overtime pay. All in one would be best but this is good. I can make it work, I hope anyways. I have never used excel but have to do this for my final paper in my excel class. Not having good luck here. :( Thank you.
-
I would rather had you explained how to calculate the whole formula in one. I have to find commission as well as one employee's overtime pay. All in one but this is good. I can make it work in my spreadsheet. Thank you.
-
yes simplified and well explained when using the if function this is great i so recommend, also gud showin another way using the minimum formula even though the main focus was using the if function.
-
THANK YOU!!!!!!!!!!!! YOU ARE A LIFE SAVER
4:15Future Value Function in Excelby rrphillips20,090 views
Featured Video- 14:46CIS 195 Final Exam Review - Part 3by rrphillips216 views
- 11:42CIS 195 Final Exam Review - Part 4by rrphillips126 views
- 11:22CIS 195 Final Exam Review - Part 1by rrphillips252 views
- 13:55CIS 195 Final Exam Review - Part 2by rrphillips150 views
- 9:59Excel Logic Functions - IF, AND, and ORby rrphillips9,050 views
- 6:45Excel Tutorial Using the IF AND and OR Function...by teachucompinc34,390 views
- 6:38Left, Mid, and Find Function in Excel 2007by rrphillips29,728 views
- 8:18Combining MATCH and INDEX - Excel for Business ...by raycolondotcom21,501 views
- 8:52Construction Schedule using Excel Templateby Queegebo07177,596 views
- 2:29VLOOKUP - Check which values matches in two col...by jmgmad21,712 views
- 9:11Microsoft Excel VLOOKUP Function Tutorial Part 2by MotionTraining53,861 views
- 3:58Nesting IF and AND functions in Excel 2007by sharonlibrarian11,806 views
- 10:48Excel 2007 Tutorial: Formulasby johnsdre75,137 views
- 8:13How Does Excel Calculate Time?by DannyRocksExcels21,153 views
- 5:00Excel Tutorial - IF functionby supernicko7915,172 views
- 4:54Excel Magic Trick 398: VLOOKUP with Two Lookup ...by ExcelIsFun30,882 views
- 6:47Microsoft Excel VLOOKUP Tutorialby 599CD356,649 views
- 3:29Overtime Calculation - Completely Automatedby AttendHRM3,760 views
- 5:06Excel If Statementby claytonLock56,332 views
The base pay formula can be simplified from:
=IF(E5>40,D5*40,D5*E5)
To this:
=MIN(40,E5)*D5
geertdd 2 years ago 5
excellent! great idea.
rrphillips 2 years ago 3