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

We will consider a dataset that has four columns, B, C, D, and E called Product, Unit Price, Unit, and Total Price.

### Method 1 – Multiply Numbers to Create a Multiplication Formula in Excel

Steps:

• Select the E5 cell of the dataset.

• Insert the following formula in the selected cell.
`=5*1000`

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

• For every cell, multiply the unit value by the unit price value.

Read More: How to Multiply Two Columns in Excel

### Method 2 – Use Multiplication of Cells to Create a Multiplication Formula in Excel

Steps:

• Select the E5 cell.

• Enter the following formula in the selected cell.
`=C5*D5`

• Drag the Fill Handle of the formula from E5 to E10.

• You will get the total price of the products.

Read More: How to Multiply Multiple Cells in Excel

### Method 3 – Multiply One Column by Another to Create a Multiplication Formula in Excel

Steps:

• Select the E5 cell of the dataset.

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

• Drag down the formula from E5 to E10.

• You will find the result just like the picture below.

### Method 4 – Creating a Multiplication Formula in Excel by Multiplying Two Rows

We have transposed the dataset for operation as we need to multiply two rows.

Steps:

• Select the C15 cell.

• Insert the following formula.
`=C13*C14`

• Press Enter.
• Drag the formula from C15 to E15.

• You will find the following result.

Read More: How to Multiply Rows in Excel

### Method 5 – Use of the PRODUCT Formula to Create a Multiplication Formula in Excel

Steps:

• Select the E5 cell.

• Copy the following formula in the selected cell.
`=PRODUCT(C5,D5)`

• Press Enter.
• Drag down the formula from E5 to E10 cells.

• You will find the result just like the picture given below.

## How to Multiply a Cell by a Percentage

We have changed the dataset slightly. We will calculate the discounted amounts.

Steps:

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

Read More: How to Multiply by Percentage in Excel

## Multiplying a Column by Number

Steps:

• 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

Steps:

• Enter the following formula in the E5 cell first.
`=C5*D5`

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

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

• You will find the total price just like the next picture.

## Multiplication in Array Formulas

We will use the same dataset here.

Steps:

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

• Use the following formula in the E13 cell.
`=MAX(D5:D10*C5:C10)`
• Press Ctrl + Shift + Enter.

• You will find the result just like the following picture.

## Related Articles

<< Go Back to Multiply in Excel

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF