# Creating Simple Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

#### To create a simple formula that multiplies the contents of two cells:

- Select the cell where the answer will appear (E32, for example).
- Type the equals sign (=) to let Excel know a formula is being defined.
- Click on the
**first cell** to be included in the formula (C9, for example), or type a number. - Type the multiplication symbol (*) by pressing the Shift key and then the number 8 key. The operator displays in the cell and Formula bar.
- Click on the
**next cell** in the formula or type a number (12, for example). - Press
**Enter**, or click the **Enter button** on the Formula bar to complete the formula.

#### To create a simple formula that divides one cell by another:

- Click the cell where the answer will appear.
- Type the equals sign (=) to let Excel know a formula is being defined.
- Click on the
**first cell** to be included in the formula. - Type a division symbol. The operator displays in the cell and Formula bar.
- Click on the
**next cell** in the formula. - Press
**Enter**, or click the **Enter button** on the Formula bar to complete the formula.