## Monday, 20 February 2012

### 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 is3.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.