Spreadsheet: 728620d1618543156-how-to-formulate-a-cell-based-on-the-table-of-contribution-new-schedule-of-sss-contributions-effective-january-2021-1-
Sheet: Sheet1

 | RANGE OF COMPENSATION | Monthly [NAME] |  |  | AMOUNT OF CONTRIBUTIONS
 |  | Regular Social Security/ | Mandatory Provident Fund | Total | REGULAR SOCIAL SECURITY |  |  | EMPLOYEE'S COMPENSATION |  |  | MANDATORY PROVIDENT FUND |  |  | TOTAL
 |  | Employees' Compensation |  |  | ER | EE | TOTAL | ER | EE | TOTAL | ER | EE | TOTAL | ER | EE | TOTAL
 | Below 3,250 | 3000 | 0 |  | 255 | 135 |  | 10 | 0 |  | 0 | 0
 | 3,250 - 3,749.99 | 3500 | 0 |  | 297.5 |  |  | 10 | 0 |  | 0 | 0
 | 3,750 - 4,249.99 |  | 0 |  | 340 |  |  | 10 | 0 |  | 0 | 0
 | 4,250 - 4,749.99 |  | 0 |  | 382.5 |  |  | 10 | 0 |  | 0 | 0
 | 4,750 - 5,249.99 |  | 0 |  | 425 |  |  | 10 | 0 |  | 0 | 0
 | 5,250 - 5,749.99 |  | 0 |  | 467.5 |  |  | 10 | 0 |  | 0 | 0
 | 5,750 - 6,249.99 |  | 0 |  | 510 |  |  | 10 | 0 |  | 0 | 0
 | 6,250 - 6,749.99 |  | 0 |  | 552.5 |  |  | 10 | 0 |  | 0 | 0
 | 6,750 - 7,249.99 |  | 0 |  | 595 |  |  | 10 | 0 |  | 0 | 0
 | 7,250 - 7,749.99 |  | 0 |  | 637.5 |  |  | 10 | 0 |  | 0 | 0
 | 7,750 - 8,249.99 |  | 0 |  | 680 |  |  | 10 | 0 |  | 0 | 0
 | 8,250 - 8,749.99 |  | 0 |  | 722.5 |  |  | 10 | 0 |  | 0 | 0
 | 8,750 - 9,249.99 |  | 0 |  | 765 |  |  | 10 | 0 |  | 0 | 0
 | 9,250 - 9,749.99 |  | 0 |  | 807.5 |  |  | 10 | 0 |  | 0 | 0
 | 9,750 - 10,249.99 |  | 0 |  | 850 |  |  | 10 | 0 |  | 0 | 0
 | 10,250 - 10,749.99 |  | 0 |  | 892.5 |  |  | 10 | 0 |  | 0 | 0
 | 10,750 - 11,249.99 |  | 0 |  | 935 |  |  | 10 | 0 |  | 0 | 0
 | 11,250 - 11,749.99 |  | 0 |  | 977.5 |  |  | 10 | 0 |  | 0 | 0
 | 11,750 - 12,249.99 |  | 0 |  | 1020 |  |  | 10 | 0 |  | 0 | 0
 | 12,250 - 12,749.99 |  | 0 |  | 1062.5 |  |  | 10 | 0 |  | 0 | 0
 | 12,750 - 13,249.99 |  | 0 |  | 1105 |  |  | 10 | 0 |  | 0 | 0
 | 13,250 - 13,749.99 |  | 0 |  | 1147.5 |  |  | 10 | 0 |  | 0 | 0
 | 13,750 - 14,249.99 |  | 0 |  | 1190 |  |  | 10 | 0 |  | 0 | 0
 | 14,250 - 14,749.99 |  | 0 |  | 1232.5 |  |  | 10 | 0 |  | 0 | 0
 | 14,750 - 15,249.99 |  | 0 |  | 1275 |  |  | 30 | 0 |  | 0 | 0
 | 15,250 - 15,749.99 |  | 0 |  | 1317.5 |  |  | 30 | 0 |  | 0 | 0
 | 15,750 - 16,249.99 |  | 0 |  | 1360 |  |  | 30 | 0 |  | 0 | 0
 | 16,250 - 16,749.99 |  | 0 |  | 1402.5 |  |  | 30 | 0 |  | 0 | 0
 | 16,750 - 17,249.99 |  | 0 |  | 1445 |  |  | 30 | 0 |  | 0 | 0
 | 17,250 - 17,749.99 |  | 0 |  | 1487.5 |  |  | 30 | 0 |  | 0 | 0
 | 17,750 - 18,249.99 |  | 0 |  | 1530 |  |  | 30 | 0 |  | 0 | 0
 | 18,250 - 18,749.99 |  | 0 |  | 1572.5 |  |  | 30 | 0 |  | 0 | 0
 | 18,750 - 19,249.99 |  | 0 |  | 1615 |  |  | 30 | 0 |  | 0 | 0
 | 19,250 - 19,749.99 |  | 0 |  | 1657.5 |  |  | 30 | 0 |  | 0 | 0
 | 19,750 - 20,249.99 | 20000 | 0 |  | 1700 |  |  | 30 | 0 |  | 0 | 0
 | 20,250 - 20,749.99 | 20000 | 500 |  | 1700 | 900 | 2600 | 30 | 0 |  | 42.5 | 22.5
 | 20,750 - 21,249.99 | 20000 | 1000 |  | 1700 | 900 | 2600 | 30 | 0 |  | 85
 | 21,250 - 21,749.99 | 20000 | 1500 |  | 1700 | 900 | 2600 | 30 | 0 |  | 127.5
 | 21,750 - 22,249.99 | 20000 | 2000 |  | 1700 | 900 | 2600 | 30 | 0 |  | 170
 | 22,250 - 22,749.99 | 20000 | 2500 |  | 1700 | 900 | 2600 | 30 | 0 |  | 212.5
 | 22,750 - 23,249.99 | 20000 | 3000 |  | 1700 | 900 | 2600 | 30 | 0 |  | 255
 | 23,250 - 23,749.99 | 20000 | 3500 |  | 1700 | 900 | 2600 | 30 | 0 |  | 297.5
 | 23,750 - 24,249.99 | 20000 | 4000 |  | 1700 | 900 | 2600 | 30 | 0 |  | 340
 | 24,250 - 24,749.99 | 20000 | 4500 |  | 1700 | 900 | 2600 | 30 | 0 |  | 382.5
 | 24,750 - over | 20000 | 5000 |  | 1700 | 900 | 2600 | 30 | 0 |  | 425