Round to Nearest Half Based On Defined Range of Decimal

Originally Posted by shg

=int(a1) + lookup(round(mod(a1,1), 6), {0,4,8}/10, {0,5,10}/10)

This works PERFECTLY!!!!! I never would have come up with that myself.

.....Now I just have to learn why (or how) it works so I can do it on my own next time!