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