Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
si_ako
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bearacade
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Allllen
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
si_ako
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up/math text JN Excel Worksheet Functions 11 February 4th 06 09:27 AM
Creating a table from a formula Fiend Excel Discussion (Misc queries) 3 January 27th 06 10:51 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 11:11 PM
Trying to get formula to Do table Thrumbar Pathfinder Excel Worksheet Functions 0 December 14th 04 09:36 PM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"