View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Round to the nearset 10th

Hello, Im working with a currency where the smallest coin is $0.10, how do I
set up a formula where if for example I get $12.71 it will round down to
$12.70 but if I get $12.76 it will round up to $12.80?

thanks!