|
本帖最后由 sliang28 于 2012-2-16 21:58 编辑
C组 sliang28 提交答案
Function WGeShui(n As Double, x As Integer) As Variant
Dim NaShui As Double
Dim ns(10) As Double
Dim gz(10) As Double
If x = 1 Then
NaShui = n - 3500
ns(1) = 0
ns(2) = NaShui * 0.03 - 0
ns(3) = NaShui * 0.1 - 105
ns(4) = NaShui * 0.2 - 555
ns(5) = NaShui * 0.25 - 1005
ns(6) = NaShui * 0.3 - 2755
ns(7) = NaShui * 0.35 - 5505
ns(8) = NaShui * 0.45 - 13505
WGeShui = WorksheetFunction.Max(ns(1), ns(2), ns(3), ns(4), ns(5), ns(6), ns(7), ns(8))
ElseIf x = 2 Then
gz(1) = n / 0.03 + 3500
gz(2) = (n + 105) / 0.1 + 3500
gz(3) = (n + 555) / 0.2 + 3500
gz(4) = (n + 1005) / 0.25 + 3500
gz(5) = (n + 2755) / 0.3 + 3500
gz(6) = (n + 5505) / 0.35 + 3500
gz(7) = (n + 13505) / 0.45 + 3500
If n = 0 Then
WGeShui = "工资都不够纳税,丢人"
Else
WGeShui = WorksheetFunction.Min(gz(1), gz(2), gz(3), gz(4), gz(5), gz(6), gz(7))
End If
End If
|
评分
-
查看全部评分
|