government table formula
 

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!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=551908

government table formula
 

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551908

government table formula
 

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)
--
Allllen


"si_ako" wrote:


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!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=551908

government table formula
 

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


"Bearacade" wrote:


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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551908

government table formula
 

I got it, thanks a lot!:)


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=551908