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.