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.