If you're not working with numbers all the time or you're not comfortable with mathematics’ then it's well worth a refresher on How To Apply Correct Order Of Operations

How To Apply Correct Order Of Operations 1


It is the correct order in which calculations are applied in excel and indeed anywhere else in the mathematics world, firstly any calculations within parentheses are performed should there be parentheses within parenthesis or a nested formula as it might be called then the nested parentheses within other parentheses are performed first.

How To Apply Correct Order Of Operations 2

 

How To Apply correct exponents or exponential Operations

We apply correct exponents or exponential then multiplication and division and finally addition and subtraction probably the best way to look at this is just going through a couple of example. 

How To Apply Correct Order Of Operations 3

 Example one have got a formula here equals five-plus, ten over five if you've forgotten about applying correct order operations you are going to be inclined just to read the formula from left to right and you might go 5 plus 10 equals 15 divided by 5 equals 3. 

How To Apply Correct Order Of Operations

However, you should be dividing the addition well .We can simplify that formula by taking the 10 divided by 5 and making it 2 as in step two-step number three five plus two equals seven .

So if we wanted to change the correct order of operations have a look at example two.
Now we put the five-plus ten in parenthesis step two is going to be to perform the calculation within parenthesis first and we can simplify that to 15 divided by five and step three is simple to perform that 15 divided by five which gives us three a slightly more complicated example to give.

perform the division Order Of Operations

 You an idea about nested parenthesis example three we've got two sets of parentheses. We have an inner set of parentheses. 10 times 2 we perform the 10 times 2 first, so we can simplify that in step 2 and the 10 times 2 becomes 20. So, now we have one set of parentheses and within that parenthesis, We have 5 plus 20 divided by 2.

 Here we perform the division before the addition as per the correct order of operations rules and in step 320 divided by 2 becomes 10 so we have 5 plus 10 in the parenthesis all multiplied by 2, we can simplify what's in the parenthesis 2 15, we have 15 times 2 which equals 30. 

It's worth practicing some of these examples and any you can make up yourself to hammer home any of these principles if they are a bit rusty thank you.