Sometimes you will need to use brackets, (also known as 'braces'), in formula.
This is to 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.
Mathematically speaking the * and / are more important than + and -
The * and / operations will be calculated before + and -
Example 1 : The wrong answer !
Example 2 : The correct answer
This is to 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.
Mathematically speaking the * and / are more important than + and -
The * and / operations will be calculated before + and -
Example 1 : The wrong answer !
C
|
||
12
|
10
|
|
13
|
20
|
|
14
|
2
|
|
15
|
50
|
=C12+C13*C14
|
Example 2 : The correct answer
C
|
|||
27
|
10
|
||
28
|
20
|
||
29
|
2
|
||
30
|
60
|
=(C27+C28)*C29
| |
By placing brackets around (10+20)
Excel performs this
|
|
part of the calulation first,
resulting in 30
|
|
Then the 30 is multipled by 2
resulting in 60
|
|
No comments:
Post a Comment