Did you know that there is a default order in which calculations occur in Excel?
And that you can change this order by using brackets? Calculate 4 + 3 x 6. What is your answer? The correct answer is 22. There are two basic Excel rules to remember. - Excel calculates from left to right.
- Multiplication and Division is calculated before addition and subtraction.
Do you remember the acronym BODMAS? BracketsOverDivisionMultiplicationAdditionSubtractionTherefore if you wanted to calculate 4+3 THEN multiply the answer by 6 you would need to write the formula like this. (4+3)*6 Answer is 42. Here is one to practice. Solve 9 – 5 / (8 – 3) x 2 + 6Answer 8.375 or 13?Step 1 9 – 5 / (8 – 3) x 2 + 6 = 9 – 5 / 5 x 2 + 6 Brackets Step 2 9 – 5 / 5 x 2 + 6 = 9 – 1 x 2 + 6 Division Step 3 9 – 1 x 2 + 6 = 9 – 2 + 6 Multiplication Step 4 9 – 2 + 6 = 7 + 6 Subtraction Step 5 7 + 6 = 13 Addition Noticed we did subtraction before addition? This is because we are calculating from left to right. The multiplication and division are in the same order, and subtraction and addition are in the same order. Therefore if we have a division and multiplication in the sum, we calculate left to right. Neither have precedence. Happy Excelling!
0 Comments
## Leave a Reply. |
## AuthorJulie Goleby is the Director of Training in the Tropics ## Archives
August 2018
## Categories |