# What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)

This article will show you the formula of multiplication in Excel for multiple cells in 3 simple ways.

## 3 Easy Formula for Multiplication in Excel for Multiple Cells

Here you will learn the formula of multiplication in Excel for multiple cells by using the Asterisk (*) symbol, by using the PRODUCT function and how to multiply a range of cells with a constant value.

### 1. Multiplication of Multiple Cells with Asterisk (*)

Using Asterisk (*) symbol to do multiplication is the most common and easy way to multiply values in computerized documentation. Here we will learn how to do that in Excel.

Step 1: Select an empty cell where you want your result to appear. In our case, we have chosen cell G7.

Step 2: In that cell, first write the equal (=) sign and then select the first cell of the range of cells that you want to multiply.

Step 3: Then put the Asterisk (*) symbol after this.

Step 4: Next select the other cell that you want to multiply with it.

Step 5: And then put the Asterisk (*) symbol after it once again.

Step 6: Keep doing it until you have finished selecting all of the cells for the multiplication.

Step 7: Now hit Enter on your keyboard.

It will produce the result of the multiplication of the cells that you selected.

Step 8: Later, just drag the row or column with the Fill Handle to apply the same formula to the rest of the range of cells.

There you have the result of the multiplication of a range of multiple cells.

### 2. Multiplication of Multiple Cells with PRODUCT Function

Excel offers another way to multiply multiple cells using the PRODUCT function. The steps to do that are given below.

Step 1: Select an empty cell where you want your result to appear. In our case, we have chosen cell G7.

Step 2: In that cell, first write the equal (=) sign and PRODUCT function along with it.

Step 3: To input values inside the brackets of the PRODUCT function, place the pointer of your mouse on the first cell of the range of cells that you want to multiply and drag it through the whole row or column.

It will give you an address of the cells (e.g. C7:E7) from the start to the end.

Step 4: Close the bracket and hit Enter.

There you have the result of the multiplication of a range of multiple cells.

You can also do this by simply putting a comma after each cell written inside the bracket and by selecting the cells or writing down the cell references (e.g. C8,D8,E8).

Next hit Enter. As you can see in the following picture, both of the ways produce the same results.

You can also utilize both of the above formulas in the multiplication of non-adjacent multiple cells.

To do that just select or write the cell reference number after every Asterisk (*) symbol or inside the bracket of the PRODUCT function (see the following pictures) and hit Enter.

fig.: Multiplication of multiple non-adjacent cells using Asterisk (*)

fig.: Multiplication of multiple non-adjacent cells using PRODUCT function

### 3. Multiplication of Multiple Cells of Range with a Constant Value

What if you want to multiply a set of multiple cells with just one constant value? Letâ€™s find out how to do that here.

Step 1: Store the constant value in an empty cell. In our case, we have chosen cell G6.

Step 2: Write the equal (=) sign in an empty cell where you want your result to appear. In our case, we have chosen cell I7.

Step 3: Select the cell that you want to multiply with. In our case, we have chosen cell E7.

Step 4: Write Asterisk (*) after it.

Step 5: Then write the cell reference of the constant value and be sure to put the \$ symbol before the letter and the number of the cell reference.

Step 6: Hit Enter. You will get the result of multiplying one cell with a constant value.

Step 7: Now drag the row or column to apply the formula to the range of cells.

There you have the result of the multiplication of a range of multiple cells with a constant value.

## Conclusion

In this article, we have discussed 3 easy formulas for multiplication in Excel for multiple cells by using Asterisk (*), PRODUCT function and multiplying with a constant value. We have also discussed how to multiply non-adjacent multiple cells in Excel.