Example #1: If we typed +100*.05+4/2 into a cell, what value would be displayed - would it be 7 or 4.5?
Answer to Example #1 is 7 since we must perform multiplication and division, before we add and subtract. Must divide 4/2 before we add it to the product of 100*.05 to get 5 + 2 = 7 as our answer.
Example #2: If we typed +200+50/5*4-20 into a cell, what value would be displayed - would it be 180 or 220?
Answer to Example #2 is 220 since we must first take 50/5 and get 10, then multiply it by 4 to get 40. All this must be calculated BEFORE we add it all together with 200 + 40 - 20 to get 220 as the answer.