|
本帖最后由 ykymj 于 2012-2-19 15:28 编辑
Function wgeshui(n As Range, x As Range)
If x = 1 Then
If n - 3500 < 0 Then
wgeshui = 0
ElseIf n - 3500 <= 1500 Then
wgeshui = (n - 3500) * 0.03
ElseIf n - 3500 <= 4500 Then
wgeshui = (n - 3500) * 0.1 - 105
ElseIf n - 3500 <= 9000 Then
wgeshui = (n - 3500) * 0.2 - 555
ElseIf n - 3500 <= 35000 Then
wgeshui = (n - 3500) * 0.25 - 1005
ElseIf n - 3500 <= 55000 Then
wgeshui = (n - 3500) * 0.3 - 2755
ElseIf n - 3500 <= 80000 Then
wgeshui = (n - 3500) * 0.35 - 5505
Else: wgeshui = (n - 3500) * 0.45 - 13505
End If
ElseIf x = 2 Then
If n > 22495 Then
wgeshui = (n + 13505) / 0.45 + 3500
ElseIf n > 13745 Then
wgeshui = (n + 5505) / 0.35 + 3500
ElseIf n > 7745 Then
wgeshui = (n + 2755) / 0.3 + 3500
ElseIf n > 1245 Then
wgeshui = (n + 1005) / 0.25 + 3500
ElseIf n > 345 Then
wgeshui = (n + 555) / 0.2 + 3500
ElseIf n > 45 Then
wgeshui = (n + 105) / 0.1 + 3500
ElseIf n > 0 Then
wgeshui = n / 0.03 + 3500
Else: wgeshui = "<=3500"
End If
Else: MsgBox "B列输入有误,请重新输入。提示:A列若为工资,请在B列输入1计算个税,否则B列输入2计算工资"
End If
End Function
|
|