Here is the formula I came up with:

- Code: Select all Expand viewCollapse view
`=IF(ROUND(MOD(A1;0.1);2)<0.05;CEILING(A1;0.05);CEILING(A1;0.1)-0.01)`

There are two flaws with this formula I haven't worked out. The first occurs when the value of A1 has a zero in the 1/100th position (e.g. if A1=6.60, it will not round with my formula). The second occurs when there is a 5 in the 1/100th position (e.g. if A1=6.65, the formula will resolve to 6.69). I would prefer to leave the value unchanged in this case.

I appreciate any and all help!