# 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.

### Creating simple multiplication formulas

Creating multiplication formulas is similar to addition and subtraction formulas. To **multiply** two cells the formula—B2 and B3—you would need to insert a multiplication operator * between them: **=B2*B3**.

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

- Type the numbers you want to calculate in separate cells (for example, type 128 in cell B2 and 345 in cell B3).
- Click the cell where the answer will appear (B4, for example).
- Type the equals sign (=) to let Excel know a formula is being defined.
- Click the
**first cell** to be included in the formula (B2, for example). - Type a
**mathematical operator** (the multiplication symbol, or *). The operator displays in the cell and Formula bar. - Click the
**next cell** in the formula (B3, for example). - If you include multiple cells in the formula, repeat steps 4 and 5 until the entire formula is entered.
- Press
**Enter**, or click the **Enter button** on the Formula bar to complete the formula.