Difference between revisions of "Manuals/calci/PRODUCT"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
PRODUCT(0.1,5,-3) ''returns -1.6''. | PRODUCT(0.1,5,-3) ''returns -1.6''. | ||
| − | |||
*Number arguments can be positive or negative. | *Number arguments can be positive or negative. | ||
| − | *Function should contain at least one | + | *Function should contain at least one number (i.e n1) or range, 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 | ||
| Line 32: | Line 31: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | 4 |
| − | + | | class="sshl_f" | | |
| − | + | | class="sshl_f" | | |
| − | | class=" | + | |
| − | | class=" | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f " | 10 | | class="sshl_f " | 10 | ||
| class="sshl_f" | 4 | | class="sshl_f" | 4 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | 13 | | class="sshl_f" | 13 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f " | 20 | | class="sshl_f " | 20 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | 2600 | | class="sshl_f" | 2600 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
Revision as of 17:04, 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.
- Number arguments can be positive or negative.
- Function should contain at least one number (i.e n1) or range, 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
| 4 | ||
| 10 | 4 | |
| 13 | ||
| 20 | ||
| 2600 | ||