While working on an **excel **worksheet, you need to perform different kinds of 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.

**Table of Contents**hide

## Download Practice Workbook

Please download the workbook to practice yourself.

## 5 Effective Ways to Create a Multiplication Formula in Excel

Here, I will consider a dataset regarding **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.

### 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.

- 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.

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

**Read More:** **How to Create a Formula in Excel (5 Ways)**

### 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.

- Then enter the following formula in the selected cell.

`=C5*D5`

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

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

**Read More:** **How to Create a Formula in Excel for Multiple Cells (9 Methods)**

### 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.

- Copy the following formula in the selected cell then.

`=C5*D5`

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

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

**Read More:** **How to Create a Custom Formula in Excel (A Step-by-Step Guideline)**

**Similar Readings**

**How to Create a Formula in Excel without Using a Function (6 Approaches)****Create a Formula in Excel to Change Date by 1 Year (3 Methods)****How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)****How to Create a Formula in Excel for Multiple Sheets (4 Methods)**

### 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.

**Steps:**

- First, select the
**C15**cell.

- Then write down the following formula.

`=C13*C14`

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

- You will find the following result consequently.

**Read More:** **How to Create a Complex Formula in Excel (with Easy Steps)**

### 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.

- Meanwhile, copy the following formula in the selected cell.

`=PRODUCT(C5,D5)`

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

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

**Read More:** **How to Create a Nested Formula in Excel (3 Easy Examples)**

## How to Multiply a Cell by Percentage

Here, I will show the procedure of how to multiply a cell by **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 Create a Formula to Calculate 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.

**Read More:** **How to Apply Formula to Entire Column Without Dragging in Excel**

## 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.

## 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
**E****nter**.

- 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.

**Read More:**** How to Create Array Formula in Excel (10 Suitable Examples)**

## 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. You will find such interesting blogs on our website **Exceldemy.com**. 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**

**How to Create a Subtraction Formula in Excel (7 Quick Ways)****Create a Formula Using Defined Names in Excel (7 Ways)****How to Create a Formula with Structured References in Excel****Apply Formula to Entire Column Using Excel VBA****How to Create an Excel Formula to Subtract (10 Examples)****How to Create a Conditional Formula in Excel (5 Easy Ways)**