Multiply in Excel Formula | How to Perform Multiplication in Excel?

Multiply in Excel Formula (with Examples)

In specific, there is no Excel function 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.

You can download this Multiply Function Excel Template here – Multiply Function Excel Template

Example #1 – 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

Popular Course in this category

All in One Excel VBA Bundle (35 Courses with Projects)4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

View Course

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

Example #2 – 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.

Example #3 – 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.

Example #4 – Multiply & Sum Using Excel SUMPRODUCT Function

If you want to multiply two columns or rows of numbers, and then want 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.

Example #5 – 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

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.