Difference between revisions of "Manuals/calci/PRODUCT"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
For Example, | For Example, | ||
| − | PRODUCT(34,99) ''returns ''. | + | PRODUCT(34,99) ''returns 3366''. |
| − | PRODUCT(0. | + | PRODUCT(0.1,5,-3) ''returns -1.6''. |
*Arguments can be numbers, logical values, text representations. | *Arguments can be numbers, logical values, text representations. | ||
| + | *Number arguments can be positive or negative. | ||
*Function should contain at least one argument, else Calci displays an error message. There can be any number of arguments. | *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. | *If arguments is an array or reference, only numbers are considered. | ||
*The arguments are ignored, if | *The arguments are ignored, if | ||
| − | + | # It is logical values, | |
| − | + | # It is empty cells, | |
| − | + | # It is text. | |
*PRODUCT() can also be used for an array of numbers as - | *PRODUCT() can also be used for an array of numbers as - | ||
| − | PRODUCT(1..10) ''returns ''. | + | PRODUCT(1..10) ''returns 3628800''. |
== Examples == | == Examples == | ||
Revision as of 16:56, 7 December 2013
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 3366.
PRODUCT(0.1,5,-3) returns -1.6.
- Arguments can be numbers, logical values, text representations.
- Number arguments can be positive or negative.
- 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
- It is logical values,
- It is empty cells,
- It is text.
- PRODUCT() can also be used for an array of numbers as -
PRODUCT(1..10) returns 3628800.
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 4 | ||
| Row2 | 13 | |||
| Row3 | 20 | |||
| Row4 | 2600 | |||
| Row5 | ||||
| Row6 |