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.


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.