This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers in one Excel cell or multiply two or more Excel cells.
Step
Method 1 of 3: Multiplying in a Cell
Step 1. Open Excel
Open the green app with the white "X" on it.
- Click Blank workbook on PC or New then Blank Workbook on the Mac to continue.
- If you already have a specific file to open, double-click it to open it.
Step 2. Click a cell
By clicking on a cell, you can type in it.
Step 3. Type = into the cell
All formulas in Excel start with an equal sign.
Step 4. Enter the first number
The number entered is typed directly after the "=" sign without using a space.
Step 5. Type * after the first number
An asterisk indicates that you want to multiply the number before the asterisk by another number after it.
Step 6. Enter the second number
For example, if you enter the number 6 and want to multiply it by 6, the formula will look like =6*6.
You can repeat this process with as many numbers as you want, as long as you insert an "*" between each number you want to multiply
Step 7. Press Enter
This step will run the formula. The cell will display the multiplication result of the formula, although if you click on the cell, the formula will appear in the address bar in Excel.
Method 2 of 3: Multiplying Multiple Cells
Step 1. Open the Excel file
Double-click an Excel document to open it.
Step 2. Click a cell
By clicking on a cell, you can type in it.
Step 3. Type = into the cell
All formulas in Excel start with an equal sign.
Step 4. Type in the address of another cell
The address entered is typed directly after the "=" sign without using a space.
For example, enter "A1" in the cell to set the value to A1 as the first number in the formula
Step 5. Type * after the first cell
An asterisk indicates to Excel that you want to multiply the previous value by the next value.
Step 6. Type in the address of another cell
This step will enter the value in the second cell in the formula as the second variable.
-
For example, type "D5" into a cell so the formula would look like this:
=A1*D5
- .
- You can add more than two cell addresses to this formula, as long as you type an "*" between the cell addresses.
Step 7. Press Enter
This step will run the formula and display the results in the selected cells.
When you click the cell that contains the product of the multiplication, the formula will appear on the address bar in Excel
Method 3 of 3: Multiplying a Range of Cells
Step 1. Open the Excel file
Double-click an Excel document to open it.
Step 2. Click a cell
By clicking on a cell, you can type in it.
Step 3. Type =PRODUCT(into the cell
This command indicates that you want to multiply multiple values at once.
Step 4. Type in the address of the first cell
This cell must be at the top of the range of data that you want to multiply.
For example, you could type "A1" here
Step 5. Type:
. A colon (":") indicates in Excel that you want to multiply all cells from the first cell to the next typed cell.
Step 6. Type in the address of another cell
This cell must be in the same column or row as the first cell in the formula if you want to multiply all cells from the first to this cell.
For example, if you type "A5", the formula will multiply all the cell contents from A1, A2, A3, A4, and A5
Step 7. Type), then press Enter
The last parenthesis ends the formula, and pressing Enter executes the command and multiplies all cells in the range and displays the result directly in the selected cell.
