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