View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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