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


PRODUCTROUND(range_input, decimal_places)

range_input - is the range for which you want to multiply.

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



PRODUCTROUND(A1:A2,0) equals 6

PRODUCTROUND (A1:A3,0) equals 6 because the text values are translated into numbers, and the logical value TRUE is translated into the number 1.

PRODUCTROUND (A1:A4,1) returns a #VALUE! error, because the word "Apple" in cells A4 is text.