**Excel formulas** are made for us to calculate problems easily. But there is no fixed multiplication formula in Excel. Today we are going to see some methods of multiplying data in Excel.

## Download Practice Workbook

Download the following workbook and exercise.

## 6 Examples of Multiplication Formula in Excel

### 1. Use Asterisk (*) Symbol for Algebraic Multiplication Formula in Excel

This asterisk (*) operator is known as a multiplication symbol in Excel.

#### i. Multiply Rows by Using Asterisk

Here we have a dataset of some random numbers in two different rows. We have to **multiply rows** and display the result in another cell.

**STEPS:**

- Firstly, select
**Cell**.*C6* - Secondly, put an equal (=) sign.
- Thirdly, write down the following formula.

`=C4*C5`

- Then, press
**Enter**and use the**Fill Handle**to drag rightward to the remaining cells to see the result.

#### ii. Multiply Columns by Using Asterisk

Now we have a dataset of two columns of random numbers. We have to **multiply columns** alongside and display the results in the Product column.

**STEPS:**

- Firstly, choose
**Cell**.*D5* - Then, Put an equal (=) sign.
- After that, write down the following formula.

`=B5*C5`

- And, press
**Enter**and drag down to the remaining cells to see the results.

**Read More: How to Multiply from Different Sheets in Excel (5 Methods)**

### 2. Insert PRODUCT Function as Multiplication Formula

To multiply several cells together, we can use **the PRODUCT Function**. For the dataset below, we are going to find out how this function works out.

**STEPS:**

- Firstly, select
**Cell**.*D5* - Secondly, enter the following formula.

`=PRODUCT(B5,C5)`

- Afterward, hit
**Enter**and drag down the**Fill Handle**icon to see the results.

**Read More: ****How to Make Multiplication Table in Excel (4 Methods)**

### 3. Enter SUMPRODUCT Function to Multiply in Excel

To multiply the sets of cells or arrays and return their sum of products, we can use **the SUMPRODUCT function**. Here we have a worksheet containing the employee’s working hours per week. We are going to find out the total working hours per week of all the employees.

**STEPS:**

- Now, select
**Cell**.*C10* - Then, Write the formula here.

`=SUMPRODUCT(C5:C9,D5:D9)`

- After that, press
**Enter**to see the outputs.

**Read More: How to Multiply in Excel (8 Simple Methods)**

**Similar Readings**

**How to Multiply Two Columns and Then Sum in Excel (3 Examples)****If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)****How to Divide and Multiply in One Excel Formula (4 Ways)****Use Multiply Sign in Excel (With 3 Alternative Methods)****How to Multiply Matrices in Excel (2 Easy Methods)**

### 4. Multiply Column by a Constant Value in Excel

Let’s say we have a Salary worksheet. Here we are going to find out the total salary of each for three months by multiplying the salary range with the constant value **3**.

**STEPS:**

- Firstly, choose
**Cell D5**. - Secondly, type the formula here.

`=B5*$C$5`

- Here we have to use the ‘
**$’**sign by pressing the**F4**key for the cell reference to make it absolute or constant. - Now, hit
**Enter**and drag down the cursor. - Therefore, the final result is displayed.

**Read More: How to Multiply Two Columns in Excel (5 Easiest Methods)**

### 5. Multiplication of Values by Using Percentages in Excel

Here is a salary sheet of the employees with their salaries and the percentages they’ll receive. Now we are going to count the extra amount by multiplying all salaries by the percentage values.

**STEPS:**

- Here, select
**Cell E5**. - Then, write the following formula.

`=C5*D5`

- After pressing
**Enter**, drag down the cursor to see the results for the remaining cells.

**Read More: How to Multiply by Percentage in Excel (4 Easy Ways)**

### 6. Apply Array Formula for Multiplication in Excel

To perform dynamic calculations for multiple sets of data, we use **Array Formulas**. Here we have a worksheet containing the employee’s working hours per week. We are going to find out who worked for a maximum of hours per week among all the employees. Also for the minimum.

**STEPS:**

- Firstly, select
**Cell C10**. - Secondly, write down the following formula.

`=MAX(C5:C9*D5:D9)`

- After that, hit
**Enter**. - Now, select
**Cell C11**. - Then, write the formula here.

`=MIN(C5:C9*D5:D9)`

- So, hit
**Ctrl+Shift+Enter**(if you are not an**office 365**user) or simply**Enter**(if you are an**office 365**user). - Finally, we can see the results.

**Read More: How to Do Matrix Multiplication in Excel (5 Examples)**

## An Alternative to Excel Multiplication Formula: Multiply Operation of Paste Special Feature

**Paste Special **is another multiplying way in Excel. Here I have some salary data in **column B**. We multiply them with the value of month 3 from **Cell D5**.

**STEPS:**

- Firstly, copy cell
by pressing the*D5***Ctrl+C.** - Secondly, select the cells we wanted to multiply by the value of cell
.*D5*

- Then
**, right-click**the mouse on the area we pointed to and go for**Paste Special**.

- After that, a dialogue box will appear to you.
- Therefore, from the
**Operation**part, choose**Multiply**and press**OK**.

- Now, we can see that all the selected cells are multiplied by the value of
**Cell**.*D5*

**Read More: How to Multiply Multiple Cells in Excel (4 Methods)**

## Conclusion

By using these methods, we can easily multiply values in Excel. There is a practice workbook added. Go ahead and give it a try. Feel free to ask anything or suggest any new methods.

## Related Articles

**How to Multiply One Cell by Multiple Cells in Excel (4 Ways)****Multiply a Column by a Number in Excel (3 Easy Methods)****How to Multiply Two Columns and Then Sum in Excel (3 Examples)****What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)****How to Round a Multiplication Formula in Excel (5 Easy Methods)**