The
PRODUCT() function returns the
product of it's arguments.
- The syntax for the function
is PRODUCT (number 1, number
2, ....numnber n).
The
arguments "number 1, number2,....number
n" can be numerical values,
logical values, cell references to values,
named ranges or arrays.There can be up
to 30 arguments each multiplied together
to find the resulting product. However
if a referenced cell or element of an array
is empty or contains logical values, text
or errors the PRODUCT functtion will ignore
the argument.
The
PRODUCT function can return integer and
non integer decimals as results of the
product. For example: PRODUCT(2.13, 10)
=21.3 and PRODUCT(5.2, 4.6, -8.6) = -205.712
Although
referenced logical values are ignored by
the function it can accept logical values
as arguments when they are entered directly
e.g PRODUCT(TRUE,TRUE,TRUE)=1 and PRODUCT(TRUE,FALSE,TRUE)=0.
|
