Conditional decimal rounding

[NicholasP]

So I have a group of numbers that I would like to round based off the 4th decimal place. If the 4th decimal place is 5 or higher, I would like to round the 3rd decimal up. If the 4th decimal place is 4 or lower, I would like to round the 3rd decimal down. Below is a sample of my data. On the left is the original number and on the right is the output I hope to achieve.

Thanks in advance!
Nick

15.3168079​	15.317​
7.187263411​	7.187​
18.64830602​	18.648​
6.067670351​	6.068​
14.00803366​	14.008​
8.758678661​	8.759​
13.56049066​	13.56​
7.29679058​	7.297​
18.56330868​	18.563​

 

[NicholasP]

Actually, I think I can just use the round function. Mini brain cramp there! Sorry!

 

[DanteAmor]

Did you solve it?
Try:

Dante Amor.xlsm
	A	B
1
2	15.3168079	15.317
3	7.187263411	7.187
4	18.64830602	18.648
5	6.067670351	6.068
6	14.00803366	14.008
7	8.758678661	8.759
8	13.56049066	13.56
9	7.29679058	7.297
10	18.56330868	18.563
Hoja3

Cell Formulas
Range	Formula
B2:B10	B2	=ROUND(A2,3)