Bodmas stands for "brackets of division, multiplication, addition, subtraction".
It is the order of how Microsoft Excel works out how to perform the order of calculations.
An example would be 8 + 2 * 5. You might look at this equation and come to the answer of 50. However, excel would return an answer of 18. This difference is that because of the bodmas model excel will run the equation this way 2 * 5 + 8. Where there is a * (multiplication) or a ? (division) coming after a + (plus) or - (minus) excel will always use the bodmas model and reverse this equation.
To overcome this the user can enforce the equation to be calculated the way it is shown by using brackets, so the equation above would look like this;
Did you know that remembering and understanding a basic maths calculation could save you time and money when using Excel? Find out if you need to go back to the classroom before applying correct formula to your worksheets.
Do you want to learn how to use formulas in Excel? This article shows you how, right from the beginning. Learn how to create calculations, using brackets, understand order of calculation and much more. Read on for an easy starting guide.