| 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 ! | ||||||||
| 10 | ||||||||
| 20 | ||||||||
| 2 | ||||||||
| 50 | =C12+C13*C14 | |||||||
| You may expect that 10 + 20 would equal 30 | ||||||||
| And then 30 * 2 would equal 60 | ||||||||
| But because the * is calculated first Excel sees the | ||||||||
| calculation as 20 * 2 resulting in 40 | ||||||||
| And then 10 + 40 resulting in 50 | ||||||||
| Example 2 : The correct answer. | ||||||||
| 10 | ||||||||
| 20 | ||||||||
| 2 | ||||||||
| 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 | ||||||||
Wednesday, 18 September 2013
Brackets in formula
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment