# PRODUCTROUND

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

## Syntax

**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.

**Remark**

- Arguments that
are error values or text that cannot be translated into numbers cause errors.
See the third example below.
- 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.

**Examples**

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.