vba - VLOOKUP 的 FOR 循环在两个单元格中返回值并打印第三个单元格

Question

比较 2 个单元格的值并在第三个单元格中打印。两个单元格值都来自 vlookup所以它有#N/A和 #VALUE ，即使对于这两个值，它也应该在第三个单元格中返回未提交

For i = 2 To NRScount75
    If Range("O" & i) >= 0 And Range("O" & i) <= 10 Then
        Range("P" & i) = "Within SLA" 'values between 0 to 10
    ElseIf Range("O" & i) >= 11 Then
        Range("P" & i) = "Exceed SLA"  'values greater than 10
    Else      
        Range("P" & i) = "Not submitted"  'for negative values    
    End If
Next i

Answer 1

在测试值之前测试错误:

For i = 2 To NRScount75
    Range("P" & i) = "Not submitted" 'Assign Default Value
    If Not IsError(Range("O" & i)) Then
        If Range("O" & i) >= 0 Then
            If Range("O" & i) <= 10 Then
                Range("P" & i) = "Within SLA" 'values between 0 to 10
            Else
                Range("P" & i) = "Exceed SLA"  'values greater than 10
            End If
        End If
    End If
 Next i