View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

If none of the values will be negative:
=CEILING(A1,0.2)

If they can be positive or negative and you truly want the value to round up
to a larger value:
=IF(A1<0,-FLOOR(ABS(A1),0.2),CEILING(A1,0.2))

Does that help?

Ron