Documentation/How Tos/Calc: PRODUCT function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 18:15, 24 December 2007 by Drking (talk | contribs) (Initial content)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


PRODUCT

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


Syntax:

PRODUCT(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges of numbers whose product is to be calculated.
PRODUCT returns number1 * number2 * number3 * ........


Example:

PRODUCT(2; 3; 4)

returns 24 (2 * 3 * 4).

PRODUCT(A1:A2)

where A1 and A2 contain 3 and 5, returns 15 (3 * 5).


See also:

FACT, SUM

Mathematical functions

Personal tools