6: Clarius Model 4200A-SCS Parameter Analyzer
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)
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
Also see
SUM (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)
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
.
Also see
None