# Excel 2010

## Creating Complex Formulas

### Complex formulas

Simple formulas have one mathematical operation, such as **5+5**. **Complex formulas** have more than one mathematical operation, such as **5+5-2**. When there is more than one operation in a formula, the **order of operations** tells us which operation to calculate first. In order to use Excel to calculate complex formulas, you will need to understand the order of operations.

#### Order of operations

Excel calculates formulas based on the following **order of operations**:

- Operations enclosed in
**parentheses** **Exponential**calculations (to the power of)**Multiplication**and**division**, whichever comes first**Addition**and**subtraction**, whichever comes first

A mnemonic that can help you remember the order is **P**lease **E**xcuse **M**y **D**ear **A**unt **S**ally.

#### Example 1

The following example demonstrates how to use the order of operations to calculate a formula:

#### Example 2

In this example, we will review how Excel will calculate a complex formula using the order of operations. The selected cell will display the percent of total Pete Lily seeds sold that were white.

- First, Excel will calculate the amount sold in parentheses:
**(19*1.99)=37.81**White Lily seeds and**(33*1.99)=65.67**Total Lily seeds. - Second, it will divide the White Lily seeds amount by the Total Lily seeds amount:
**37.81/65.67=.5758**. - Last, it will multiply the result by 100 to obtain the value as a percent:
**.5758*100=57.58**.

Based on this complex formula, the result will show that **57.58%** of the total Pete Lily seeds sold were white. You can see from this example that it is important to enter complex formulas with the correct order of operations. Otherwise, Excel will not calculate the results accurately.