Excel is nothing but a tool to help us.
It does not create a new rule for precedence, but follows what we learned in elementary school.
In maths, the rules of precedence PEDMAS (or some variant) are:
Parentheses
Exponentiation
Division/Multiplication
Addition/Subtraction.
They are the same rules you would use with a calculator, or manually.
For example, for D,
25*27/9+5+309*2
=675/9+5+309*2
=75+5+309*2
=75+5+618
=698
The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
A. =(25*(27/9)+5+309)*2
B.=25*((27/9+5)+309*2)
C.=25*(27/9+5)+309*2
D. =25*27/9+5+309*2
Even understanding the basics of Excel was grueling for me, and this question takes the cake. Any help would be extremely appreciated.
3 answers
sklja;ks
25*27 19+5+309*2 25*(27 19 + 5 )+ 309 *2 (25*27 19 +5 +309)*2 (25*27 19 +5 +309)*2 25*(27 19 +5+309*2 result of 778