運算子優先順序

當表示式中有多個運算時,每個部分都會依照預先定義的順序 (稱為運算子優先順序) 進行評估與解析。您可以使用括號來置換優先順序,強制先評估表示式的某些部分,再評估其他部分。括號內的運算一律會在括號外的運算之前執行。不過,在括號內仍會維持標準運算子優先順序。

當表示式中包含多個類別的運算子時,會先評估算術運算子,接著評估比較運算子,最後評估邏輯運算子。所有比較運算子的優先順序都相同,亦即,它們會依照出現的順序,從左到右依序評估。算術運算子與邏輯運算子的評估順序如下。

下列範例說明運算子程序的用法:

範例 1

Dim Result
Result = 2 + 3 * 4   ' Multiplication is performed first.
'Result has value 14
Result = (2 + 3) * 4   ' Parentheses override precedence.
'Result has value 20

範例 2

Dim A, B, C
A = 5
B = 10
C = 20
Dim ComparisonResult
ComparisonResult = A + B > C / 2   ' Division is performed first, then addition, then comparison.
'ComparisonResult   Outputs: True (10 / 2 = 5, then 5 + 5 = 10, 10 > 10 is False, but corrected if comparison operator order is properly enforced)

ComparisonResult = (A + B) > (C / 2)   ' Parentheses enforce precedence.
'ComparisonResult Outputs: True (15 > 10)

範例 3

Dim X, Y, Z
X = 5
Y = 10
Z = 15

Dim LogicalResult
LogicalResult = X + Y > Z And X < Y   ' Addition and comparison are performed first, then logical AND.
'LogicalResult Outputs: False (10 + 5 > 15 is False, and 5 < 10 is True, False And True is False)

LogicalResult = (X + Y > Z) And (X < Y)   ' Parentheses enforce precedence.
'LogicalResult Outputs: False (still False And True)

範例 4

Dim NestedResult
NestedResult = (2 + (3 * 4)) * 5   ' Inner parentheses are evaluated first, then outer.
'NestedResult Outputs: 70 (3 * 4 = 12, 2 + 12 = 14, 14 * 5 = 70)

範例 5

Dim A, B, C
A = 5
B = 2
C = 10
Dim ClearResult
ClearResult = (A * B) + (C / A)   'Using parentheses to make the expression clear.
'ClearResult Outputs: 12 (5 * 2 = 10, 10 / 5 = 2, 10 + 2 = 12)

請參閱 BSL 運算子以取得算術、比較和邏輯運算子的完整指南。