Please see the excel sheet.
Please note that I have entered random between formula that may change values in your system.
I have entered =RANDBETWEEN(100,999)/99 in cell C8 and have placed comma style to 2
The value of randbetween I got is 8.52.
Now if we manually multiply 8.52 x 1000 we should get 8520,
whereas Excel calculate it as 8515.
I would like excel to calculate it as 8520 only.
I tried the rounding formula like =ROUND((C8*E8),-1), but that did not help as I have many other data where -1 does not give correct result.