View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
widman
 
Posts: n/a
Default Round up-down-or middle

Anyone know a good way to round so that a prices can end up in 50 cent
increments?
28.10 would round down to 28.00
28.40 wound end up 28.50
28.80 would end up 29.00