Excel 2007
Creating Complex Formulas
Complex formulas
Before moving on, let's explore some more formulas to make sure you understand the order of operations by which Excel calculates the answer.
| 4*2/4 | Multiply 4*2 before performing the division operation because the multiplication sign comes before the division sign. The answer is 2. |
| 4/2*4 | Divide 4 by 2 before performing the multiplication operation because the division sign comes before the multiplication sign. The answer is 8. |
| 4/(2*4) | Perform the operation in parentheses (2*4) first, and divide 4 by this result. The answer is 0.5. |
| 4-2*4 | Multiply 2*4 before performing the subtraction operation because the multiplication sign is of a higher order than the subtraction sign. The answer is -4. |
