This tutorial demonstrates how to multiply cells and columns in Excel and Google Sheets.
Multiply by a Constant
You can simply multiply two numbers and get the result in a cell. Enter the equal sign (=), the first number, the multiplication sign (*), and the second number; then press Enter. For example, the formula in cell C3 below is:
The result in cell C3 is 30.
Instead of having two numbers, you can multiply a cell reference and a constant. Say you want to multiply the number in B3 by 5 and get the result in C3. To do this, enter in C3:
The result is 30, as the value of B3 is 6. Calculating like this, the C3 value will update with a new result every time the value in B3 changes.
Multiply Column With Cell References
As in the previous example, you can use cell references to multiply an entire column by a constant or by another cell. Say you have a table with sales data as in the picture below. In Column B, you have the amount of sold products; in Column C, you have a price per product; and in Column D, you want to calculate the total earned from the sold products. To get the result, multiply B3 by C3, so the formula in D3 is:
The result is 36, because the amount and unit price are both 6. If you want to have all rows populated with the same formula, copy the formula down the table to Row 7.
As you can see, when the formula is copied, every cell in D3:D7 is now populated based on values from Columns B and C.
Paste Special Multiply
Another way to multiply numbers is to use Paste Special. Doing this overwrites selected data with the results of your multiplication. Let’s say you have some amounts in Columns B and want to multiply them by the value in D3 (3).
- Now, select the range you want to multiply by 5 (B3:B7), right-click on the selected area, and choose Paste Special.
- In the Paste Special window, select Multiply, and click OK.
As a result, all cells in the selected range are multiplied by the value from D3 (5).
Note: You can also multiply numbers in Excel by using the PRODUCT Function.
Multiply in Google Sheets
Multiplying in Google Sheets works exactly the same as in Excel. The only difference is that Google Sheets doesn’t have the Paste Special option.