How to Create a Multiplication Formula in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working on an Excel worksheet, you must perform different operations. One of these operations is Multiplication. There are different ways to multiply two numbers or cells in Excel. Every procedure is very easy. In this article, I will show you how to create a multiplication formula in Excel. I will show five easy ways to make a multiplication formula in Excel.


How to Create a Multiplication Formula in Excel: 5 Effective Ways

Here, I will consider a dataset regarding the Sales Statement ABC Traders. The dataset has four columns, B, C, D, and E called Product, Unit Price, Unit, and Total Price. The dataset ranges from B4 to E10. using this dataset, I will show you the step-by-step procedure of creating a multiplication formula in Excel. For your convenience, I have added the necessary images with every step of every method.

Dataset of how to create multiplication formula in excel


1. Multiply Numbers to Create a Multiplication Formula in Excel

This is the first method, here, I will multiply numbers to create a multiplication formula in excel. Follow the steps given below. Hopefully, you will understand the whole procedure easily.

Steps:

  • First, select the E5 cell of the dataset.

Multiply Numbers of how to Create a Multiplication Formula in Excel

  • Then write down the following formula in the selected cell.
=5*1000

Here, 5 is the unit value and 1000 is the unit price value.

Multiply Numbers of how to Create a Multiplication Formula in Excel

  • After that, for every cell multiply the unit value by the unit price value.
  • Consequently, you will find the following results.

Multiply Numbers of how to Create a Multiplication Formula in Excel

Read More: How to Multiply Two Columns in Excel


2. Use Multiplication of Cells to Create a Multiplication Formula in Excel

This is the second method. Here, in this method, I will use the multiplication of cells to create a multiplication formula in Excel. Follow the following steps of the procedure. Hope you will understand the method easily.

Steps:

  • Select the E5 cell first.

Use Multiplication of Cells of how to Create a Multiplication Formula in Excel

  • Then enter the following formula in the selected cell.
=C5*D5

Use Multiplication of Cells of how to Create a Multiplication Formula in Excel

  • After pressing enter, Fill Handle the formula from E5 to E10 cell.

Use Multiplication of Cells of how to Create a Multiplication Formula in Excel

  • As a result, you will get the total price of the products.

Use Multiplication of Cells of how to Create a Multiplication Formula in Excel

Read More: How to Multiply Multiple Cells in Excel


3. Multiply One Column by Another to Create a Multiplication Formula in Excel

Here is the third method of this article. I will multiply one column by another to create a multiplication formula in Excel. Hopefully, you will understand the whole procedure easily. Follow the steps one by one.

Steps:

  • First, select the E5 cell of the dataset.

Multiply One Column by Another of how to Create a Multiplication Formula in Excel

  • Copy the following formula in the selected cell then.
=C5*D5

Multiply One Column by Another of how to Create a Multiplication Formula in Excel

  • After pressing enter, drag down the formula from E5 to E10.

Multiply One Column by Another of how to Create a Multiplication Formula in Excel

  • Consequently, you will find the result just like the picture below.

Multiply One Column by Another of how to Create a Multiplication Formula in Excel


4. Creating a Multiplication Formula in Excel by Multiplying Two Rows

This is the fourth method of this article. Here I have transposed the dataset for operation as I need to multiply two rows. You can see the changed area indicated with a red rectangle. Consider this dataset only for this method. Follow the steps mentioned below.

Creating a Multiplication Formula in Excel by Multiplying Two Rows

Steps:

  • First, select the C15 cell.

Creating a Multiplication Formula in Excel by Multiplying Two Rows

  • Then write down the following formula.
=C13*C14

Creating a Multiplication Formula in Excel by Multiplying Two Rows

  • Then press Enter.
  • After that, fill handle the formula from C15 to E15.

Creating a Multiplication Formula in Excel by Multiplying Two Rows

  • You will find the following result consequently.

Creating a Multiplication Formula in Excel by Multiplying Two Rows

Read More: How to Multiply Rows in Excel


5. Use of PRODUCT Formula to Create a Multiplication Formula in Excel

This is the final method of this article. I will use the PRODUCT formula here. Please follow the steps described below. Hopefully, you will find interest in the procedure.

Steps:

  • Firstly, select the E5 cell.

Use of PRODUCT Formula of how to Create a Multiplication Formula in Excel

  • Meanwhile, copy the following formula in the selected cell.
=PRODUCT(C5,D5)

Use of PRODUCT Formula of how to Create a Multiplication Formula in Excel

  • Then press Enter.
  • After that, drag down the formula from E5 to E10 cells.

Use of PRODUCT Formula of how to Create a Multiplication Formula in Excel

  • Consequently, you will find the result just like the picture given below.

Use of PRODUCT Formula of how to Create a Multiplication Formula in Excel


How to Multiply a Cell by Percentage

Here, I will show how to multiply a cell by a percentage. For this part, I have changed the dataset slightly. You can see the changed dataset in the following picture. I will calculate the discounted amount here. Follow the described steps one by one.

Steps:

  • First, select the E5 cell and copy the following formula.
=C5*D5

  • Press the enter button and drag down the formula from E5 to E10 cells.
  • As a result, you will find the following discounted amount.

Read More: How to Multiply by Percentage in Excel


Multiplying a Column by Number

In this portion of this article, I will multiply a column by a number. This is a very easy procedure. Follow the following steps here.

Steps:

  • First, select the E5 cell and write down the following formula.
=5*C5

  • After dragging down the formula, you will get the following result.


How to Multiply and Sum in Excel

Here I will show the procedures of multiplication and summation in Excel. I will consider the same dataset here. Follow the procedure step by step.

Steps:

  • Write down the following formula in the E5 cell first.
=C5*D5

  • After dragging down the formula you will get the following result.

  • Then, in the E11 cell, copy the following formula.
=SUM(E5:E10)

  • As a result, you will find the total price just like the next picture.

Read More: How to Multiply Two Columns and Then Sum in Excel


Multiplication in Array Formulas

Here, I will show multiplication in Array Formulas. I will use the MAX formula here. I will use the same dataset here. Follow the steps given below.

Steps:

  • Select the E12 cell and copy the following formula.
=MAX(C5:C10)
  • Then press Enter.

  • After that, write down the following formula in the E13 cell.
=MAX(D5:D10*C5:C10)
  • Meanwhile, press the Ctrl+Shift+Enter at a time.

  • As a result, you will find the result just like the following picture.

Download Practice Workbook

Please download the workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to create a multiplication formula in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles


<< Go Back to Multiply in Excel | Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo