• Lowell

Calculation Order/Operator Precedence in Excel


If you are new to Excel, you may wonder why a formula does not yield expected results. This is often due to the order in which Excel performs calculations in your formulas, versus how we might process the calculations in our brain.


You may wish to add 5 and 2 together and multiply the results by 3, so you type “=5+2*3” without the quotes into a cell. The = tells Excel you're entering a formula. The * is the symbol for multiplication. Excel answers with 11, after you press the Enter key. Why? Because multiplication has a higher operator precedence than addition. Excel first multiplies 2 times 3, then adds the result to 5. To get the answer you expect (21), use parentheses to change the operator precedence. Your formula should be “=(5+2)*3.” Excel evaluates operations inside parentheses first, then performs the multiplication. When you press Enter, Excel displays 21, the result you intended, because you changed operator precedence with the parentheses.

Let’s use cell addresses next. Suppose the number 5 is in cell A1, 2 is in cell B1, and 3 is in cell C1. Entering = A1+B1*C1 into cell D1, yields 11. Entering =(A1+B1)*C1 yields 21.


This link, https://support.microsoft.com/en-us/office/calculation-operators-and-precedence-36de9366-46fe-43a3-bfa8-cf6d8068eacc has a deeper discussion of operator precedence.


15 views

Related Posts

See All

Easy Excel with Templates

My thanks to my friends at the McGrath Computer Learning Center in Aiken, SC for allowing me to use and edit their article. You’ve heard of Excel, haven’t you? Oh! Yeah, that’s that spreadsheet thingy