PRODUCT function in Excel, syntax, usage

The PRODUCT function in Excel supports multiplying multiple numbers quickly, helping to save time in data calculation. Let's join TipsMake to understand the syntax, usage and application cases to optimize work performance.

Instructions for using the PRODUCT function in Excel

Syntax: = PRODUCT (number 1, number 2, …)

Function: Used to calculate the product of numbers number 1, number 2, …

In which:
- number 1, number 2, …, number n . n can be up to 255. (For Excel 2003, n can only be up to 30).
- If the numbers are in a data array, only values ​​with numbers are counted, other values ​​with numbers will be ignored.

Example 1 : - Calculate the product of numbers 2, 3, 4.

Calculation formula: = PRODUCT (2, 3, 4) = 24.
- Calculate the product of the numbers 3, 5, 0.

Calculation formula: = PRODUCT (3, 5, 0) = 0.

Example 2 : Calculate the product of each column in the following data table:

PRODUCT function in Excel, syntax, usage Picture 1

To calculate the product of the results in column Demo 1, we use the PRODUCT function with the formula: D6=PRODUCT(C6:C10)

Example 3 : Calculate employee's net salary with given daily salary and working day value

PRODUCT function in Excel, syntax, usage Picture 2

Method 1: You can use a simple formula to calculate the actual salary column using the formula E5=C5*D5

PRODUCT function in Excel, syntax, usage Picture 3

Method 2: We use the PRODUCT function , this method is very effective if you have to calculate with many different fields.

With the formula E5=PRODUCT(C5,D5)

PRODUCT function in Excel, syntax, usage Picture 4

- Double-click on the lower right corner of cell E5 to copy the formula down to the remaining cells.

The PRODUCT function in Excel helps multiply multiple numbers at once, similar to multiplication using the * sign. Instead of entering each number and adding the * sign, you can simply use this function to calculate the product of a series of numbers, saving time.

Isabella Humphrey

Update 20 February 2025