Documentation/Calc Functions/PRODUCT

Function name:
PRODUCT

Category:
Mathematical

Summary:
Calculates the product of a set of real numbers by multiplying them.

Syntax:
PRODUCT(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a real number that is the result of multiplying together the specified numbers.

Arguments:
Number 1, Number 2, …, Number 255 give the set of real numbers for which the product is to be calculated. Each argument may take one of the following forms:

Note that although PRODUCT can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.
 * A real number, or an expression that evaluates to a real number.
 * A reference to a single cell containing a real number.
 * A simple reference to a cell range containing real numbers (for example, A1:B9).
 * The name of a named range, comprising cells containing real numbers.
 * The name of a database range, comprising cells containing real numbers.
 * An inline array of real numbers (for example, {1.1, 2.2, 3.3, 4.4}).

The following conditions (including errors) may be encountered:
 * If any argument is a string in quotation marks, then PRODUCT reports a #VALUE! error.
 * Text and empty cells within a data range are ignored.
 * If there are no supplied numbers, or any supplied value is equal to 0, then PRODUCT returns the value 0.
 * If only one value is supplied, then PRODUCT returns that value.

Additional details:

 * If N1, N2, …, Nk represent a set of k real numbers passed to the function, the formula for PRODUCT is:

$$\text{PRODUCT}(N_{1}; N_{2}; ...; N_{k})=N_{1}\times N_{2}\times ...\times N_{k}$$


 * PRODUCT ignores any text or empty cells within a data range. If you suspect wrong results, look for text within the supplied data range(s). To highlight text content within a data range, use Calc's feature.

Related LibreOffice functions:
IMPRODUCT

SUM

ODF standard:
Section 6.16.47, part 2

Equivalent Excel functions:
PRODUCT