Round any decimal except 0.5

[JStant9887]

Hey all, wondering if anyone can help with a formula that can evaluate a cell that has repeating decimals and round that to an integer, but don’t round a cell that returns a number that ends in just 0.5. For example I want to leave 17.5 as 17.5 but round 13.33333 down to 13 and 15.6666 up to 16. Any ideas?

[#2]

Hi @JStant9887,

This should do it.

=IF(RIGHT(A1,2)=".5",A1,ROUND(A1,0))

 This will run against any number in cell A1

[#3]

@JStant9887 

As variant