Question

Which operation would occur in the equation =C3+D5*C6-B2 in excel.

Answer 1

Answer:

The operation that will occur first is D5*C6 (multiplication).

Explanation:

Excel’s default order of operator precedence mandates that Excel perform multiplication before addition and substraction. If you want the addition or substraction to be performed before multiplication or division, they must be in parentheses.

The order of operations in exel is:

1. Evaluate items in parentheses.

2. Evaluate ranges (:).

3. Evaluate intersections (spaces).

4. Evaluate unions (,).

5. Perform negation (-).

6. Convert percentages (%).

7. Perform exponentiation (^).

8. Perform multiplication (*) and division (/), which are of equal precedence.

9. Perform addition (+) and subtraction (-), which are of equal precedence.

10. Evaluate text operators (&).

11. Perform comparisons (=, <>, <=, >=).