PRODUCT function

Multiplies all the numbers given as arguments and returns the product.

Syntax

PRODUCT(number1,number2,...)

Number1, number2,...     are 1 to 30 numbers that you want to multiply.

Remarks

• Arguments that are numbers, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers cause errors.

• If an argument is a column reference, only numbers are counted. Empty arguments, logical values, text, or error values are ignored.

Examples

Col1	Col2	Col3	Formula	Description (Result)
5	15	30	=PRODUCT([Col1], [Col2], [Col3])	Multiplies the numbers (2250)
5	15	30	=PRODUCT([Col1], [Col2], [Col3],2)	Multiplies the numbers and 2 (4500)