Multiplying numbers is among the most fundamental arithmetic functions that are commonly performed in Excel. There are a variety of ways you can multiply using Excel All you have to do is develop an easy formula to accomplish it.
Let’s look at how you can design an equation for multiplying numbers cell, ranges and columns.
Table of Contents
Multiplying in Excel Using Multiplication Symbol
To make a multiplication formula within the Excel cell, always start the formula by using the equal symbol (=) and then use the symbol of the asterisk (*) or the PRODUCT function to multiply cells or numbers. By using the method above, you are able to easily multiply cells, numbers, rows, columns and columns.
Multiplying Numbers in Excel
Utilize the formula below to multiply numbers within cells.
If you use the formula above in Cell E1, then the result will also be shown in the same cell. Check out the following example.
Multiplying Cells in Excel
For multiplying two cells by values, use the formula above, but using reference numbers instead of cell names. For instance, to multiply the value of the cells B1 and A1, we entered “=A1*B1”.
Multiplying Columns in Excel
To multiply two columns of figures in Excel Enter the following formula to multiply cells.
After entering your formula into the cell that you first entered (D1 in the next example) Click at the tiny green rectangle (fill handle) in the lower-right corner of D1. Drag it down to cell D5.
The formula is copied to D1:D5 in column D and columns B and A are then multiplied and the results are shown within column D.
It is possible to multiply multiple cells by simply adding a ‘*’ after each reference to a cell. For instance the formula below can multiply the cell value in cells A3, B2, A4, and B5.
Multiplying a Column by a Constant Number in Excel
Let’s say you wish the ability to divide a row of numbers by the same number within another cell. It is possible to do this by fixing the cell’s reference which contains that constant by adding the$’ symbol to the front of the column’s letter as well as the row’s number. This will allow you to secure the cell’s reference so that it will not change regardless of the location where you copy the formula.
In this case, we have created an absolute reference to a cell using a dollar ‘$’ symbol ahead of the column’s letter and row number in the cell B7 ($B$7) This ensures that the B8 value won’t change. We can now multiply the value of cell B7 by the value of cell B1.
Then, click on the handle for filling Cell C1 then drag it downwards to cell C5. The formula is now applied to all rows and C1 cell is multiplied by B1 cell to B5.
If the formula above isn’t easy to recall, then you can multiply a column using the Paste Special method in Excel.
You can now perform the same thing without formula. To do this, click right on cell B7 and then copy (or use CTRL + C).
Then, choose the range of cells B1:B5, then right-click and select “Paste Special’.
Choose ‘Multiply’ under the “Operations” and then press the OK button.
The value of B7 in the cell is multiplied by the number column (B1:B5). However, the original values of B1:B5 are replaced by the multiplied numbers.
Multiplying Excel using PRODUCT function. Excel by using the PRODUCT function
If you have to increase the number of columns with ranges or multiple cells in which case you must note each cell’s reference separately by the * operator. In the formula. The formula could become quite long. To reduce the length of your formula you can make use of the function PRODUCT.
For instance the PRODUCT formula found in cell B7 is used to multiply the value within the B1:B5 range then returns the result.
There are many ways to multiply using Excel. We hope this article helps you to multiply using Excel.