本帖最后由 h284124405 于 2016-4-20 15:08 编辑
- If i > 4 And i <= 20 Then
- If Cells(i, 8) = "一出二" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "150"
- ElseIf Cells(i, 4) = "φ280" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "150"
- ElseIf Cells(i, 4) = "φ350" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "150"
- ElseIf Cells(i, 4) = "φ380" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "175"
- ElseIf Cells(i, 4) = "φ379" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "175"
- ElseIf Cells(i, 4) = "φ450" Then
- Cells(i, 9) = "1"
- Cells(i, 10) = "320"
- End If
复制代码
- If i > 4 And i <= 20 Then
- tmp = Cells(i, 4): Cells(i, 9) = "1"
- Cells(i, 10) = IIf(Cells(i, 8) = "一出二" Or tmp = "φ280" Or tmp = "φ350", "150", _
- IIf(tmp = "φ380" Or tmp = "φ379", "175", IIf(tmp = "φ450", "320", "")))
- End If
复制代码
|