>That may work, but what if I did CEILING(9.1), I would get 10, when the rounded figure is actually 9.

THen why do you want 9.46 to got to 10? You have to explain your logic here.