Sub 多重判断()
If Range("a1") < 0 Then
Range("b1") = "小于零"
ElseIf Range("a1") = 0 Then
Range("b1") = "等于零"
ElseIf Range("a1") > 0 Then
Range("b1") = "大于零"
End If
End Sub
上面这个语句是判断A1,结果在B1显示;如果我想批量判断A列的数据,结果在B列对应的位置显示,是要改哪里?{:011:}
Sub 多重判断()
dim i as long
for i = 1 to [A65536].end(xlup).row
If Range("a" & i) < 0 Then
Range("b" & i) = "小于零"
ElseIf Range("a" & i) = 0 Then
Range("b" & i) = "等于零"
ElseIf Range("a" & i) > 0 Then
Range("b" & i) = "大于零"
End If
next i
End Sub
Sub 多重判断()
Dim i%
Dim j%
j = Range("A65536").End(xlUp).Row
For i = 1 To j
If Range("A" & i) < 0 Then
Range("B" & i) = "小于零"
ElseIf Range("A" & i) = 0 Then
Range("B" & i) = "等于零"
ElseIf Range("A" & i) > 0 Then
Range("B" & i) = "大于零"
End If
Next i
End Sub