Forum Discussion
Round any decimal except 0.5
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...
Hi JStant9887,
This should do it.
=IF(RIGHT(A1,2)=".5",A1,ROUND(A1,0))This will run against any number in cell A1