|
发表于 2015-1-13 19:31
|
显示全部楼层
本楼为最佳答案
Sub Click()
Dim A, i
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
If A(i, 2) = "A" Then
Select Case A(i, 3)
Case Is < 8
A(i, 4) = 8000
Case 8, 9
A(i, 4) = 10000
Case Is >= 10
A(i, 4) = 12000
End Select
Else
Select Case A(i, 3)
Case Is < 13
A(i, 4) = 15000
Case 13, 14
A(i, 4) = 20000
Case Is >= 15
A(i, 4) = 25000
End Select
End If
Next i
[a1].Resize(i - 1, 4) = A
End Sub
1.rar
(9.42 KB, 下载次数: 2)
|
|