RE: $$Excel-Macros$$ National insurance calculator
That code was only of Categorize the Entered Amount in 3rd Column Thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of srinivas m Sent: Wednesday, August 03, 2011 4:46 PM To: rajanverma1...@gmail.com Subject: Re: $$Excel-Macros$$ National insurance calculator Hi Rajan, Thanks for providing VBA code. But it is not working properly. In the attached sheet I will give Pers No , Niablepay and NI category manually. the remaining things should caluclated by the excel automatically. Have given one example in the attached sheet. Please review the sheet and let me know if you have any queries. Thanks and Regards, Srinivas. On Mon, Aug 1, 2011 at 7:07 PM, srinivas m srinivas.m4...@gmail.com wrote: -- Forwarded message -- From: Rajan_Verma rajanverma1...@gmail.com Date: Sat, Jul 30, 2011 at 6:09 PM Subject: RE: $$Excel-Macros$$ National insurance calculator To: excel-macros@googlegroups.com See the attached sheet.. Revert if any Queries : Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Dim val1 As Variant If Target.Column = 2 Then Application.EnableEvents = False val1 = Target.Value If val1 = Then Target.Value = GoTo Err: End If If val1 443 Then Target.Value = 0-442 GoTo Err: ElseIf val1 442 And val1 590 Then Target.Value = 442-589 GoTo Err: ElseIf val1 588 And val1 603 Then Target.Value = 589-602 GoTo Err: ElseIf val1 601 And val1 3338 Then Target.Value = 602-3337 GoTo Err: ElseIf val1 3336 And val1 3541 Then Target.Value = 3337-3540 GoTo Err: ElseIf val1 3539 Then Target.Value = 3540 GoTo Err: End If Application.EnableEvents = True End If Err: Application.EnableEvents = True End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of srinivas m Sent: Saturday, July 30, 2011 4:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ National insurance calculator 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros
Re: $$Excel-Macros$$ National insurance calculator
Hi Rajan, Thanks for providing VBA code. But it is not working properly. In the attached sheet I will give Pers No , Niablepay and NI category manually. the remaining things should caluclated by the excel automatically. Have given one example in the attached sheet. Please review the sheet and let me know if you have any queries. Thanks and Regards, Srinivas. On Mon, Aug 1, 2011 at 7:07 PM, srinivas m srinivas.m4...@gmail.com wrote: -- Forwarded message -- From: Rajan_Verma rajanverma1...@gmail.com Date: Sat, Jul 30, 2011 at 6:09 PM Subject: RE: $$Excel-Macros$$ National insurance calculator To: excel-macros@googlegroups.com *See the attached sheet.. Revert if any Queries :* * * *Private Sub Worksheet_Change(ByVal Target As Range)* *On Error Resume Next* *Dim val1 As Variant* * * *If Target.Column = 2 Then* *Application.EnableEvents = False* *val1 = Target.Value* ** *If val1 = Then* *Target.Value = * *GoTo Err:* *End If* ** *If val1 443 Then* *Target.Value = 0-442* *GoTo Err:* *ElseIf val1 442 And val1 590 Then* *Target.Value = 442-589* *GoTo Err:* *ElseIf val1 588 And val1 603 Then* *Target.Value = 589-602* *GoTo Err:* *ElseIf val1 601 And val1 3338 Then* *Target.Value = 602-3337* *GoTo Err:* *ElseIf val1 3336 And val1 3541 Then* *Target.Value = 3337-3540* *GoTo Err:* *ElseIf val1 3539 Then* *Target.Value = 3540* *GoTo Err:* *End If* *Application.EnableEvents = True* *End If* *Err:* *Application.EnableEvents = True* * * *End Sub* * * * * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *srinivas m *Sent:* Saturday, July 30, 2011 4:34 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ National insurance calculator ** ** 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 -- -- 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
RE: $$Excel-Macros$$ National insurance calculator
See the attached sheet.. Revert if any Queries : Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Dim val1 As Variant If Target.Column = 2 Then Application.EnableEvents = False val1 = Target.Value If val1 = Then Target.Value = GoTo Err: End If If val1 443 Then Target.Value = 0-442 GoTo Err: ElseIf val1 442 And val1 590 Then Target.Value = 442-589 GoTo Err: ElseIf val1 588 And val1 603 Then Target.Value = 589-602 GoTo Err: ElseIf val1 601 And val1 3338 Then Target.Value = 602-3337 GoTo Err: ElseIf val1 3336 And val1 3541 Then Target.Value = 3337-3540 GoTo Err: ElseIf val1 3539 Then Target.Value = 3540 GoTo Err: End If Application.EnableEvents = True End If Err: Application.EnableEvents = True End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of srinivas m Sent: Saturday, July 30, 2011 4:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ National insurance calculator 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 -- -- 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 Copy of NI_Calculator_2011-2012.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
