Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL: Order of Operations in Formulas
Article ID: 25189 - View products that this article applies to.
This article was previously published under Q25189
When you combine several operators into a single formula, Microsoft Excel performs the operations in the following order:
: Range space Intersection , Union - Negation % Percentage ^ Exponentiation * or / Multiplication or Division + or - Addition or Subtraction & Text Operator = < > <= >= <> Comparison Operators
If you want to alter this order, use parentheses to group expressions in your formula. Microsoft Excel first calculates the expression in parentheses, then uses those results to calculate the formula.
For example, the following formula
returns a value of 22, while the formula
returns a value of 30.
NOTE: This order of operation is different from the order of operation in Lotus 1-2-3.
The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.
For more information about operator precedence, click the Index tab in Microsoft Excel 97 Help, type the following text
operators, evaluation order in formulas
and then double-click the selected text to go to the "The order in which Microsoft Excel performs operations in formulas" topic.
For more information about operator precedence, click the Index tab in Microsoft Excel 7.0 Help, type the following text
and then double-click the selected text to go to the "Operator Precedence" topic.
For more information about "Mathematical Operator Evaluation in Lotus 1.2.3 and Microsoft Excel," click the Search button in Microsoft Excel 5.0 Help, type the following, and then click Display:
Article ID: 25189 - Last Review: August 16, 2005 - Revision: 1.1