Search

How to change the operator precedence in Excel

Sometimes you may need to change the default operator precedence in Excel. To understand the concept, refer below image.

default-operator-precedence-in-excel.jpg

We know that the operator precedence of multiplication operator is higher than that of addition operator. So, in above example, first 20 is multiplied with 50 and then 10 is added to it. Hence, we got the result 1000+10 = 1010.

Consider that we need the calculation result in other way. That is, we need to add 10 with 20 first and then multiply the result with 50. We must get the result of calculation as (10+20)*50 = 1500.

In this case, we can change the default operator precedence in Excel by using parentheses (brackets). Values inside the parentheses (brackets) are calculated first and then the remaining.

Refer below image.

paratheses-to-change-operator-precedence.jpg

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel