PRODUCT function

The PRODUCT function in Excel is used to multiply all the numbers provided as arguments and return the result. It can handle multiple numbers or ranges and is commonly used for calculations involving multiplication.

Syntax

=PRODUCT(number1, [number2], ...)

• number1: The first number or range of numbers to multiply.
• number2, …: Optional additional numbers or ranges to multiply. You can input up to 255 numbers or ranges.

Description

• The PRODUCT function multiplies the values together. It can accept individual numbers, cell references, or ranges of cells.
• If any of the arguments is non-numeric, Excel will treat it as 0, which will result in the product being 0.
• If no arguments are provided, the function will return 1, as the multiplication identity is 1.

Example 1: Multiply Numbers

To multiply 2, 3, and 4:

=PRODUCT(2, 3, 4)

Result:

The result is 24, since $2 \times 3 \times 4 = 24$.

Example 2: Multiply Numbers in a Range

To multiply the numbers in cells A1, A2, and A3:

=PRODUCT(A1:A3)

Result:

The result is the product of the numbers in cells A1, A2, and A3.

Example 3: Multiply a Number and a Range

To multiply the number 5 by the values in cells B1 to B5:

=PRODUCT(5, B1:B5)

Result:

The result is 5 multiplied by the product of the numbers in cells B1 to B5.

Example 4: Handling Non-Numeric Values

If a non-numeric value (such as text or a blank cell) is included in the range, PRODUCT treats it as 0, and the result will be 0.

=PRODUCT(2, "text", 3)

Result:

The result is 0, since “text” is non-numeric, and the multiplication is treated as $2 \times 0 \times 3 = 0$.

Usage Notes

• PRODUCT can handle multiple arguments, making it flexible for complex calculations.
• It’s a good alternative when working with large datasets or ranges instead of typing out individual multiplication operations.
• It works with both positive and negative numbers, and fractional values.