The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?

Question

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.

Answer 1

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

Answer 2

sklja;ks

Answer 3

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