PRODUCT Formula in Excel
In this tutorial, you will learn about a multiplication excel formula which is PRODUCT. PRODUCT formula in excel is useful to give multiplication results from all digit inputs that you give to it.
Why do We Need to Learn Multiplication Excel Formula?
Multiplication is a calculation process that is quite often used in processing numeric data in a spreadsheet. In its process, sometimes we want to multiply many numbers at once. In this condition, it will be troublesome if we need to write the process manually in our spreadsheet. This is because we have to input all the numeric data or the cell coordinates where they are one by one.
As the case example, imagine if we need to do prioritization to the projects that our company wants to do. The prioritization is done based on many factors where each of the factor scores for the projects has been quantified first. The quantification is done so the data can be easier to process in the spreadsheet. If we want to get a total assessment, then we need to multiply some or all of the quantification numbers. This is done to know which project should be prioritized and also the complete order of the project priorities.
This is difficult to do with the manual writing process because of the high amount of numbers to multiply. Besides, there might be a high project amount in which factors need to be calculated.
To do multiplication fast to a high amount of numeric data, then you can use the PRODUCT formula in excel. PRODUCT, a multiplication excel formula, will help you calculate fast by inputting numbers to be multiplied in it first. This multiplication excel formula is very useful when you often need to do an analysis process through multiplying in a spreadsheet.
What is PRODUCT Formula in Excel?
PRODUCT formula in excel is a function with the usage objective to get the multiplication result from more than one digits. Usually, all the digits that need to be multiplied by this multiplication excel formula are placed in a particular cell range.
General explanation about the inputs in it is as follows:
=PRODUCT(number1, number2, …)
Note:
number1, number2, … = all the numbers that you want to multiply
How to Use PRODUCT as a Multiplication Excel Formula?
The next part will explain how to write the PRODUCT formula in excel. This multiplication excel formula only needs the input of all numeric data or cell coordinates that are filled with them. They will then be multiplied by this function.
Using PRODUCT Formula in Excel

Type equal sign ( = ) in the cell where you want to put the process result

Type PRODUCT (can be with large and small letters) and open bracket sign after =

Input the numbers or cell coordinates or cell ranges where you put the numbers to be processed are. Place comma sign ( , ) in between them

Type close bracket sign after all numbers that you want to calculate have been inputted
 Press Enter

The calculation process of PRODUCT formula in excel is done!
Exercise
After you have learned the steps to use the multiplication excel formula, PRODUCT, above, now let’s do an exercise!
Download the exercise file from the link below and do all the instructions. Download the answer key file too to check your answer when you have done them. Or probably when you need a clue on how to finish the exercise!
Link for the exercise file:
Download here
Instructions
 Get the multiplication result from the content of cell A2 until C8!
 Get the multiplication result from the content of cell E5 until G9!
 Get the multiplication result from the content of cell H7 until J9!
Link of the answer key file:
Download here
Additional Notes

If there is text data in the cell range input of this function, then the process will ignore it

If there is date data in the cell range input of this function, then the process will multiply it too by calculating the date’s serial number

If there is error data in the cell range input of this formula, then the process will result in error
 Maybe you want to learn how to write multiplication manually (which is possibly good if the digits aren’t many). You can do it by visiting another part of this Compute Expert tutorial!