Posted by vedrana on Thursday, September 1, 2011 at 2:44pm.
A simplified order of precedence in Excel is:
()
* and /
+ and -
* and / have the same precedence, so the formula will be evaluated from left to right if one follows the other.
To check the order, you would look for parentheses, the enclosed content of which will be executed first.
Then you would look for * and /.
They would be executed next, from left to right.
Then you would look for + and -, again they would be from left to right.
If you follow the above rules, you will have no problem finding the right answer, which is not (a) 119+7 because there are other operators that have a higher precedence than "+".
Post your answer for a check if you are not sure.
Also, see the following article from Microsoft:
http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010078886.aspx
Related Questions
math - The diagram of airport runway intersections shows 2 parallel runways. A ...
math - An airport runway intersections shows 2 parallel runways. A taxiway ...
calculus - Now we prove Machin's formula using the tangent addition formula...
managerial economics - my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...
statistics - Statistics. The lowest temperature ever recorded in the state of ...
math - The table shows the median home prices in Florida. What is the equation ...
math, algebra - The problem states find the simple interest . Assume a 360 day ...
Maths' - What percentagge of £119.25p is £11.04p? Divide: 11.04 ...
Computers Excel 2007 - Performing what if analysis
Physics - A ball is launched with a velocity of 10 m/s at an angle of 50.0 ...
For Further Reading
