Formula Help

clo312 · #1 12-27-2013, 04:53 PM

=IF(D5>=40,(D5-40)*D3*1.5+D3*40)

That is tthe other part of the formula sorry forgot to paste it in the original reply

BobBridges · #2 12-27-2013, 10:53 PM

Well, I thought I got that right. Let's see: If D3=8 and D5=35, then that should be 35 hrs * 8 $/hr = $280. My formula is

Code:

=(D5+MAX(D5-40,0)/2)*8, which is
=(35+MAX(35-40,0)/2)*8
=(35+MAX(-5,0)/2)*8
=(35+0/2)*8
=(35+0)*8
=35*8

...or $280. Right so far. And if D5 is 43 then it should be 40*8 + 3*8*1.5 = 320+24*1.5 = 320+36 = $356; my formula is

Code:

=(D5+MAX(D5-40,0)/2)*8
=(43+MAX(43-40,0)/2)*8
=(43+MAX(3,0)/2)*8
=(43+3/2)*8
=44.5*8

...or $356. So it looks to me like the formula I gave you is right. I thought you meant you tried it and it didn't work; but I guess you mean you tried it, and you see that it gives the correct results, you just don't understand how it works. Right? You would like an explanation of how this calculates overtime?

clo312 · #3 12-28-2013, 02:15 PM

Hello I appreciate your reply and I do need to deeply apologize for not explaining better and making you doubt yourself. I did not try it cause I was not understanding how it was working if you could explain it would be great as I have come up with a formuula that works and would like to have you analize it and tell me the difference if any that comes to the same results.

=IF(D5>=80,(D5-80)*D3*1.5+D3*80,D5*D3)

All I had to do was add a comma and the formula for straight time hours. In other words just told excel what to do if the logical test comes back FALSE.

Then I do have a more indepth question maybe you and I could make to work. All though I will admit I dont see how to make it work. Thanks clo312

Also how do i get my spreadsheet to open properly without having to click the little down arrow on the formula bar. When I open the file it shows a blank lite blue screen and then I have to click the down arrow to the far right of the formula bar to bring up the spread sheet.

Thanks again clo312

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with a formula	e_a_g_l_e_p_i	Excel	14	02-07-2013 12:37 AM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM