|
C13:xm258
第1题:
Sub 单元格填充()
With Sheets("sheet3")
.Range("A1") = 100
.Range("A3") = 900
.Range("A5") = 100
.Range("A8") = 4500
End With
End Sub
第2题:
Function GeShui(gz As Range)
Select Case gz
Case Is <= 3500
GeShui = 0
Case Is <= 3500 + 1500
GeShui = Round((gz - 3500) * 0.03, 2)
Case Is <= 3500 + 4500
GeShui = Round((gz - 3500) * 0.05 - 105, 2)
Case Is <= 3500 + 9000
GeShui = Round((gz - 3500) * 0.2 - 555, 2)
Case Is <= 3500 + 35000
GeShui = Round((gz - 3500) * 0.25 - 1005, 2)
Case Is <= 3500 + 55000
GeShui = Round((gz - 3500) * 0.3 - 2755, 2)
Case Is <= 3500 + 80000
GeShui = Round((gz - 3500) * 0.35 - 5505, 2)
Case Is > 3500 + 80000
GeShui = Round((gz - 3500) * 0.45 - 13505, 2)
End Select
End Function
|
|