Rounds all numbers
in a specified range to a specified number of digits, then multiply all the
rounded figures to give an answer.

PRODUCTROUND3D
is very similar to the PRODUCTROUND function of Excel Power Expander. The
main difference is that PRODUCTROUND3D considers all worksheets, while
the PRODUCTROUND function doesn't.

Syntax

PRODUCTROUND3D(range_input,
decimal_places)

range_input
- is the range for which you want to multiply. The same range in all worksheet
in the workbook will be considered.

decimal_places
- specifies the number of digits to which you want to round numbers.

Remark

Arguments that
are error values or text that cannot be translated into numbers cause errors.

If decimal_places
is greater than 0 (zero), then numbers are rounded to the specified number
of decimal places.

If decimal_places
is 0, then numbers are rounded to the nearest integer.

If decimal_places
is less than 0, then numbers are rounded to the left of the decimal point.