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.

Be the First to Respond

Share Your Thoughts

  • Hot
  • Active