Table of Contents
- How to Multiply in Excel Formula?
Multiply in Excel Formula
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 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.
You can download this Multiply template here – Multiply Function Excel Template
This has been a guide to Multiply in Excel Formula. Here we discuss how to multiply numbers and rows in excel, nultiplying percentages & usage of PRODUCT & SUMPRODUCT Function in excel. You may learn more about excel from the following articles –