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 > > -- ---------------------------------------------------------------------------------- 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
NI_Calculator_2011-2012.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
