Forum Thread: Please Excuse My Dear Aunt Sally

Be very careful while using the mathematical operators in excel. Use parenthesis to group the numbers. Excel follows the mathematical order of operators BODMAS

B: Bracket
O: Order/ Power of
D: Division
M: Multiply
A: Addition
S: Subtraction

Some people may also call it PEDMAS (Please excuse my dear aunt sally!!)
P: Parenthesis
E: Exponent
D: Division
M: Multiply
A: Addition
S: Subtraction

So if you have many operators clubbed together, the above order will be used. Watch this video to see how same operators can give different results.