Creating Complex Formulas

In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Complex formulas defined

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/2Multiply 5*3 before performing the division operation because the multiplication sign comes before the division sign. The answer is 7.5.

5/3*2Divide 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-2Add 5+3 before performing the subtraction operation because the addition sign comes before the subtraction sign. The answer is 6.

5-2+3Subtract 5-2 before performing the addition operation because the subtraction sign comes before the addition sign. The answer is 6.

5-2*3Multiply 2*3 before performing the subtraction operation because the multiplication sign is of a higher order than the subtraction sign. The answer is -1.

(5-2)*3Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9.