writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 11:
Line 11: − + − + + − 1)It is logical values,+ − 2)It is empty cells,+ − 3)It is text.+ − +
no edit summary
For Example,
For Example,
PRODUCT(34,99) ''returns ''.
PRODUCT(34,99) ''returns 3366''.
PRODUCT(0.02,5,-3) ''returns ''.
PRODUCT(0.1,5,-3) ''returns -1.6''.
*Arguments can be numbers, logical values, text representations.
*Arguments can be numbers, logical values, text representations.
*Number arguments can be positive or negative.
*Function should contain at least one argument, else Calci displays an error message. There can be any number of arguments.
*Function should contain at least one argument, else Calci displays an error message. There can be any number of arguments.
*If arguments is an array or reference, only numbers are considered.
*If arguments is an array or reference, only numbers are considered.
*The arguments are ignored, if
*The arguments are ignored, if
# It is logical values,
# It is empty cells,
# It is text.
*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 ''.
PRODUCT(1..10) ''returns 3628800''.
== Examples ==
== Examples ==