# Multiply numbers

Important   The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Let's say you want to figure out how much bottled water that you need for a customer conference (total attendees × 4 days × 3 bottles per day) or the reimbursement travel cost for a business trip (total miles × 0.46). There are several ways to multiply numbers.

What do you want to do?

## Multiply numbers in a cell

To do this task, use the * (asterisk) arithmetic operator.

For example, if you type =5*10 in a cell, the cell displays the result, 50.

## Multiply a column of numbers by a constant number

Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to multiply by is 3, contained in cell C2.

A B C
Data Formula Constant
15000 =A2*\$C\$2 3
12 =A3*\$C\$2
48 =A4*\$C\$2
729 =A5*\$C\$2
1534 =A6*\$C\$2
288 =A7*\$C\$2
4306 =A8*\$C\$2
1. Type =A2*\$C\$2 in cell B2. Be sure to include the \$ symbol before C and before 2 in the formula.

The \$ symbol makes the reference to C2 absolute, which means that when you copy the formula to another cell, the reference will always be to cell C2. If you didn't use \$ symbols in the formula and you dragged the formula down to cell B3, Excel would change the formula to =A3*C3, which wouldn't work, because there is no value in C3

1. Drag the formula in B2 down to the other cells in column B.

## Multiply numbers in different cells by using a formula

To do this task, use the asterisk (*) operator or the PRODUCT function.

### Example

The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Fig. 1  Selecting an example from Help
3. Press Ctrl+C.
4. In the worksheet, select cell A1, and press Ctrl+V.
5. To switch between viewing the results and viewing the formulas that return the results, press Ctrl+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
A B
Data
5
15
30
Formula Description (Result)
=A2*A3 Multiplies the numbers in the first two cells (75)
=PRODUCT(A2:A4) Multiplies all the numbers in the range (2250)
=PRODUCT(A2:A4,2) Multiplies all the numbers in the range by 2 (4500)

You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies the values in two single cells (A2 and G4), two numbers (12 and 150), and the values in three ranges (A4:A15, E3:E5, and H4:J6).

Applies to:
Excel 2013