## 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 200

## What is the purpose of **PRODUCT** function?

**PRODUCT**

It **Multiplies all the numbers **given as arguments.

## What is the Return value of **PRODUCT** function?

**PRODUCT**

It returns a number.

## How many arguments does **PRODUCT** function have?

**PRODUCT**

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?

**PRODUCT**

This function is available for all excel **versions **(2003-2019)

## Errors in **PRODUCT** function

**PRODUCT**