Math and Trignometric - PRODUCT Function

Description

The PRODUCT function multiplies all the numbers given as arguments and returns the product.

For example, if cells A1 and A2 contain numbers, to multiply those two numbers together, you can use the formula

= PRODUCT (A1, A2)

This is same as multiplying with the (*) mathematical operator. i.e.

= A1 * A2

The PRODUCT Function is useful when you need to multiply many cells together.

Example

= PRODUCT (A1:A3, C1:C3)

This is same as

= A1 * A2 * A3 * C1 * C2 * C3.

Syntax

PRODUCT (number1, [number2] ...)

Arguments

Argument	Description	Required/Optional
number1	The first number or range that you want to multiply.	Required
number2, ...	Additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments.	Optional

Notes

Numbers and Dates are always counted as numeric values by the Product Function. However, text and logical values are handled differently, depending on whether they are values stored in the cells of the Worksheet, or they are supplied directly to the function.
The table given below shows which values are included in the Product Function calculation, and which values are ignored or produce errors −

	Value Within a Range of Cells	Value Supplied Directly to Function
Numbers	Included	Included
Dates	Included	Included
Logical Values	Ignored	Included (True = 1; False = 0)
Text Representations of Numbers & Dates	Ignored	Included
Other Text	Ignored	#VALUE! Error
Errors	Error	Error

If any of the arguments that is supplied directly to the Product function cannot be interpreted as numeric value, Product Function returns #VALUE! Error.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_math_trigonometric_functions.htm