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(Ai:Am;Bk:Bl) can be used which is equivalent to Ai*Ai+1*..*Am*Bk*Bk+1*...Bl.
- 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