In Microsoft Excel, parentheses are used in formulas to indicate the order of operations that the formula should follow. In mathematical terms, the order of operations is the set of rules that dictate the sequence in which operations should be performed to get the correct result.
In Excel, parentheses are used to group together certain parts of a formula and to indicate that these parts should be calculated first.
In this article, you will learn about the importance of parentheses in Excel.
What do parentheses mean in Excel?
It is always a good habit to use the parentheses in Excel formulas, even if they are not compulsory for a formula, as they make it look good and more understandable.
We can put parentheses within parentheses and the rule works like this: the innermost parentheses are calculated first and then the outer ones.
When you enter brackets, you will notice that Excel tries to help you by making the matching parentheses bold as you pass over them with the mouse.
There must be a balance of parentheses as sometimes while creating a formula we enter the starting brackets and at the end we might lose count and forgot to enter the ending parentheses. In that case, the Excel will prompt you with an error and it will be easy to know the issue. Excel will make a suggestion as to what it thinks the formula should be. You can accept the recommendation or press "No" to edit the formula yourself.
How to use parentheses in Excel?
The first thing you need to remember is default order of calculations in mathematics:
- Division and multiplication
- Addition and subtraction
As you can see, putting brackets around variables changes the order of calculations and can change the results.
The following are some of the examples we can use to learn the use of brackets:
= 10 + (10*2) result: 30
If there were no parenthesis, the result could be different.
Now the inner bracket is calculated first and then the addition.
=((5*2) + (4 *2) )+ 2 = (10+8) + 2 = 20
How will it look without the use of parentheses:
Which is very confusing to look at.
Let us look at some more examples for more clarification:
I hope you like such math fun calculations in Excel. Like you see, brackets change a lot. So don't be confused. By using parentheses, you can control the order of operations in your formulas, ensuring that they are calculated in the way that you intended.