PRODUCT

Excel Functions

Get the product of supplied numbers

Syntax

EXCEL

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

Arguments

Parameter	Description
`number1`	The first number or range to multiply.
`number2`	[optional] The second number or range to multiply.

Return Value

Product of supplied numbers

Details

The Excel PRODUCT function returns the product of numbers provided as arguments. Because it can accept a range of cells as an argument, PRODUCT is useful when multiplying many cells together The PRODUCT function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are multiplied together. Empty cells and text values are ignored. The PRODUCT function returns the product of supplied arguments: PRODUCT multiplies all numeric values together, so the following formulas are equivalent: PRODUCT ignores text values and empty cells. The formulas below will return the same result with all cells have numeric values:

Examples

The PRODUCT function returns the product of supplied arguments:

EXCEL

=PRODUCT(3,8) // returns 24
=PRODUCT(3,8,4) // returns 96

Examples

PRODUCT multiplies all numeric values together, so the following formulas are equivalent:

EXCEL

=PRODUCT(A1:A5)
=PRODUCT(A1,A2,A3,A4,A5)
=PRODUCT(A1:A2,A3:A5)

Examples

PRODUCT ignores text values and empty cells. The formulas below will return the same result with all cells have numeric values:

EXCEL

=PRODUCT(A1:A5)
=A1*A2*A3*A4*A5

PRODUCT

Syntax

Arguments

Return Value

Details

Examples

See Also