Home Resources Tip of the Week Archive Order of Operation

Standard Courses

Individual Mentoring

Help!

 Not sure of how to tackle your next task?

It can be difficult to know if you're going about it the right way. 

Which method will deliver the optimum outcome?

 Salvatore_Vuono_Keyboard_Solution_2

Perhaps your question has already been answered. 

Check the Help Desk Archive. 

Don't sit there trying to figure it out until your veins pop.

Ask the MBST Help Desk.

The answer may be simpler than you expect!
Order of Operation PDF Print E-mail
User Rating: / 0
PoorBest 
Written by Diana Angenent   
Monday, 30 April 2012 00:00
Did you know that mathematical formulae do not read left to right as we read English?
All formulas need to start with an = sign but what order do you enter the values and when do you use brackets? When a formula contains more than one operator, the order of evaluation is as follows:
  • Percentages ( % )
  • Exponents ( ^ )
  • Multiplication and Division ( * / )
  • Addition and Subtraction ( + – )
You can change the order in which the operations are calculated by placing brackets around the part of the formula you want calculated first.
In school, I remember this rule being referred to as BODMAS (Brackets over Division, Multiplication, Addition and Subtraction).

 
 

Training Facilities

Tip of the Week

Get your computer to go faster!

Start utilising shortcuts in Microsoft applications, by making one small change to the way you use your computer today.

Check out the Tip of the Week Archive for some free info.

Subscribe to our free Tip of the Week e-learning resource and we'll introduce you to a new shortcut each week.

Join this growing community and make your computer easier to use.

Idea_Go_Water_Tree_2
| MBST | ABN 30 464 117 469 | Privacy Statement | Communications Policy