What is a Bodmas formula and how to use it
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Topics » What is a Bodmas formula and how to use it

What is a Bodmas formula and how to use it

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;

=(8+2)*5

This would return 50.

Related forum posts:

what is BODMAS

What is bodmas

Read forum post

 

BODMAS

Not sure of this..how is =A1+B1*C1 equal 7?

Read forum post

 

bodmas

what is the definition of this please?

Read forum post

 

Format

What does DOBMAS stand for?

Read forum post

 

Bodmas

How do you use bodmas?

Read forum post

 

BRACKETS

PLEASE CAN YOU GIVE SOME MORE INFORMATION WITH REGARD TO WHEN BRACKETS SHOULD BE USED?

Read forum post

 

unit 2

how do you complete a formula using bedmas/bodmas?

Read forum post

 

Related articles

The Secret Formula To Creating Correct Calculations In Excel

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.

Read article

 

Using Excel 2007/2010's Formula Checking Features

Find out how Excel can help you determine visually which cells are used in a formula, and learn how to use alerts and formula auditing for further investigation.

Read article

 

How To Create Formulas In Excel

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.

Read article

 



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom