Difference between revisions of "Documentation/How Tos/Calc: PRODUCT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
|||
| Line 21: | Line 21: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
* [[Documentation/How_Tos/Calc: FACT function|FACT]] | * [[Documentation/How_Tos/Calc: FACT function|FACT]] | ||
| − | * [[Documentation/How_Tos/Calc: SUM function|SUM]] | + | * [[Documentation/How_Tos/Calc: SUM function|SUM]] |
| − | * [[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 alphabetically|Functions listed alphabetically]] | ||
Revision as of 14:33, 26 February 2009
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/arrays of numbers whose product is to be calculated.
- PRODUCT returns number1 * number2 * number3 * ........
- PRODUCT ignores any text or empty cell within a range or array.
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).
Template:Documentation/SeeAlso
Issues:
- In Excel PRODUCT ignores logical values (that is, it treats them as 1). In Calc TRUE is 1 and FALSE is 0.
