|
谢谢高手帮忙解决!刚才疏漏了一个条件
本帖最后由 qh8600 于 2014-6-19 11:46 编辑
- Private Sub CommandButton1_Click()
- Dim ar, i
- ar = Range("a1:d" & Range("a1048576").End(3).Row)
- For i = 2 To UBound(ar)
- If ar(i, 2) = 6 Then
- If ar(i, 3) < 16 Then
- ar(i, 4) = "短料"
- ElseIf ar(i, 3) < 21 Then
- ar(i, 4) = "常规料"
- Else
- ar(i, 4) = "长料"
- End If
- ElseIf ar(i, 2) = 8 Then
- If ar(i, 3) < 20 Then
- ar(i, 4) = "短料"
- ElseIf ar(i, 3) < 41 Then
- ar(i, 4) = "常规料"
- Else
- ar(i, 4) = "长料"
- End If
- End If
- Next
- Range("a1").Resize(UBound(ar), UBound(ar, 2)) = ar
- End Sub
复制代码
IF语句双条件求助.rar
(19.3 KB, 下载次数: 22)
|
|