How to Multiply in Excel Formula?

Multiply in Excel Formula (Table of Contents)

• How to Multiply in Excel Formula?
  1. Multiply Numbers
  2. Multiplying Rows
  3. Using PRODUCT Function
  4. Using SUMPRODUCT Function
  5. Multiplying Percentage

Multiply in Excel Formula

In specific, there is no multiply function in excel but you can perform the multiply operation using the asterisk symbol (*), PRODUCT function and SUMPRODUCT function to get the multiplication.

By using this formula, you can perform a specific set of calculations in a cell, column or row. The PRODUCT function performs only one type of calculation, so you can use the multiplication operator to perform a more complex multiplication in excel.

#1 – How to Multiply Numbers in Excel?

In this example, we perform the multiplication using the asterisk symbol (*). Let consider a data set containing the set of numbers in column 1 and 2 named under Number 1 and Number 2 column as shown in the below table.

Then apply the (*) formula to perform multiplication in columns

then you will get the output in Product column as shown in the below table.

#2 – How to Multiply Rows in Excel?

You can simply perform the multiplication operation in rows also by using the asterisk symbol (*). Let consider the below data set having data in the two rows as shown in the below table.

Apply the formula =G3*G4

To get the output in the product column.

#3 – How to Multiply Numbers Using Excel PRODUCT Formula?

In this example, we are using the Product formula in place of the asterisk symbol (*). You can give the list of numbers to product function to perform the multiplication.

Let consider the below data and apply the product formula =PRODUCT (A26, B26) on it.

And to get the output in the product column as shown in the below table.

#4 – How to Multiply & Sum in Excel Using SUMPRODUCT Formula?

If you want to multiply two columns or rows of numbers, and then wants to sum up the results of individual calculations then you can use the SUMPRODUCT formula to multiply cells and sum up products.

suppose you have prices and quantity data as shown in the below table, and you want to calculate the total value of sales. In this case, you must multiply each Price with Qty. pair individually and sum up the sub-totals.

But here we use SUMPRODUCT function =SUMPRODUCT (G15:G34,H15:H34)

To achieve this.

#5 – How to Multiply Percentages in Excel?

You can also perform the multiplication operation on percentage.

Here are a few examples as follows to multiple the percentage with the number.

Here we get the result in percentage with a number.

Things to Remember about Multiplication in Excel

• While there is no universal multiplication formula in Excel but you can perform the multiply operation using the asterisk symbol (*), PRODUCT formula and SUMPRODUCT formula.

Recommended Articles

This has been a guide to Multiply in Excel Formula. Here we discuss how to multiply numbers and rows in excel, multiplying percentages & usage of PRODUCT & SUMPRODUCT Function in excel.  You may learn more about excel from the following articles –

• Excel Count Rows
• Not Working in Excel Formula
• Formula Grade in Excel
• Percentage Difference in Excel (Increase / Decrease)
• SUMPRODUCT with Multiple Criteria Example
• Age in Excel
• Auto Numbering in Excel
• Percentage in Excel Formula