Forum Discussion
JStant9887
Sep 15, 2020Copper Contributor
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.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 Replies
- SergeiBaklanDiamond Contributor
- BennadeauIron Contributor
Hi JStant9887,
This should do it.
=IF(RIGHT(A1,2)=".5",A1,ROUND(A1,0))This will run against any number in cell A1