A09:byhdch
第一题答: Sub 单元格填充() With Sheets("sheet3") .Range("A1") = 100 .Range("A3") = 900 .Range("A5") = 100 .Range("A8") = 4500 End With End Sub
第二题答: Function GeShui(gz As Range) If gz - 3500 <= 0 Then GeShui = 0 ElseIf gz - 3500 <= 1500 Then GeShui = (gz - 3500) * 0.03 ElseIf gz - 3500 <= 4500 Then GeShui = (gz - 3500) * 0.1 - 105 ElseIf gz - 3500 <= 9000 Then GeShui = (gz - 3500) * 0.2 - 555 ElseIf gz - 3500 <= 35000 Then GeShui = (gz - 3500) * 0.25 - 1005 ElseIf gz - 3500 <= 55000 Then GeShui = (gz - 3500) * 0.3 - 2750 ElseIf gz - 3500 <= 80000 Then GeShui = (gz - 3500) * 0.35 - 5505 ElseIf gz - 3500 > 80000 Then GeShui = (gz - 3500) * 0.45 - 13505 End If End Function
|