View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YK YK is offline
external usenet poster
 
Posts: 8
Default Conditional Rounding

If I currenlty have a formula =INT((10*A1)+1)/10-0.01 to round up to the
nearest $x.x9. However, if the results are $x.09, $x.59, how do I append to
the formula to round up only $x.09and $x.59 to the nearest $x.10?

Thanks.