Spreadsheet: 842130d1694186048-alternative-to-indirect-for-referencing-named-ranges-sample-excel-1-tms
Sheet: SOCSO

No | Monthly Salary |  | Employers | Employee | Total SOCSO Contribution | Employers | Employee | Total EIS
1 | RM0 – RM30.00 | 30 | 40 cents | 10 cents | 50 cents | 0.05 | 0.05 | 0.1
2 | RM30.01 – RM50.00 | 50 | 70 cents | 20 cents | 90 cents | 0.1 | 0.1 | 0.2
3 | RM50.01 – RM70.00 | 70 | 1.1 | 30 cents | 1.4 | 0.15 | 0.15 | 0.3
4 | RM70.01 – RM100.00 | 100 | 1.5 | 40 cents | 1.9 | 0.2 | 0.2 | 0.4
5 | RM100.01 – RM140.00 | 140 | 2.1 | 60 cents | 2.7 | 0.25 | 0.25 | 0.5
6 | RM140.01 – RM200.00 | 200 | 2.95 | 85 cents | 3.8 | 0.35 | 0.35 | 0.7
7 | RM200.01 – RM300.00 | 300 | 4.35 | 1.25 | 5.6 | 0.5 | 0.5 | 1
8 | RM300.01 – RM400.00 | 400 | 6.15 | 1.75 | 7.9 | 0.7 | 0.7 | 1.4
9 | RM400.01 – RM500.00 | 500 | 7.85 | 2.25 | 10.1 | 0.9 | 0.9 | 1.8
10 | RM500.01 – RM600.00 | 600 | 9.65 | 2.75 | 12.4 | 1.1 | 1.1 | 2.2
11 | RM600.01 – RM700.00 | 700 | 11.35 | 3.25 | 14.6 | 1.3 | 1.3 | 2.6
12 | RM700.01 – RM800.00 | 800 | 13.15 | 3.75 | 16.9 | 1.5 | 1.5 | 3
13 | RM800.01 – RM900.00 | 900 | 14.85 | 4.25 | 19.1 | 1.7 | 1.7 | 3.4
14 | RM900.01 – RM1000.00 | 1000 | 16.65 | 4.75 | 21.4 | 1.9 | 1.9 | 3.8
15 | RM1000.01 – RM1100.00 | 1100 | 18.35 | 5.25 | 23.6 | 2.1 | 2.1 | 4.2
16 | RM1100.01 – RM1200.00 | 1200 | 20.15 | 5.75 | 25.9 | 2.3 | 2.3 | 4.6
17 | RM1200.01 – RM1300.01 | 1300 | 21.85 | 6.25 | 28.1 | 2.5 | 2.5 | 5
18 | RM1300.01 – RM1400.00 | 1400 | 23.65 | 6.75 | 30.4 | 2.7 | 2.7 | 5.4
19 | RM1400.01 – RM1500.00 | 1500 | 25.35 | 7.25 | 32.6 | 2.9 | 2.9 | 5.8
20 | [NAME] | 1600 | 27.15 | 7.75 | 34.9 | 3.1 | 3.1 | 6.2
21 | RM1600.01 – RM1700.00 | 1700 | 28.85 | 8.25 | 37.1 | 3.3 | 3.3 | 6.6
22 | RM1700.01 – RM1800.00 | 1800 | 30.65 | 8.75 | 39.4 | 3.5 | 3.5 | 7
23 | RM1800.01 – RM1900.00 | 1900 | 32.35 | 9.25 | 41.6 | 3.7 | 3.7 | 7.4
24 | RM1900.01 – RM2000.00 | 2000 | 34.15 | 9.75 | 43.9 | 3.9 | 3.9 | 7.8
25 | RM2000.01 – RM2100.00 | 2100 | 35.85 | 10.25 | 46.1 | 4.1 | 4.1 | 8.2
26 | RM2100.01 – RM2200.00 | 2200 | 37.65 | 10.75 | 48.4 | 4.3 | 4.3 | 8.6
27 | RM2200.01 – RM2300.00 | 2300 | 39.35 | 11.25 | 50.6 | 4.5 | 4.5 | 9
28 | RM2300.01 – RM2400.00 | 2400 | 41.15 | 11.75 | 52.9 | 4.7 | 4.7 | 9.4
29 | RM2400.01 – RM2500.00 | 2500 | 42.85 | 12.25 | 55.1 | 4.9 | 4.9 | 9.8
30 | RM2500.01 – RM2600.00 | 2600 | 44.65 | 12.75 | 57.4 | 5.1 | 5.1 | 10.2
31 | RM2600.01 – RM2700.00 | 2700 | 46.35 | 13.25 | 59.6 | 5.3 | 5.3 | 10.6
32 | RM2700.01 – RM2800.00 | 2800 | 48.15 | 13.75 | 61.9 | 5.5 | 5.5 | 11
33 | RM2800.01 – RM2900.00 | 2900 | 49.85 | 14.25 | 64.1 | 5.7 | 5.7 | 11.4
34 | RM2900.01 – RM3000.00 | 3000 | 51.65 | 14.75 | 66.4 | 5.9 | 5.9 | 11.8
35 | RM3000.01 – RM3100.00 | 3100 | 53.35 | 15.25 | 68.6 | 6.1 | 6.1 | 12.2
36 | RM3100.01 – RM3200.00 | 3200 | 55.15 | 15.75 | 70.9 | 6.3 | 6.3 | 12.6
37 | RM3200.01 – RM3300.00 | 3300 | 56.85 | 16.25 | 73.1 | 6.5 | 6.5 | 13
38 | RM3300.01 – RM3400.00 | 3400 | 58.65 | 16.75 | 75.4 | 6.7 | 6.7 | 13.4
39 | RM3400.01 – RM3500.00 | 3500 | 60.35 | 17.25 | 77.6 | 6.9 | 6.9 | 13.8
40 | RM3500.01 – RM3600.00 | 3600 | 62.15 | 17.75 | 79.9 | 7.1 | 7.1 | 14.2
41 | RM3600.01 – RM3700.00 | 3700 | 63.85 | 18.25 | 82.1 | 7.3 | 7.3 | 14.6
42 | RM3700.01 – RM3800.00 | 3800 | 65.65 | 18.75 | 84.4 | 7.5 | 7.5 | 15
43 | RM3800.01 – RM3900.00 | 3900 | 67.35 | 19.25 | 86.6 | 7.7 | 7.7 | 15.4
44 | RM3900.01 – RM4000.00 | 4000 | 69.15 | 19.75 | 88.9 | 7.9 | 7.9 | 15.8
45 | RM4000.01 – RM4100.00 | 4100 | 70.85 | 20.25 | 91.1 | 7.9 | 7.9 | 15.8
46 | RM4100.01 – RM4200.00 | 4200 | 72.65 | 20.75 | 93.4 | 7.9 | 7.9 | 15.8
47 | RM4200.01 – RM4300.00 | 4300 | 74.35 | 21.25 | 95.6 | 7.9 | 7.9 | 15.8
48 | RM4300.01 – RM4400.00 | 4400 | 76.15 | 21.75 | 97.9 | 7.9 | 7.9 | 15.8
49 | RM4400.01 – RM4500.00 | 4500 | 77.85 | 22.25 | 100.1 | 7.9 | 7.9 | 15.8
50 | RM4500.01 – RM4600.00 | 4600 | 79.65 | 22.75 | 102.4 | 7.9 | 7.9 | 15.8
51 | RM4600.01 – RM4700.00 | 4700 | 81.35 | 23.25 | 104.6 | 7.9 | 7.9 | 15.8
52 | RM4700.01 – RM4800.00 | 4800 | 83.15 | 23.75 | 106.9 | 7.9 | 7.9 | 15.8
53 | RM4800.01 – RM4900.00 | 4900 | 84.85 | 24.25 | 109.1 | 7.9 | 7.9 | 15.8
54 | RM4900.01 – RM5000.00 | 5000 | 86.65 | 24.75 | 111.4 | 7.9 | 7.9 | 15.8
55 | RM5000.01 or above | 5100 | 86.65 | 24.75 | 111.4 | 7.9 | 7.9 | 15.8