| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up/math text | Excel Worksheet Functions | |||
| Creating a table from a formula | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
| Trying to get formula to Do table | Excel Worksheet Functions | |||
Linear Mode
