Complex Formulas

When you create a complex formula, Excel automatically follows the order of operations. If you want a certain portion of the formula to be calculated first, put it in parenthesesâ€”for example, **=(B8+B9)*A10**.

- Enter the numbers you want to calculate.
- Click the cell where you want the formula
**result**to appear. - Type
**=**. - Click the
**first cell**to be included in the formula. The reference displays where you want your result. - Type a
**mathematical operator**(such as the addition symbol +). The operator displays in the cell and in the Formula bar. - Click the
**second cell**in the formula. The reference displays where you want your result. - Type the next
**operator**in the formula. The operator displays in the cell and un the Formula bar. - Click the
**third cell**to be included in the formula. The reference displays where you want your result. - Repeat steps 7 and 8 until the formula is complete, adding parentheses where necessary.
- Press
**Enter**or click the**Enter button**on the Formula bar to end the formula.

Try changing one of the values in the formula and watch the answer to the formula change.

Excel **will not always tell you** if your formula contains an error, so it's up to you to check all of your formulas. To learn how to do this, read the Double-Check Your Formulas lesson from our Excel Formulas tutorial.