Difference between revisions of "Manuals/calci/PRODUCT"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
(No difference)
|
Revision as of 02:42, 25 October 2013
Syntax
Remarks
Examples
''''''' ''''
Description
PRODUCT
PRODUCT (N1, N2 …)
Where N1, N2 ... are integers
numbers, logical values, text representations are counted. Empty cells, text are ignored.
This function is used to multiply all the numbers in the given arguments.
Lets see an example
PRODUCT (N1, N2….)
The numbers are B2=10, B3=13, B4=20
That is PRODUCT (B2:B4) is 2600
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 4 | ||
| Row2 | 13 | |||
| Row3 | 20 | |||
| Row4 | 2600 | |||
| Row5 | ||||
| Row6 |
