Excel VBA Operator Precedence – Order of Operations with Examples

Excel VBA Operator Precedence

Understand the Order of Operations in VBA with Practical Examples

← Previous Operator Precedence Next →

1. What is Operator Precedence in VBA?

Operator precedence defines the order in which VBA evaluates different operators when multiple operators appear in the same expression.

In simple words, when VBA sees a calculation containing several operators, it needs to know: Which operation should be performed first?

Example:

10 + 5 * 2

VBA does not normally calculate this from left to right. Multiplication has higher precedence than addition.

Therefore:

10 + (5 * 2) = 10 + 10 = 20

Important: Operator precedence becomes especially important when you combine arithmetic, comparison, logical, and concatenation operators.

2. Why is Operator Precedence Important?

Understanding precedence helps you write correct VBA calculations and avoid unexpected results.

For example:

Dim result As Double result = 10 + 20 * 3 MsgBox result

The result is:

70

It is not 90 because multiplication happens before addition.

3. Basic Rule of Operator Precedence

VBA evaluates operators according to their precedence. Operators with higher precedence are evaluated before operators with lower precedence.

Common Arithmetic Order

Priority	Operator	Meaning
1	()	Parentheses
2	^	Exponentiation
3	-	Unary negation
4	* /	Multiplication and Division
5	\	Integer Division
6	Mod	Remainder
7	+ -	Addition and Subtraction
8	&	String Concatenation
9	= <> < > <= >=	Comparison
10	Not	Logical NOT
11	And	Logical AND
12	Or	Logical OR

Tip: When in doubt, use parentheses. Parentheses make your intention clear and make your VBA code easier to understand.

4. Parentheses Have the Highest Priority

Parentheses allow you to explicitly control the order of calculation.

Without Parentheses

result = 10 + 5 * 2

Result:

20

With Parentheses

result = (10 + 5) * 2

Result:

30

5. Multiplication Before Addition

Dim result As Double result = 10 + 5 * 4 MsgBox result

VBA evaluates:

5 * 4 = 20 10 + 20 = 30

Final result:

30

6. Division Before Addition

result = 100 + 20 / 5

First:

20 / 5 = 4

Then:

100 + 4 = 104

Result = 104

7. What Happens When Operators Have the Same Precedence?

When operators have the same precedence, VBA generally evaluates them from left to right.

Example

result = 100 / 10 * 2

Division and multiplication have the same precedence.

So VBA evaluates:

100 / 10 = 10 10 * 2 = 20

Result = 20

Important: Do not assume multiplication always happens before division. They have the same precedence.

8. Exponentiation (^) Has High Precedence

The ^ operator is used for powers.

result = 2 + 3 ^ 2

First:

3 ^ 2 = 9

Then:

2 + 9 = 11

Result = 11

9. Understanding the Mod Operator

The Mod operator returns the remainder after division.

result = 17 Mod 5

Because:

17 ÷ 5 = 3 remainder 2

Result = 2

Example with Addition

result = 10 + 17 Mod 5

VBA calculates:

17 Mod 5 = 2 10 + 2 = 12

10. Integer Division (\)

The backslash operator \ performs integer division.

result = 17 \ 5

The result is:

3

The fractional portion is discarded.

11. Unary Minus

A minus sign can also be used to make a number negative.

result = -5 + 10

Result:

5

12. Combining Multiple Arithmetic Operators

Consider this expression:

result = 10 + 20 * 3 - 8 / 2

VBA first performs multiplication and division:

20 * 3 = 60 8 / 2 = 4

Then:

10 + 60 - 4

Finally:

70 - 4 = 66

Result = 66

13. Changing the Order Using Parentheses

Compare these two expressions.

Example 1

result = 10 + 20 * 3

Result = 70

Example 2

result = (10 + 20) * 3

Result = 90

Parentheses changed the calculation order.

14. Real-World Example – Invoice Calculation

Suppose you are creating an invoice using VBA.

Quantity = 5
Price = ₹100
Shipping = ₹50
Discount = ₹20

We can calculate the total as:

Total = Quantity * Price + Shipping - Discount

VBA evaluates:

5 * 100 = 500 500 + 50 = 550 550 - 20 = 530

Final Invoice Total = ₹530

Complete VBA Code

Sub InvoiceCalculation() Dim Quantity As Integer Dim Price As Double Dim Shipping As Double Dim Discount As Double Dim Total As Double Quantity = 5 Price = 100 Shipping = 50 Discount = 20 Total = Quantity * Price + Shipping - Discount MsgBox "Invoice Total = ₹" & Total End Sub

15. Real-World Example – Percentage Discount

Suppose a product costs ₹1,000 and the discount is 10%.

Price = 1000 Discount = 10 FinalPrice = Price - Price * Discount / 100

VBA calculates:

Price * Discount = 1000 * 10 = 10000 10000 / 100 = 100 1000 - 100 = 900

Final Price = ₹900

16. Why Parentheses Make Calculations Safer

Although this works:

FinalPrice = Price - Price * Discount / 100

A clearer version is:

FinalPrice = Price - (Price * Discount / 100)

Parentheses clearly show which calculation represents the discount.

Best Practice: Use parentheses when a calculation could be misunderstood by another programmer or by your future self.

17. Operator Precedence and Concatenation (&)

The & operator combines text values.

Dim Name As String Dim Age As Integer Name = "Chirag" Age = 42 MsgBox "Name: " & Name & ", Age: " & Age

Output:

Name: Chirag, Age: 42

Understanding precedence becomes important when you combine calculations and text.

MsgBox "Total: " & 100 + 50

For clarity, use parentheses around the calculation:

MsgBox "Total: " & (100 + 50)

Output: Total: 150

18. Arithmetic Before Comparison

Consider:

If 10 + 5 * 2 > 15 Then MsgBox "Yes" End If

First:

5 * 2 = 10 10 + 10 = 20 20 > 15

Therefore the condition is True.

Message: Yes

19. Logical Operators and Precedence

VBA also has logical operators such as:

• Not
• And
• Or

For example:

If Age >= 18 And Salary > 30000 Then MsgBox "Eligible" End If

VBA evaluates the comparison expressions before applying the logical operator.

20. Complex Expression Example

result = (10 + 5) * 2 ^ 2 - 20 / 5

Let's evaluate it step by step.

Step 1 – Parentheses

10 + 5 = 15

Step 2 – Exponent

2 ^ 2 = 4

Step 3 – Multiplication

15 * 4 = 60

Step 4 – Division

20 / 5 = 4

Step 5 – Subtraction

60 - 4 = 56

Final Result = 56

21. Excel Cell Calculation Example

Operator precedence is also important when working with Excel cells.

Suppose:

• A2 = Quantity
• B2 = Price
• C2 = Shipping
• D2 = Discount

Range("E2").Value = Range("A2").Value * Range("B2").Value _ + Range("C2").Value _ - Range("D2").Value

Multiplication occurs before addition and subtraction.

A clearer version is:

Range("E2").Value = _ (Range("A2").Value * Range("B2").Value) _ + Range("C2").Value _ - Range("D2").Value

22. Common Mistake – Reading Left to Right

Wrong assumption:

10 + 5 * 2 10 + 5 = 15 15 * 2 = 30

This is not how VBA evaluates the expression.

The correct order is:

5 * 2 = 10 10 + 10 = 20

Correct Result = 20

23. Common Operator Precedence Mistakes

Mistake	Better Approach
Assuming VBA calculates everything left-to-right	Understand operator precedence
Ignoring parentheses	Use parentheses for important calculations
Assuming * always happens before /	Remember * and / have the same precedence
Writing very complicated one-line calculations	Break calculations into smaller variables
Mixing calculations and text without parentheses	Use parentheses around calculations

24. Best Practices

1. Understand the precedence rules.
2. Use parentheses for clarity.
3. Break complex calculations into smaller steps.
4. Use meaningful variable names.
5. Test important calculations with known values.
6. Do not rely on memory when a calculation can be made clearer with parentheses.

Instead of:

Total = A * B + C * D - E / F

Consider:

Subtotal1 = A * B Subtotal2 = C * D Discount = E / F Total = Subtotal1 + Subtotal2 - Discount

This is easier to read, test, and maintain.

25. Operator Precedence Quick Reference

Order	Operator	Purpose
1	()	Parentheses
2	^	Exponentiation
3	Unary -	Negative value
4	* /	Multiplication / Division
5	\	Integer Division
6	Mod	Remainder
7	+ -	Addition / Subtraction
8	&	Concatenation
9	= <> < > <= >=	Comparison
10	Not	Logical NOT
11	And	Logical AND
12	Or	Logical OR

26. Practice Questions

Question 1:

What is the result?

10 + 5 * 2

Question 2:

What is the result?

(10 + 5) * 2

Question 3:

What is the result?

100 / 10 * 2

Question 4:

What is the result?

20 + 10 * 2 - 5

Question 5:

What is the result?

(20 + 10) * (2 - 5)

Question 6:

What is the result?

2 + 3 ^ 2

27. Practice Answers

Question	Answer
10 + 5 * 2	20
(10 + 5) * 2	30
100 / 10 * 2	20
20 + 10 * 2 - 5	35
(20 + 10) * (2 - 5)	-90
2 + 3 ^ 2	11

28. Mini Project – Calculate Employee Salary

Let's use operator precedence in a practical salary calculation.

Suppose:

• Basic Salary = ₹30,000
• HRA = 20%
• Bonus = ₹5,000
• Deduction = ₹2,000

Sub CalculateSalary() Dim BasicSalary As Double Dim HRA As Double Dim Bonus As Double Dim Deduction As Double Dim NetSalary As Double BasicSalary = 30000 HRA = 20 Bonus = 5000 Deduction = 2000 NetSalary = BasicSalary + _ (BasicSalary * HRA / 100) + _ Bonus - _ Deduction MsgBox "Net Salary = ₹" & NetSalary End Sub

The calculation is:

HRA = 30000 * 20 / 100 HRA = 6000 Net Salary = 30000 + 6000 + 5000 - 2000 Net Salary = 39000

Net Salary = ₹39,000

29. Summary

Operator precedence tells VBA which operator should be evaluated first when an expression contains multiple operators.

• Parentheses can control the calculation order.
• Exponentiation is performed before multiplication and addition.
• Multiplication and division have the same precedence.
• Addition and subtraction have the same precedence.
• Operators with the same precedence are generally evaluated from left to right.
• Comparison operators are evaluated after arithmetic operations.
• Logical operators are used after the relevant comparisons.
• Parentheses make complex calculations easier to understand.

Golden Rule: If you are not completely sure about the evaluation order, use parentheses.

30. What Should You Learn Next?

Now that you understand individual operators, assignment, concatenation, and operator precedence, the next important topic is:

Expressions in Excel VBA

In the next lesson, you will learn how to combine variables, operators, functions, values, and parentheses to create complete VBA expressions.

Next Topic: Excel VBA Expressions – Combining Operators, Variables & Values

Keep Learning Excel VBA 🚀

Practice each example in the VBA Editor and change the numbers to see how operator precedence affects the result.

Learn → Practice → Build Real VBA Projects

← Assignment Operator Operator Precedence Next →

```