Thread
:
Rounding to the nearest 9th
View Single Post
#
2
JE McGimpsey
Posts: n/a
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
Reply With Quote