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.

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.

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

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

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

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

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

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

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

• In the E11 cell, copy the following formula.

• 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

We will use the same dataset here.

Steps:

• Select the E12 cell and copy the following formula.

• Press Enter.

• Use the following formula in the E13 cell.

• Press Ctrl + Shift + Enter.

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

Download the Practice Workbook

Related Articles

• How to Divide and Multiply in One Excel Formula
• How to Do Matrix Multiplication in Excel
• How to Multiply from Different Sheets in Excel
• How to Make Multiplication Table in Excel
• If Cell Contains Value Then Multiply Using Excel Formula

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