3578| 1
|
求修改返利计算的代码 |
3学分
最佳答案Sub 返利计算()
Range("CT4:CT999") = ""
For I = 4 To Range("CR1000").End(3).Row
R = Application.CountA(Range(Cells(I, "DC"), Cells(I, "DJ")))
For J = R To 2 Step -2
If Cells(I, "CR") >= Range("DB" & I).Offset(, J - 1) Then
Cells(I, "CT") = Cells(I, "CS") * Range("DB" & I).Offset(, J)
Exit For
End If
Nex ...
| ||
发表于 2020-7-31 23:00
|
显示全部楼层
评分 | ||