Logical Operators

Logical operators connect one or two variables to form a logical expression.

【Excel VBA】

Logical operators in Excel VBA are shown in Table 3-5, where a and b are Boolean variables.

Table 3-5 Logical Operators in Excel VBA

Continued Table 3-5

Below, take three numbers, compare the first two, compare the last two, and use logical AND to check if both comparisons hold. The sample file path is Samples\ch03\Excel VBA\Logical Operators.xlsm.

Sub Test4()
    Dim intA As Integer
    Dim intB As Integer
    Dim intC As Integer
    intA = 10
    intB = 20
    intC = 30
    Debug.Print intA < intB And intB < intC  ' Check if both comparisons are true
End Sub

Running the procedure outputs True in the Immediate Window.

【Python】

Logical operators in Python are shown in Table 3-6, where a and b are Boolean variables.

Table 3-6 Logical Operators in Python

Below, take three numbers, compare the first two, compare the last two, and use logical AND to check if both comparisons hold:

>>> a = 10; b = 20; c = 30
>>> a < b and b < c
True