292 WM-OM-E Rev I
Order of Calculations
Operations are performed in the following order:
1. Contents of brackets
2. Exponentiation
3. Division and multiplication
4. Addition and subtraction
If there is any doubt as to how the calculation will be done, use brackets. These will also make the
order of the calculations clear to any reader of the program, which is desirable if you are to give it to
a customer, who will want to know what was intended.
Here are some examples of the uses of brackets:
Brackets are worked out before any other operations are performed.
Use brackets to force the result you want, and also to clarify a calculation.
A 1 1 1 1 1 1 1 1 255 0 1011010 90 (B OR C) AND (D OR E)
B 1 1 1 1 0 0 0 0 240 0 0000000 0 B OR (C AND D) OR E
C 1 0 1 0 1 0 1 0 130 1 1111010 250 B OR (C AND (D OR E))
D 0 1 0 1 0 1 0 1 85 0 1011111 95 ((B OR C) AND D) OR E)
E 0 0 0 0 1 1 1 1 15
F 0 0 0 0 0 0 0 0 0
A 7 315 A * B * (C / D) * E * F
B 6 8.75 A * B * C / (D * E * F)
C 5 35 A * B * (C / (D * E) ) * F
D 4
E 3
F 2
Check these results to see whether any errors, deliberate or otherwise, have been introduced.
These results are from file Brackets.Xls. You can make a copy of that file in order to experiment
with different combinations of brackets.
VBS Controls
Do Do Do
. . . . . . . . . . . .
To Next Page
Loading...
Need help?
General
