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