Help with formula please

T

TOQIR

New Member
Joined
Dec 1, 2017
Messages
2
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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
I have tried your formula, if AF12=0, AG12=0, Rates!$F$5=0, the Net Pay is 242.28.
Same results for the next rows.
Is this correct?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Count days at work that were fridays
Replies
3
Views
113
Dave Patton
D
Vintage79
  • Solved
Count consecutive days and gaps between days
Replies
2
Views
216
Vintage79
Vintage79
W
  • Question Question
Personnel Roster using Macro's
Replies
0
Views
326
womeclr
W
K
  • Solved
Populate Dates and Data With Criteria
2
Replies
11
Views
164
Alex Blakenburg
A
R
  • Question Question
Index Match Formula to retrieved next cell value
Replies
4
Views
378
Fluff
Fluff

Forum statistics

Threads
1,223,885
Messages
6,175,179
Members
452,615
Latest member
bogeys2birdies

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top