PRODUCTROUND3D

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