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