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
