Sub demo()
a = Range("d3:g" & [d3].End(4).Row)
For i = 1 To UBound(a)
Select Case a(i, 3)
Case Is = a(i, 1): a(i, 4) = "达标"
Case Is < 0: a(i, 4) = "少用"
Case Else: a(i, 4) = "多用"
End Select
Next
[d3].Resize(UBound(a), 4) = a
End Sub
Sub demo()
a = Range("d3:g" & [d3].End(4).Row)
For i = 1 To UBound(a)
Select Case a(i, 3)
Case Is = a(i, 1): a(i, 4) = "达标"
Case Is < 0: a(i, 4) = "少用"
Case Else: a(i, 4) = "多用"
End Select
Next
[d3].Resize(UBound(a), 4) = a
End Sub