writer
2,661
edits
Changes
Manuals/calci/PRODUCT (view source)
Revision as of 21:54, 13 December 2013
, 21:54, 13 December 2013no edit summary
=PRODUCT(n1,n2,n3...)=
=PRODUCT(n1,n2,n3...)=
*where n1,n2,n3... are integer values.
*where <math>n1,n2,n3...</math> are integer values.
PRODUCT() multiplies the given arguments and displays the product.
PRODUCT() multiplies the given arguments and displays the product.
PRODUCT(0.1,5,-3) ''returns -1.5''.
PRODUCT(0.1,5,-3) ''returns -1.5''.
*Number arguments can be positive or negative.
*Number arguments <math>n1,n2,n3...</math> 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.
*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 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.
*If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored.