Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-290
4200A-901-01 Rev. C / February 2017
PRODUCT Calc worksheet function
This command multiplies a list of numbers and returns the result.
Usage
PRODUCT(
Value_list
)
Value_list
A list of as many as 30 numbers, separated by commas
Details
Value_list
can contain numbers, logical values, text representations of numbers or a reference to
a range containing those values.
Error values or text that cannot be translated into numbers return as errors.
If a range reference is included in the list, logical expressions and empty cells in the range are
ignored.
Example
=PRODUCT(1, 2, 3, 4)
Returns
24.0000E+0
.
Also see
(on page 6-294)
ROUND Calc worksheet function
This command rounds the given number to the supplied number of decimal places.
Usage
ROUND(
Value
,
Precision
)
Value
Any number
Precision
The number of decimal places to which
Value
is rounded
Details
When a negative precision is used, the digits to the right of the decimal point are dropped and the
absolute number of significant digits specified by
Precision
are replaced with zeros.
If
Precision
is 0,
Value
is rounded to the nearest integer.
Example
=ROUND(879.278, 2)
=ROUND(9899.435, -2)
Returns
879.2800E+0
.
Returns
9.9000E+3
.
Also see
None