View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Orninn Orninn is offline
external usenet poster
 
Posts: 4
Default Price calculation - rounding

I´m doing price calculation in my Excel. I have a problem in rounding the
final figure. I want prices to be rounded up to the next tehth for prices
from 5 and over and lowered to the next tenth for prices 4,99 and under. Can
anyone guide me?