Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Multiplication Formula in Excel (6 Suitable Examples)

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.

Multiply Rows by Using Asterisk to Use Multiplication Formula in Excel

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.

Multiply Columns by Using Asterisk to Use Multiplication Formula in Excel

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.

Insert PRODUCT Function as Multiplication Formula in Excel

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.

Enter SUMPRODUCT Function as Multiplication Formula in Excel

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


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.

Multiply Column by a Constant Value in Excel

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.

Multiply Column by a Constant Value in Excel

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.

Multiplication of Values by Using Percentages in Excel

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.

Multiplication of Values by Using Percentages in Excel

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.

Apply Array Formula for Multiplication in Excel

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.

Apply Array Formula for Multiplication in Excel

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.

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

STEPS:

  • Firstly,  copy cell D5 by pressing the 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.

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

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

Nuraida Kashmin

Nuraida Kashmin

Hi Everyone! I am Nuraida. Cordially welcome you to my profile. I am a Team Leader of Excel and VBA Content Developer in ExcelDemy. Here I will also post articles related to Microsoft Excel. With a strong educational background in Mechanical Engineering through experimental learning from Rajshahi University of Engineering & Technology. Skilled in Microsoft Word, Creative Writing, Microsoft Excel, Project Management, Support to Organize Different Events, Reporting, Monitoring & Documentation, Online Advocacy and Event Management Related to SAP and Youth Leaders.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo