### Excel training basics – the BODMAS ‘concept’

BODMAS. The word that tends to divide a room of people on one of our Excel courses up in to one of four groups:

1. Have no idea what we are talking about and never heard of BODMAS
2. Vaguely remember being told about it and learning about it at school but haven’t heard about it since
3. Remember it and are ok about it
4. Remember it clearly, didn’t like it then, don’t like it now and bolt for the door!

Ok so the bolting for the door doesn’t happen that often (thankfully!), people who fall in to the 4th group tend to go quiet and try and hide in their seats so that they aren’t asked a question on it!

So why does this small and seemingly harmless word sometime invoke such a strong reaction in some people?

The reason for this is that BODMAS originates in the Algebra section of Maths days back in school (now this is where people are more likely to bolt for the door, after the word Algebra has been spoken!). Not everyone enjoyed Maths at school and so this is sometimes why not everyone likes the BODMAS topic in our Excel courses.

BODMAS is just an order of precedence built in to Excel that is used when calculations are being worked out in a Spreadsheet. The order goes as follows:

BO – Brackets Override
D – Division
M – Multiplication
S – Subtraction

When a calculation is typed in to a cell, Excel will start at the top of this ‘list’ and work its way down, doing whichever symbol comes first before moving to the next.

To help explain this a bit more, we have created a spreadsheet with a few calculations in it explaining each time why it has done what it has.

We hope this has helped you understand the Excel training basics BODMAS concept a bit more!

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.