Spreadsheet: 686753d1594802461-conditional-addition-payroll-test
Sheet: SSS

Range of Compensation |  |  | Monthly [NAME] | SS Contribution |  |  | EC Contribution
 |  |  |  | ER | EE | Total | ER
BELOW – 2,250 |  |  | 2000 | 160 | 80 | 240 | 10
2,250 – 2,749.99 |  |  | 2500 | 200 | 100 | 300 | 10
2,750 – 3,249.99 |  |  | 3000 | 240 | 120 | 360 | 10
3,250 – 3,749.99 |  |  | 3500 | 280 | 140 | 420 | 10
3,750 – 4,249.99 |  |  | 4000 | 320 | 160 | 480 | 10
4250 – 4,749.99 |  |  | 4500 | 360 | 180 | 540 | 10
4,750 – 5249.99 |  |  | 5000 | 400 | 200 | 600 | 10
5,250 – 5,749.99 |  |  | 5500 | 440 | 220 | 660 | 10
5,750 – 6,249.99 |  |  | 6000 | 480 | 240 | 20 | 10
6,250 – 6,749.99 |  |  | 6500 | 520 | 260 | 780 | 10
6,750 – 7,249.99 |  |  | 7000 | 560 | 280 | 840 | 10
7,250 – 7,749.99 |  |  | 7500 | 600 | 300 | 900 | 10
7,750 – 8,249.99 | 7750 | 8249.99 | 8000 | 640 | 320 | 960 | 10
8,250 – 8,749.99 | 8250 | 8749.99 | 8500 | 680 | 340 | 1020 | 10
8.750 – 9,249.99 | 8750 | 9249.99 | 9000 | 720 | 360 | 1080 | 10
9,250 – 9,749.99 | 9250 | 9749.99 | 9500 | 760 | 380 | 1140 | 10
9,750 – 10,249.99 | 9750 | 10249.99 | 10000 | 800 | 400 | 1200 | 10
10,250 – 10,749.99 | 10250 | 10749.99 | 10500 | 840 | 420 | 1260 | 10
10,760 – 11,249.99 | 11750 | 11249.99 | 11000 | 880 | 440 | 1320 | 10
11,250 – 11,749.99 | 11250 | 11749.99 | 11500 | 920 | 460 | 1380 | 10
11,750 – 12,249.99 | 11750 | 12249.99 | 12000 | 960 | 480 | 1440 | 10
12,250 – 12,749.99 | 12250 | 12749.99 | 12500 | 1000 | 500 | 1500 | 10
12,760 – 13,249.99 | 12750 | 13249.99 | 13000 | 1040 | 520 | 1560 | 10
13,250 – 13,749.99 | 13250 | 13749.99 | 13500 | 1080 | 540 | 1620 | 10
13,750 – 14,249.99 | 13750 | 14249.99 | 14000 | 1120 | 560 | 1680 | 10
14,250 – 14,749.99 | 14250 | 14749.99 | 14500 | 1160 | 580 | 1740 | 10
14,750 – 15,249.99 | 14750 | 15249.99 | 15000 | 1200 | 600 | 1800 | 30
15,250 – 15,749.99 | 15250 | 15749.99 | 15500 | 1240 | 620 | 1860 | 30
15,750 – 16,249.99 | 15750 | 16249.99 | 16000 | 1280 | 640 | 1920 | 30
16,250 – 16,749.99 | 16250 | 16749.99 | 16500 | 1320 | 660 | 1980 | 30
16,750 – 17,249.99 | 16750 | 17249.99 | 17000 | 1360 | 680 | 2040 | 30
17,250 – 17,749.99 | 17250 | 17749.99 | 17500 | 1400 | 700 | 2100 | 30
17,750 – 18,249.99 | 17750 | 18249.99 | 18000 | 1440 | 720 | 2160 | 30
18,250 – 18,749.99 | 18250 | 18749.99 | 18500 | 1480 | 740 | 2220 | 30
18,750 – 19,249.99 | 18750 | 19249.99 | 19000 | 1520 | 760 | 2280 | 30
19,250 – 19,749.99 | 19250 | 19749.99 | 19500 | 1560 | 780 | 2340 | 30
19,750 and above | 19750 |  | 20000 | 1600 | 800 | 2400 | 30
 |  | Monthly [NAME] | SS Contribution
 |  |  | ER | EE | Total
 |  | 2000 | 160 | 80 | 240
 |  | 2500 | 200 | 100 | 300
 |  | 3000 | 240 | 120 | 360
 |  | 3500 | 280 | 140 | 420
 |  | 4000 | 320 | 160 | 480
 |  | 4500 | 360 | 180 | 540
 |  | 5000 | 400 | 200 | 600
 |  | 5500 | 440 | 220 | 660
 |  | 6000 | 480 | 240 | 20
 |  | 6500 | 520 | 260 | 780
 |  | 7000 | 560 | 280 | 840
 |  | 7500 | 600 | 300 | 900
7750 | 8249.99 | 8000 | 640 | 320 | 960
8250 | 8749.99 | 8500 | 680 | 340 | 1020
8750 | 9249.99 | 9000 | 720 | 360 | 1080
9250 | 9749.99 | 9500 | 760 | 380 | 1140
9750 | 10249.99 | 10000 | 800 | 400 | 1200
10250 | 10749.99 | 10500 | 840 | 420 | 1260
11750 | 11249.99 | 11000 | 880 | 440 | 1320
11250 | 11749.99 | 11500 | 920 | 460 | 1380
11750 | 12249.99 | 12000 | 960 | 480 | 1440
12250 | 12749.99 | 12500 | 1000 | 500 | 1500
12750 | 13249.99 | 13000 | 1040 | 520 | 1560
13250 | 13749.99 | 13500 | 1080 | 540 | 1620
13750 | 14249.99 | 14000 | 1120 | 560 | 1680
14250 | 14749.99 | 14500 | 1160 | 580 | 1740
14750 | 15249.99 | 15000 | 1200 | 600 | 1800
15250 | 15749.99 | 15500 | 1240 | 620 | 1860
15750 | 16249.99 | 16000 | 1280 | 640 | 1920
16250 | 16749.99 | 16500 | 1320 | 660 | 1980
16750 | 17249.99 | 17000 | 1360 | 680 | 2040
17250 | 17749.99 | 17500 | 1400 | 700 | 2100
17750 | 18249.99 | 18000 | 1440 | 720 | 2160
18250 | 18749.99 | 18500 | 1480 | 740 | 2220
18750 | 19249.99 | 19000 | 1520 | 760 | 2280
19250 | 19749.99 | 19500 | 1560 | 780 | 2340
19750 | 9999999 | 20000 | 1600 | 800 | 2400