Before moving on, let's explore some more formulas to make sure you understand the order of operations by which Excel calculates the answer.
| 5*3/2 | Multiply 5*3 before performing the division operation because the multiplication sign comes before the division sign. The answer is 7.5. |
| 5/3*2 | Divide 5/3 before performing the multiplication operation because the division sign comes before the multiplication sign. The answer is 3.333333. |
| 5/(3*2) | Perform the operation in parentheses (3*2) first and divide 5 by this result. The answer is 0.833333. |
| 5+3-2 | Add 5+3 before performing the subtraction operation because the addition sign comes before the subtraction sign. The answer is 6. |
| 5-2+3 | Subtract 5-2 before performing the addition operation because the subtaction sign comes before the addition sign. The answer is 6. |
| 5-2*3 | Multiply 2*3 before performing the subtraction operation because the multiplication sign is of a higher order than the subtaction sign. The answer is -1. |
| (5-2)*3 | Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. |
0 Response to "Complex Formulas Defined (continued)"
Post a Comment