PRODUCT(n1,n2,n3...)
- where n1,n2,n3... are integer values.
PRODUCT() multiplies the given arguments and displays the product.
Description
PRODUCT(n1,n2,n3...)
For Example,
PRODUCT(34,99) returns .
PRODUCT(0.02,5,-3) returns .
- Arguments can be numbers, logical values, text representations.
- Function should contain at least one argument, else Calci displays an error message. There can be any number of arguments.
- If arguments is an array or reference, only numbers are considered.
- The arguments are ignored, if
1)It is logical values, 2)It is empty cells, 3)It is text.
- PRODUCT() can also be used for an array of numbers as -
PRODUCT(1..10) returns .
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 4 | ||
| Row2 | 13 | |||
| Row3 | 20 | |||
| Row4 | 2600 | |||
| Row5 | ||||
| Row6 |