IF Function to Calculate Overtime Pay in Excel 

WOW 2023 Thank you so much, this is grate tutorial.

Thank you so much! This really helped me out! I'm very new to excel and you explained it in a way that I could understand.

This was the best IF tutorial I have seen on youtube

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.

You are a great teacher. you make Excel seem so easy. I appreciate your tutorials as they are helping me as a novice to learn Excel. Please continue to post new videos. Thanks

OMG!! Thanks goodness for you. I was literally sitting in front of my computer for 2 hours trying to figure this out. Thanks so much!!!

My goodness thank you for making this clear! This has been so hard to me to learn, but you make it understandable! :)

Thank you so much! I spent two hours trying to do this with my TA, and you helped me figure it out in 30 seconds....

Thank you for helping in my homework, this was the only clear and sensical tutorial I've found :)

Thank you sooooo much!! It was very helpful!! tool my stress-anxiety away...lol

thank you.. it is very clear to understand!

Wow another Awesome tutorial rrphillips !! You are awesome tutor. Nice example Your all video tutorial are Awesome I've learned so much from you THANK you so much for all your hard work, it has brought me immense joy, satisfaction and knowledge! God bless you rrphillips

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.

Sure, this is an excellent tutorial indeed. Very helpful tool.

Thank you SO MUCH! Super awesome video!

Thank you very much sir.god bless you.

Perfectly Presented Sir.

This is a great video for calculating the overtime pay, its good Thanks for ur good video

I am sooooo glad that I ran across your video, I finally understand how to calculate base pay, overtime and gross pay in Excel. Do you have a video that includes taxable pay, federal withholding FICA and Net Pay as well? Thank you for this video!!

This was an excellent tutorial! Thanks!

Thanks a bunch dude, you're a life saver

Awesome videos. Thanks a ton.

Many thanks sir! Great tutorials.

RalphCo... laughing so hard.... Love the video!

excellent! great idea.

Really helpful:D......waiting for more videos.

thanks great help

Thanks so much!!

Thank You!

awesome thanks bruh

great video a++

you just solved my query!

simply put :) thank you

thank you

How does this work with just trying to figure out the OT hours? Will it work with hh,mm (hours and minutes instead of just whole hours? I need something that will just break out the ot time (minutes and/or hours) from reg time if there is OT. Thanks and hope you can help.

Anyone know what software he is using to capture the screen? I want one that will show my mouse with the circle around it. Thanks

Ralph, if as in your formula you are testing for any hours above 40 to award 1.5 hourly rate, what if anything above 50 is at double time. We have =IF(C17>40,[@[Hourly Rate]]*1.5*(C17-40),0) but this then also pays anything over 50hours at 1.5 but I want to pay double time from the 51st hour onwards. There has to be an easy solution to this to ensure that the 1.5 column does not pick up any hours over 50 so the payee does not get awarded 1.5 and double time for the same hours, could you assist please? Thanks

i should have just continued watching you..other tutorials made my brain fuzzy! ugh..

My CIS131 class has a question? Is tirathmistry a student in your class looking for the grade of A? laughing.....joke.