Manuals/calci/PRODUCT

Revision as of 21:42, 24 October 2013 by MassBot1 (talk | contribs) (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=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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