Follow the BODMAS rule
B – Brackets (Parentheses)
O – Orders (Powers/Exponents)
D – Division
M – Multiplication
A – Addition
S – Subtraction
(In US, BODMAS is known as PEMDAS – Parentheses, Exponents, Multiplication, Division, Addition and Subtraction)
Note – Actually, Division and Multiplication have same precedence. Similarly, Addition and Subtraction have the same precedence.
Within a formula, Excel uses following order for various operators –
You may use Parentheses to change the order as Parentheses are calculated first.
