Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel

[@excelisfun]

Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel:

[@excelisfun]

Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel

[@faizaashfaq9377]

Excellent explanation again.

[@roderickmose4691]

hi Guys, sorry i'm late to the party but i have a query. In the last example, from time 14:00, comparative operator, i noticed that contrary to the order of precedents excel computed the subtraction first, then the addition last! I'm just wondering whats the rational behind the system being able to determine/execute that order which is contrary to normal PEMDAS?

[@excelisfun]

+roderick mose , The rule is: Adding and subtraction done on the same "level", always going left to right. Multiplying and Division are similar. MD are on same level, AS is on same level. P and E are each on there own "level".

[@alonariel8170]

great