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

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
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
Similar Questions
  1. How to do Excel Spreadsheet- Formulas?I have to do an excel spreadsheet for my computer class. Problem is my professor didn't at
    1. answers icon 1 answer
    1. answers icon 1 answer
  2. Precedence of operatorsIn simple algebra, there is a set of precedence (priority) of operations that should be respected in
    1. answers icon 0 answers
    1. answers icon 1 answer
more similar questions