Help with formula please

[TOQIR]

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

BH

BH

BH

Dec

Dec

Dec

Dec

Dec

Dec

Dec

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Jan

Pay Period 1

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

Total Shifts

Hol

Sick

Pay Period

NAME

Net Pay

Mon

Tue

Wed

Thu

Fri

Sat

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Sun

1

Barrie Hunt

Barrie Hunt

R

D

D

D

N

N

N

R

R

R

D

D

D

N

N

N

R

R

R

D

D

S

N

N

N

R

R

R

17

0

1

1

Toqir Mulak

Toqir Mulak

D

N

N

N

R

R

R

D

D

D

N

N

N

R

R

R

D

D

D

N

N

N

R

R

R

D

D

D

19

0

0

1

Ediie Kings

Eddie King

N

R

R

R

D

D

D

N

N

N

R

R

R

D

D

D

N

N

N

R

R

R

D

D

D

N

N

N

19

0

0

1

Natasha Hooper

Natasha Hooper

H

H

H

D

D

R

R

H

D

D

D

D

R

R

D

D

D

D

D

R

R

D

D

D

D

D

R

R

16

4

0

<tbody>
</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>

Thank you in anticipation

 

[lhartono]

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?