Use of Brackets in Excel Formulas:
We should use the brackets, (also known as 'braces'), in the formula. It
ensure that the calculations are performed in the order that you need.The need
for brackets occurs when you mix
Plus or
Minus with
Divide or
Multiply.
In the mathematical terminology the * (Multiply) and / (Divide) are more important than + (Plus) and - (Minus). The * and / operations will be calculated before + and -
Example 1 : The wrong answer !
Example 2 : The correct answer !
By placing brackets around (10+20) Excel performs this part of the calculation first, resulting in 30, then the 30 is multiplied by 2 resulting in 60.
No comments:
Post a Comment