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.
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
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.
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 –
- SUMIFS With Multiple Criteria
- Excel Count Rows
- Not Working in Excel Formula
- Formula Grade in Excel
- SUMPRODUCT with Multiple Criteria Example
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion
