# Documentation/Calc Functions/PRODUCT

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

- 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}).

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.

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
*N*,_{1}*N*, …,_{2}*N*represent a set of_{k}*k*real numbers passed to the function, the formula for PRODUCT is:

[math]\displaystyle{ \text{PRODUCT}(N_{1}; N_{2}; ...; N_{k})=N_{1}\times N_{2}\times ...\times N_{k} }[/math]

- 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.

## Examples:

Formula | Description | Returns |
---|---|---|

=PRODUCT(2; 3; 4) | Here the function calculates [math]\displaystyle{ 2\times3\times4 }[/math] and returns the result. | 24 |

=PRODUCT(A1:A3; B1:B2) where cells A1, A2, A3, B1, and B2 contain the numbers 2.2, 3, -5, 1.3, and -7 respectively. | Here the function calculates [math]\displaystyle{ 2.2\times3\times-5\times1.3\times-7 }[/math] and returns the result. | 300.3 |

=PRODUCT({2; 4; 6; 8}) | Here the function calculates [math]\displaystyle{ 2\times4\times6\times8 }[/math] and returns the result. | 384 |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

PRODUCT