# Multiply and divide numbers in Excel

## 將數字相乘

### 將數字欄乘以常數

1. Type =A2*\$B\$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a \$ symbol before B and before 2 in the formula, and press ENTER.

附註: Using \$ symbols tells Excel that the reference to B2 is "absolute," which means that when you copy the formula to another cell, the reference will always be to cell B2. 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 B3.

2. Drag the formula down to the other cells in the column.

附註: In Excel 2016 for Windows, the cells are populated automatically.

### 使用公式將不同儲存格中的數字相乘

You can use the PRODUCT function to multiply numbers, cells, and ranges.

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 two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4:J6).

## 將數字相除

Let's say you want to find out how many person hours it took to finish a project (total project hours ÷ total people on project) or the actual miles per gallon rate for your recent cross-country trip (total miles ÷ total gallons). There are several ways to divide numbers.

### 使用儲存格參照將數字相除

1. 建立空白的活頁簿或工作表。

2. 選取 [說明] 主題中的範例。

附註: 請不要選取列或欄名。

選取 [說明] 中的範例

3. 按 CTRL+C。

4. 選取工作表中的儲存格 A1，然後按 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, click the Show Formulas button.

 A B C 1 資料 公式 描述 (結果) 2 15000 =A2/A3 將 15000 除以 12 (1250) 3 12

### 將欄數字除以常數

 A B C 1 資料 公式 常數 2 15000 =A2/\$C\$2 3 3 12 =A3/\$C\$2 4 48 =A4/\$C\$2 5 729 =A5/\$C\$2 6 1534 =A6/\$C\$2 7 288 =A7/\$C\$2 8 4306 =A8/\$C\$2
1. Type =A2/\$C\$2 in cell B2. Be sure to include a \$ symbol before C and before 2 in the formula.

2. 將 B2 中的公式向下拖到 B 欄中的其他儲存格。

×