PRODUCT Formula in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> 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

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

    PRODUCT Formula in Excel - Screenshot of Step 1

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

    PRODUCT Formula in Excel - Screenshot of Step 2

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

    PRODUCT Formula in Excel - Screenshot of Step 3

  4. Type close bracket sign after all numbers that you want to calculate have been inputted

    PRODUCT Formula in Excel - Screenshot of Step 4

  5. Press Enter
  6. The calculation process of PRODUCT formula in excel is done!

    PRODUCT Formula in Excel - Screenshot of Step 6



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

  1. Get the multiplication result from the content of cell A2 until C8!
  2. Get the multiplication result from the content of cell E5 until G9!
  3. 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

    PRODUCT Formula in Excel - Screenshot of Additional Notes 1-1

    PRODUCT Formula in Excel - Screenshot of Additional Notes 1-2

  • 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

    PRODUCT Formula in Excel - Screenshot of Additional Notes 2-1

    PRODUCT Formula in Excel - Screenshot of Additional Notes 2-2

  • If there is error data in the cell range input of this formula, then the process will result in error

    PRODUCT Formula in Excel - Screenshot of Additional Notes 3-1

    PRODUCT Formula in Excel - Screenshot of Additional Notes 3-2

  • 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!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert