Troubles getting corresponding column row in IF function

[Dave003]

I am trying to calculate the overtime payed. I have a column with number of hours worked, and then another with hourly salary. Im not trying to create another column listing overtime. Its going to just be one single cell with the total. Im trying to take the cells with hours over 40, subtract them by 40, leaving just the overtime hours, then multiplying them by 1.5 for time and a half, and then by the corresponding hourly wage. So it would look like this if I wrote it out.

=SUM(IF(A1>40, (A1-40)*1.5*B1, 0)+IF(A2>40, (A2-40)*1.5*B2, 0) ... and so on.

Any help would be great. Thanks.

[FDibbins]

Administrative Note:
•We would love to help you with your query, but first, before we can proceed…
•Please see Forum Rule #1 about proper thread titles and adjust accordingly...

To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title