Salary Sheet I Na hou W Depar D m r ag tment e wor e code 32 co 1 1 n ked o 30 de 1 2 . 32 2 2 36 1 1 36 2 2 32 2 1
Gross Pay $187.20 $199.50 $29.20 $210.60 $29.20 $206.40
Deduction
Net Pay
9.36 9.98 0.58 18.95 0.58 18.58
### ### ### ### ### ###
IF(AND(D4=1,E4=1),5.85*C4,IF(AND(D4=1,E4=2),6.45*C4,IF(AND(D4=2,E4=1),6.65*C4,IF(AND(D4=2,E4=2),7.3*(4),))))
Department code
Wage code
1
1
2
1
2
2
1
1
2
2
1
2
4=2,E4=2),7.3*(4),))))