Creating Complex Formulas

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

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/4Multiply 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.