不知是不是这样计算
Sub jsjx()
For i = 8 To [B1048576].End(xlUp).Row
Select Case 100 - Cells(i, 4)
Case Is < 6
Cells(i, 5) = Cells(i, 3)
Case Is < 16
Cells(i, 5) = Round(Cells(i, 3) - Cells(i, 3) * (100 - Cells(i, 4) - 5) * 0.01, 2)
Case Is < 26
Cells(i, 5) = Round(Cells(i, 3) - Cells(i, 3) * 0.1 - (Cells(i, 3) - Cells(i, 3) * 0.1) * (100 - Cells(i, 4) - 15) * 0.02, 2)
Case Is < 36
Cells(i, 5) = Round(Cells(i, 3) - Cells(i, 3) * 0.3 - (Cells(i, 3) - Cells(i, 3) * 0.3) * (100 - Cells(i, 4) - 25) * 0.03, 2)
Case Is > 35
Cells(i, 5) = ""
End Select
Next i
End Sub
|