Scribd
Upload
5 views1 page

Excel Order of Operations Explained

Math operators have a precedence such that multiplication and division are performed before addition and subtraction. Within an expression, operations inside parentheses are completed first, followed by exponents, then multiplication/division from left to right, and finally addition/subtraction from left to right. For the examples given, Excel follows this order of operations to evaluate 11.97+3.99*2 as 19.95, (11.97+3.99)*2 as 31.92, and 100*(1.07)^10 as approximately 200.

Uploaded by

Bacho Akhalaia
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

Excel Order of Operations Explained

Math operators have a precedence such that multiplication and division are performed before addition and subtraction. Within an expression, operations inside parentheses are completed first, followed by exponents, then multiplication/division from left to right, and finally addition/subtraction from left to right. For the examples given, Excel follows this order of operations to evaluate 11.97+3.99*2 as 19.95, (11.97+3.99)*2 as 31.92, and 100*(1.07)^10 as approximately 200.

Uploaded by

Bacho Akhalaia
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Math operators precedence -Multiplication is done before addition: =11.97+3.99*2 is 19.95.

Excel
multiplies 3.99 by 2, then adds the result to 11.97
-Operations inside parentheses take place first: =(11.97+3.99)*2 is 31.92. Excel
adds first and then multiplies the result by 2.
-Exponents are done before multiplication: 100*(1.07)^10 is 200. Excel first
raises 1.07 to 10th power, then multiplies by 100.
-Excel does use operators from left to right if they have the same level of
precedence. Multiplication and division are on the same level. Lower
than multiplication and division, addition and subtraction are on the same
level.

You might also like