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)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×