Nuraida Kashmin
Excel formulas are made for us to calculate problems easily. But there is no fixed multiplication formula in Excel. Today we are going to see some methods of multiplying data in Excel.
Download Practice Workbook
Download the following workbook and exercise.
6 Examples of Multiplication Formula in Excel
1. Use Asterisk (*) Symbol for Algebraic Multiplication Formula in Excel
This asterisk (*) operator is known as a multiplication symbol in Excel.
i. Multiply Rows by Using Asterisk
Here we have a dataset of some random numbers in two different rows. We have to multiply rows and display the result in another cell.
STEPS:
- Firstly, select Cell C6.
- Secondly, put an equal (=) sign.
- Thirdly, write down the following formula.
=C4*C5
- Then, press Enter and use the Fill Handle to drag rightward to the remaining cells to see the result.
ii. Multiply Columns by Using Asterisk
Now we have a dataset of two columns of random numbers. We have to multiply columns alongside and display the results in the Product column.
STEPS:
- Firstly, choose Cell D5.
- Then, Put an equal (=) sign.
- After that, write down the following formula.
=B5*C5
- And, press Enter and drag down to the remaining cells to see the results.
Read More: How to Multiply from Different Sheets in Excel (5 Methods)
2. Insert PRODUCT Function as Multiplication Formula
To multiply several cells together, we can use the PRODUCT Function. For the dataset below, we are going to find out how this function works out.
STEPS:
- Firstly, select Cell D5.
- Secondly, enter the following formula.
=PRODUCT(B5,C5)
- Afterward, hit Enter and drag down the Fill Handle icon to see the results.
Read More: How to Make Multiplication Table in Excel (4 Methods)
3. Enter SUMPRODUCT Function to Multiply in Excel
To multiply the sets of cells or arrays and return their sum of products, we can use the SUMPRODUCT function. Here we have a worksheet containing the employee’s working hours per week. We are going to find out the total working hours per week of all the employees.
STEPS:
- Now, select Cell C10.
- Then, Write the formula here.
=SUMPRODUCT(C5:C9,D5:D9)
- After that, press Enter to see the outputs.
Read More: How to Multiply in Excel (8 Simple Methods)
Similar Readings
- How to Multiply Two Columns and Then Sum in Excel (3 Examples)
- If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)
- How to Divide and Multiply in One Excel Formula (4 Ways)
- Use Multiply Sign in Excel (With 3 Alternative Methods)
- How to Multiply Matrices in Excel (2 Easy Methods)
4. Multiply Column by a Constant Value in Excel
Let’s say we have a Salary worksheet. Here we are going to find out the total salary of each for three months by multiplying the salary range with the constant value 3.
STEPS:
- Firstly, choose Cell D5.
- Secondly, type the formula here.
=B5*$C$5
- Here we have to use the ‘$’ sign by pressing the F4 key for the cell reference to make it absolute or constant.
- Now, hit Enter and drag down the cursor.
- Therefore, the final result is displayed.
Read More: How to Multiply Two Columns in Excel (5 Easiest Methods)
5. Multiplication of Values by Using Percentages in Excel
Here is a salary sheet of the employees with their salaries and the percentages they’ll receive. Now we are going to count the extra amount by multiplying all salaries by the percentage values.
STEPS:
- Here, select Cell E5.
- Then, write the following formula.
=C5*D5
- After pressing Enter, drag down the cursor to see the results for the remaining cells.
Read More: How to Multiply by Percentage in Excel (4 Easy Ways)
6. Apply Array Formula for Multiplication in Excel
To perform dynamic calculations for multiple sets of data, we use Array Formulas. Here we have a worksheet containing the employee’s working hours per week. We are going to find out who worked for a maximum of hours per week among all the employees. Also for the minimum.
STEPS:
- Firstly, select Cell C10.
- Secondly, write down the following formula.
=MAX(C5:C9*D5:D9)
- After that, hit Enter.
- Now, select Cell C11.
- Then, write the formula here.
=MIN(C5:C9*D5:D9)
- So, hit Ctrl+Shift+Enter (if you are not an office 365 user) or simply Enter (if you are an office 365 user).
- Finally, we can see the results.
Read More: How to Do Matrix Multiplication in Excel (5 Examples)
An Alternative to Excel Multiplication Formula: Multiply Operation of Paste Special Feature
Paste Special is another multiplying way in Excel. Here I have some salary data in column B. We multiply them with the value of month 3 from Cell D5.
STEPS:
- Firstly, copy cell D5 by pressing the Ctrl+C.
- Secondly, select the cells we wanted to multiply by the value of cell D5.
- Then, right-click the mouse on the area we pointed to and go for Paste Special.
- After that, a dialogue box will appear to you.
- Therefore, from the Operation part, choose Multiply and press OK.
- Now, we can see that all the selected cells are multiplied by the value of Cell D5.
Read More: How to Multiply Multiple Cells in Excel (4 Methods)
Conclusion
By using these methods, we can easily multiply values in Excel. There is a practice workbook added. Go ahead and give it a try. Feel free to ask anything or suggest any new methods.
Related Articles
- How to Multiply One Cell by Multiple Cells in Excel (4 Ways)
- Multiply a Column by a Number in Excel (3 Easy Methods)
- How to Multiply Two Columns and Then Sum in Excel (3 Examples)
- What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)
- How to Round a Multiplication Formula in Excel (5 Easy Methods)
