hi
I am currently using this formula to calculate net pay. it only works on the first row cells.
When I change to cell range it don't calculate properly.
=(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10
Snap of spread sheet design
[TABLE="width: 1840"]
<tbody>[TR]
[TD] [/TD]
[TD]BH[/TD]
[TD]BH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Pay Period 1[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]30[/TD]
[TD]31[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD] [/TD]
[TD]Total Shifts[/TD]
[TD]Hol[/TD]
[TD]Sick[/TD]
[TD]Pay Period[/TD]
[TD]NAME[/TD]
[TD]Net Pay [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD]Barrie Hunt[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Barrie Hunt[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD] [/TD]
[TD]17[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD="align: right"]1[/TD]
[TD]Toqir Mulak [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Toqir Mulak [/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1[/TD]
[TD]Ediie Kings [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Eddie King [/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1[/TD]
[TD]Natasha Hooper[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Natasha Hooper[/TD]
[TD]H[/TD]
[TD]H[/TD]
[TD]H[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]H[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD] [/TD]
[TD]16[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col span="3"><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col span="2"><col><col><col><col></colgroup>[/TABLE]
Thank you in anticipation
I am currently using this formula to calculate net pay. it only works on the first row cells.
When I change to cell range it don't calculate properly.
=(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10
Snap of spread sheet design
[TABLE="width: 1840"]
<tbody>[TR]
[TD] [/TD]
[TD]BH[/TD]
[TD]BH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Dec[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD]Jan[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Pay Period 1[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]30[/TD]
[TD]31[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD] [/TD]
[TD]Total Shifts[/TD]
[TD]Hol[/TD]
[TD]Sick[/TD]
[TD]Pay Period[/TD]
[TD]NAME[/TD]
[TD]Net Pay [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD]Barrie Hunt[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Barrie Hunt[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD] [/TD]
[TD]17[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD="align: right"]1[/TD]
[TD]Toqir Mulak [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Toqir Mulak [/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1[/TD]
[TD]Ediie Kings [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Eddie King [/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD]N[/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1[/TD]
[TD]Natasha Hooper[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Natasha Hooper[/TD]
[TD]H[/TD]
[TD]H[/TD]
[TD]H[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]H[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD] [/TD]
[TD]16[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col span="3"><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="2"><col><col><col span="2"><col><col><col><col></colgroup>[/TABLE]
Thank you in anticipation