Hi J.E.
not sure if this returns the desired results for values such as
1.995
as this returns
1.99
on the other hand probably only a theoretical discussion :-)

Just as alternative;
=CEILING(A1+0.01,0.1)-0.01


--
Regards
Frank Kabel
Frankfurt, Germany
"JE McGimpsey" schrieb im Newsbeitrag
...
note: your examples round to the next higher 0.09, not to the nearest
9th.

One way:

=CEILING(A1,0.1)-0.01


In article ,
"Corby" wrote:

Does Excel have the abilty to round to the nearest 9th?

Data Output
1.21 1.29
1.05 1.09
20.66 20.69