Excel PRODUCT Function

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

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select PRODUCT function

6. Then select ok

excel PRODUCT function

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

How to use PRODUCT function in excel

Examples of PRODUCT function in Excel

Example 1:

How to use PRODUCT function in excel

You can see examples of PRODUCT function below:

Examples of PRODUCT function in Excel
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  200

What 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)

Errors in PRODUCT function

PRODUCT related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *