government table formula

[si_ako]

hi there! we dont have a payroll system in our company and our total
employees is around 1,000. im having a hard time in computing their
contribution since i still have to check their income bracket to come
up with their contribution.

here's the table:

Salary Employee Contribution
4,000.00 50.00
5,000.00 62.50
6,000.00 75.00
7,000.00 87.50

for example, what's the formula to come up with the employee
contribution based on the table above?

like if an employee's salary is less than 4,000 pesos, then
contribution is zero, but if 4,000 - 4999, his contribution is 50 etc.


many thanks!
thanks!

 

[Bearacade]

=if(a1<4001, 0, (if(a1<5001, 50, (if(a1<6001, 62.5, (if(a1<7001, 75,
87.5)))))))

 

[Allllen]

Column A Column B
Row 1 Salary Employee Contribution
Row 2 0,000.00 0.00
Row 3 1,000.00 0.00
Row 4 2,000.00 0.00
Row 5 3,000.00 0.00
Row 6 4,000.00 50.00
Row 7 5,000.00 62.50
Row 8 6,000.00 75.00
etc etc

[YOURVALUE]

=VLOOKUP(1000*ROUNDDOWN([YOURVALUE]/1000,0),A:B,2,0)

 

[Toppers]

=IF(A1<4000,0,ROUNDDOWN(A1,-3)/80)

 

[si_ako]

I got it, thanks a lot!