下表說明比較運算子的描述與符號：
表格 11-4 比較運算子
| 描述 | 符號 |
|---|---|
| 等於 | = |
| 不等於 | <> |
| 小於 | < |
| 大於 | > |
| 小於或等於 | <= |
| 大於或等於 | >= |
下列範例說明比較運算子的用法：
範例 1：
Dim A, B, IsNotEqual A = 10 B = 20 IsNotEqual = (A <> B) ' Inequality: A <> B 'IsNotEqual: A does not equal B: True
範例 2：
Dim A, B, IsLessThan A = 10 B = 20 IsLessThan = (A < B) ' Less than: A < B 'IsLessThan: A is less than B: True
範例 3：
Dim A, B, IsGreaterThan A = 20 B = 10 IsGreaterThan = (A > B) ' Greater than: A > B 'IsGreaterThan: A is greater than B: True
範例 4：
Dim A, B, IsLessThanOrEqual A = 10 B = 10 IsLessThanOrEqual = (A <= B) ' Less than or equal to: A <= B 'IsLessThanOrEqual: A is less than or equal to B: True