How to round off all the values with 0.000999 into 3 decimal places?

[RAIMY HAIDAR]

kindly please help,

How to round off all the values in a single column into three decimal places where the last three digit is end up with 0.000999 ( for example : 8.816999, 8.823999) without changing any closest data ?

**as shown in table below

[TABLE="class: grid, width: 150"]
<tbody>[TR]
[TD="align: center"]8.743989[/TD]
[/TR]
[TR]
[TD="align: center"]8.750991[/TD]
[/TR]
[TR]
[TD="align: center"]8.717999[/TD]
[/TR]
[TR]
[TD="align: center"]8.749[/TD]
[/TR]
[TR]
[TD="align: center"]8.75[/TD]
[/TR]
[TR]
[TD="align: center"]8.743999[/TD]
[/TR]
[TR]
[TD="align: center"]8.743958[/TD]
[/TR]
[TR]
[TD="align: center"]8.743979[/TD]
[/TR]
[TR]
[TD="align: center"]8.743999[/TD]
[/TR]
</tbody>[/TABLE]

 

[eddvrs]

Hey,

Try this adding this into a new column:

=IF((MID(A1,6,3))="999",ROUND(A1,3),A1)

Where your current values are in column A