Difference between revisions of "Documentation/How Tos/Calc: PRODUCT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
(See also:)
Line 21: Line 21:
  
 
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
 
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 07:25, 13 September 2008


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

Functions listed alphabetically, Functions listed by category

Personal tools