Formulas - Order of Operations Cheat Sheet

Question

HI,&nbsp;I am looking to do Order of operations, I have just learnt the basics PEMDAS - If I wanted to change the order of operations I would appreciate any guidance - If any one has a PDF sheet would be great, i would only have 5 calculations at any one point and just need some help on basic formulas.&nbsp;For Example how would the following formulae work&nbsp; 5+10 / 2 +6 *3&nbsp; = 40.5&nbsp;A1&nbsp; &nbsp; &nbsp; &nbsp;B2&nbsp; &nbsp; &nbsp; C3&nbsp; &nbsp; &nbsp; &nbsp;D4&nbsp; &nbsp;E55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp;3&nbsp;Many thanks,&nbsp;Alan&nbsp;

sergeibaklan · Answer

Foxhill07&nbsp;
Alan, order of operations in Excel is described here&nbsp;The order in which Excel performs operations in formulas&nbsp;

foxhill07 · Answer

SergeiBaklan&nbsp;&nbsp;Many thanks for replying - The challenge is that my example does use () first and then division, then addition but then multiples which is out of the sequence.&nbsp;How would you do the orginal example ?&nbsp;Many thanks for your time,&nbsp;Alan

sergeibaklan · Answer

Foxhill07&nbsp;
If to receive 40.5 it'll be
=((5+10)/2+6)*3
or
=((A1+B2)/D4+C3)*E5
That was the question?

foxhill07 · Answer

SergeiBaklan&nbsp;&nbsp;Perfect Sergei - I see using a (( a the beginning and a single) assist the formulae when reverting back to a multiplication.&nbsp;Do you have any recommendation of any on-line videos on this topic or workbooks for additional learning?&nbsp;Much appreciated.&nbsp;Alan

sergeibaklan · Answer

Foxhill07&nbsp;, you are welcome.
&nbsp;
Perhaps you may check Microsoft tutorial - in your Excel go to File-&gt;New, search for "formula tutorial" and open this template

&nbsp;

Forum Discussion

Formulas - Order of Operations Cheat Sheet

7 Replies

Resources