Rounds all numbers in a specified range to a specified number of digits, then multiply all the rounded figures to give an answer.
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.