Documentation/Calc Functions/PRODUCT

From The Document Foundation Wiki
Jump to: navigation, search

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 of multiple 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 cell doesn't contain a numeric value it will be ignored.

Examples:

=PRODUCT(2;3;4) returns 24.

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:

SUM

ODF standard:

Section 6.16.47, part2

Equivalent Excel functions:

PRODUCT