Hi All, This is srinivas from Hyderabad working in a MNC company .
I support UK clients here. My job is processing payroll for UK clients on Monthly Basis. Normally in UK we need to deduct National Insurance contribution from employee salary. There are different NI catogories and for each category I have attached the Percentages. Please find below the slabs for calculating national insuarence. 0-442 442-589 589-601 602-3337 3337-3540 >3540 The slabs are same for all the NI categories But the Percentages and rebates varies from category to category. 1)In the attached sheet I will enter Pers No's of employees, Niablepay and NI category. Once I enter the Niable pay the Macro should divide the niable pay as per the above slabs. 2) in the second step it should calculate National insuarance Contribution for both Employee and Employer as applicable rates. I am attaching the complete information on the sheet. kindly request you help me on this ?? Please let us me know if you need any additional information. Many thanks in advance. Thanks and Regards, Srinivas.M -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Copy of NI_Calculator_2011-2012.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
