Excel XP
Creating Complex Formulas
Complex Formulas Defined (continued)
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. |
