# Documentation/Calc Functions/PRODUCT

Jump to navigation
Jump to search

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

## Function name:

PRODUCT

## Category:

Mathematical

## Summary:

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

## Syntax:

PRODUCT(**Number 1** [; **Number 2** [; … [; **Number 255**]]])

## Returns:

Returns a real number which is the product of all the input arguments, i.e. **Number 1** * **Number 2** * **Number 3** * ...

## Arguments:

**Number 1**, **Number 2**, … , **Number 255** are numbers, references to cells or to cell ranges of numbers.

## Additional details:

- The cell referencing is useful when one wants to multiply disjoint set of cells in which case PRODUCT(A
_{i}:A_{m};B_{k}:B_{l}) can be used which is equivalent to A_{i}*A_{i+1}*..*A_{m}*B_{k}*B_{k+1}*...B_{l}.

- If a reference to the cell is passed and it doesn't contain a numeric value it will be ignored.

- If any of the arguments that are not referencing any cells and contain non-numeric value then the function returns a value(#VALUE!) error.

## Examples:

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

=PRODUCT(2;3;4) | 2*3*4 | 24 |

=PRODUCT(A1:A3;B1:B2) where A1, A2, A3 are 2.2,3,-5 and B1,B2 are 1.3, -7 | 2.2*3*-5*1.3*-7 | 300.3 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

PRODUCT