Difference between revisions of "Manuals/calci/PRODUCT"

Latest revision as of 16: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. $n1$ ) 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 -

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.

References

PRODUCT

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+<div style="font-size:30px">'''PRODUCT()'''</div><br/>
-Syntax
+*Parameter are any integer values.
+**PRODUCT(), Multiplies its arguments.
-</div></div>
+== Description ==
-----
-<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
-Remarks
+PRODUCT()
-</div></div>
+For Example,
-----
-<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
-Examples
+PRODUCT(34,99) ''returns 3366''.
-</div></div>
+PRODUCT(0.1,5,-3) ''returns -1.5''.
-----
-<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
-----
-<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
-<font size="5">Description</font>
+*Number arguments can be positive or negative.
+*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 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(1..10) ''returns 3628800''.
-</div></div>
+== Examples ==
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">PRODUCT</font> </font>'''</div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
-PRODUCT (N1, N2 …)
-Where''' N1, N2 ...'''   are integers
-</font></font></div></div>
-----
-<div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
-<font size="3"><font face="Times New Roman"> numbers, logical values, text representations are counted. Empty cells, text are ignored.</font></font>
-</div></div>
-----
-<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
-This function is used to multiply all the numbers in the given arguments.
-</div></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
-Lets see an example
-PRODUCT (N1, N2….)
-The numbers are B2=10, B3=13, B4=20
-That is PRODUCT (B2:B4) is 2600
-</font></font></div></div>
-----
 <div id="6SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="   " |
+| class="sshl_f" | 0.44
-<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+| class="sshl_f" | -5
-| Column1
+| class="sshl_f" |
-| class="  " | Column2
-| class="  " | Column3
-| class="  " | Column4
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" | 10
-| class="sshl_f " | 10
 | class="sshl_f" | 4
 | class="sshl_f" |
-| class="sshl_f" |
 |- class="even"
-| class="  " | Row2
 | class="sshl_f" | 13
 | class="sshl_f" |
 | class="sshl_f" |
-| class="sshl_f" |
 |- class="odd"
-| Row3
+| class="sshl_f" | 20
-| class="sshl_f " | 20
+| class="sshl_f" | TEXT
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="even"
-| Row4
-| class="sshl_f" | 2600
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="odd"
-| class=" " | Row5
-| class="sshl_f SelectTD SelectTD" |
-<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| class="sshl_f" |
-| class="sshl_f" |
 | class="sshl_f" |
 |- class="even"
-| Row6
+| class="sshl_f" | FALSE
-| class="sshl_f" |
-| class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =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.
-</div></div></div></div></div></div></div></div></div></div></div></div>
+ =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 ]]

Difference between revisions of "Manuals/calci/PRODUCT"

Latest revision as of 16:13, 21 August 2018

Contents

Description

Examples

Related Videos

See also

References

Navigation menu

Search