Forum Discussion
Foxhill07
Jan 04, 2020Copper Contributor
Formulas - Order of Operations Cheat Sheet
HI, 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...
SergeiBaklan
Jan 04, 2020Diamond Contributor
Alan, order of operations in Excel is described here The order in which Excel performs operations in formulas
- Foxhill07Jan 04, 2020Copper Contributor
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.
How would you do the orginal example ?
Many thanks for your time,
Alan
- SergeiBaklanJan 04, 2020Diamond Contributor
- Foxhill07Jan 04, 2020Copper Contributor
Perfect Sergei - I see using a (( a the beginning and a single) assist the formulae when reverting back to a multiplication.
Do you have any recommendation of any on-line videos on this topic or workbooks for additional learning?
Much appreciated.
Alan