Multiplies all the numbers given as arguments and returns the product.
PRODUCT(Number 1 [; Number 2 [; … [; Number 255]]])
Returns a real number which is the product of all the input arguments, i.e. Number 1 * Number 2 * Number 3 * ...
Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.
- 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.
|=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:
Equivalent Excel functions: