Logical Operators

 

Logical Operator And | Logical Operator Or | Logical Operator Not

The three most used logical operators in Excel VBA are: And, Or and Not. As always, we will use easy examples to make things more clear.

Logical Operator And

Place a command button on your worksheet and add the following code lines:

Dim score1 As Integer, score2 As Integer, result As String

score1 = Range(“A1”).Value

score2 = Range(“B1”).Value

If score1 >= 60 And score2 > 1 Then

result = “pass”

Else

result = “fail”

End If

Range(“C1”).Value = result

Explanation: if score1 is greater than or equal to 60 and score2 is greater than 1, Excel VBA returns pass, else Excel VBA returns fail.

Result when you click the command button on the sheet:

Excel VBA Logical Operator And

Conclusion: Excel VBA returns fail because score2 is not greater than 1.

Logical Operator Or

Place a command button on your worksheet and add the following code lines:

Dim score1 As Integer, score2 As Integer, result As String

score1 = Range(“A1”).Value

score2 = Range(“B1”).Value

If score1 >= 60 Or score2 > 1 Then

result = “pass”

Else

result = “fail”

End If

Range(“C1”).Value = result

Explanation: if score1 is greater than or equal to 60 or score2 is greater than 1, Excel VBA returns pass, else Excel VBA returns fail.

Result when you click the command button on the sheet:

Excel VBA Logical Operator Or

Conclusion: Excel VBA returns pass because score1 is greater than or equal to 60.

Logical Operator Not

Place a command button on your worksheet and add the following code lines:

Dim score1 As Integer, score2 As Integer, result As String

score1 = Range(“A1”).Value

score2 = Range(“B1”).Value

If score1 >= 60 And Not score2 = 1 Then

result = “pass”

Else

result = “fail”

End If

Range(“C1”).Value = result

Explanation: if score1 is greater than or equal to 60 and score2 is not equal to 1, Excel VBA returns pass, else Excel VBA returns fail.

Result when you click the command button on the sheet:

Excel VBA Logical Operator Not

Conclusion: Excel VBA returns fail because score2 is equal to 1.