Microsoft Excel 2013 uses functions to display the results of computations. The Insert Function option allows you to choose what you and helps you display the results. Learn how to use functions to multiply cells and columns in Excel.

## Video of the Day

## Multiplying Cells

In Excel, each box, or cell, is identified by the letter of the column followed by the number of the row. In the example, the cell that shows the price of a large, blue t-shirt is B4. Functions are denoted with the equals sign followed by what you want to show and what cells you want to use for the computation. Multiplication answers are called products. The function for multiplying in Excel is displayed as "=PRODUCT(X#:X#)."

Click the cell where you want the product displayed (showed here as D4). Click **f _{x}** to open the Insert Function pop-up dialog box. Select

**PRODUCT**and then click

**OK.**

Depending on how your cells are arranged, Excel shows a logical guess as to the cells you want to multiply. In the example, Excel has chosen the two preceding cells in the row and shows them as B4:C4. If the cells are the ones you want, click **OK.** If you want different cells, enter the cells you want in the Function Arguments pop-up dialog box**.**

There are three ways to enter cells into the number fields.

- Type the
**cell location**in the number field using its letter and number. - Click the
**cell finder icon**and then click the cell you want. - Click the
**number field**and then click the cell you want.

#### Step

Click **OK** to finish. The function displays in the function box and the answer displays in the cell you first selected (in this case, D4).

## Multiplying the Cells in One Column

To multiply all the cells in one column, choose the cell where you want the product (in this case, A33) and then click **f _{x}** to open the Insert Function pop-up dialog box. Choose

**PRODUCT**and click

**OK.**

Highlight the cells you want to multiply in the column by clicking and holding as you move the cursor. The highlighted area will have a dotted line around it. Click **OK.**

## Multiplying the Cells in Two or More Columns

#### Step

To multiply all of the cells in one column by all of the cells in another column, click first on a cell where you want the answer (in this case, C33). Click **f _{x}** to open the Insert Function pop-up dialog box.

#### Step

Click the Number 1 field and then highlight the cells in the first column.

#### Step

Click the Number 2 field and then highlight the cells in the next column. Click **OK** to finish.