What is PRODUCT Function in Excel?
The PRODUCT function is one of the math functions of Excel.
It Multiplies all the numbers given as arguments.
We can find this function in Math & trig category of insert function Tab.
How to use PRODUCT function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select PRODUCT function
6. Then select ok
7. In the function arguments Tab you will see PRODUCT function
8. Number1:number2,… are 1 to 255 numbers, logical values, or text representations of numbers that you want to multiply
9. You will see results in the formula result section
Examples of PRODUCT function in Excel
Example 1:
How to use PRODUCT function in excel
You can see examples of PRODUCT function below:
product(A2,B2,C2) ----->>>>answer is 66.6
product(A3,B3,C3) ----->>>>answer is 33.5
product(A4,B4,C4) ----->>>>answer is -144
product(A5,B5,C5) ----->>>>answer is 45
product(A6,B6,C6) ----->>>>answer is -20.25
product(A7,B7,C7) ----->>>>answer is 200What is the purpose of PRODUCT function?
It Multiplies all the numbers given as arguments.
What is the Return value of PRODUCT function?
It returns a number.
How many arguments does PRODUCT function have?
This function has just 1 Argument.
The argument of PRODUCT function is number.
Number1,number2,… are 1 to 255 numbers, logical values, or text representations of numbers that you want to multiply.
The argument of PRODUCT function is required and not optional.
PRODUCT(number) = number
Which version of excel supports PRODUCT function?
This function is available for all excel versions (2003-2019)
