Difference between revisions of "Manuals/calci/PRODUCT"
Jump to navigation
Jump to search
| (7 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =PRODUCT( | + | <div style="font-size:30px">'''PRODUCT()'''</div><br/> |
| − | * | + | *Parameter are any integer values. |
| − | + | **PRODUCT(), Multiplies its arguments. | |
| − | PRODUCT() | ||
== Description == | == Description == | ||
| − | PRODUCT( | + | PRODUCT() |
For Example, | For Example, | ||
| Line 13: | Line 12: | ||
PRODUCT(34,99) ''returns 3366''. | PRODUCT(34,99) ''returns 3366''. | ||
| − | PRODUCT(0.1,5,-3) ''returns -1. | + | PRODUCT(0.1,5,-3) ''returns -1.5''. |
| − | |||
*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. <math>n1</math>) or range, else Calci displays an error message. There can be any number of arguments. |
| − | *If arguments is an array or reference, | + | *If logical values, empty cells or text are entered directly as a part of argument, they are ignored. |
| − | + | *If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored. | |
| − | + | *Logical values are evaluated as TRUE=1, FALSE=0. | |
| − | |||
| − | |||
*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 3628800''. | PRODUCT(1..10) ''returns 3628800''. | ||
| Line 32: | Line 28: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" | 0.44 |
| − | + | | class="sshl_f" | -5 | |
| − | + | | 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" | TEXT |
| − | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | FALSE | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| + | |||
| + | =PRODUCT(A1:A4) : Calculates the product of values in the range A1 to A4. Returns ''1144'' as a result. | ||
| + | =PRODUCT(10,A5) : Calculates the product of 10 and reference A5 (value 0 for FALSE). Returns ''0'' as a result. | ||
| + | =PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result. | ||
| + | =PRODUCT(B4,2) : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|xO_1bYgoQvA|280|center|PRODUCT}} | ||
| + | |||
| + | ==See also== | ||
| + | |||
| + | *[[Manuals/calci/SUM| SUM]] | ||
| + | *[[Manuals/calci/AVERAGE| AVERAGE]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://en.wikipedia.org/wiki/Product_(mathematics) PRODUCT] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:13, 21 August 2018
PRODUCT()
- Parameter are any integer values.
- PRODUCT(), Multiplies its arguments.
Description
PRODUCT()
For Example,
PRODUCT(34,99) returns 3366.
PRODUCT(0.1,5,-3) returns -1.5.
- Number arguments can be positive or negative.
- Function should contain at least one number (i.e. ) or range, else Calci displays an error message. There can be any number of arguments.
- If logical values, empty cells or text are entered directly as a part of argument, they are ignored.
- If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored.
- Logical values are evaluated as TRUE=1, FALSE=0.
- PRODUCT() can also be used for an array of numbers as -
) or range, else Calci displays an error message. There can be any number of arguments.PRODUCT(1..10) returns 3628800.
Examples
| 0.44 | -5 | |
| 10 | 4 | |
| 13 | ||
| 20 | TEXT | |
| FALSE |
=PRODUCT(A1:A4) : Calculates the product of values in the range A1 to A4. Returns 1144 as a result. =PRODUCT(10,A5) : Calculates the product of 10 and reference A5 (value 0 for FALSE). Returns 0 as a result. =PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns -20 as a result. =PRODUCT(B4,2) : Calculates the product of reference B4 and 2. Text is ignored. Returns 2 as a result.
Related Videos
See also
References