View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Rounding up help

"Kaputa" wrote:
If the value at the second decimal place is 5 or <5,
increase or decrease value at the first decimal place
by 1. Ex., 3.36 to 3.4 and 3.34 to 3.3. When the
value is =5, the value should also be incresed by
1. Ex., 3.35 to 3.4. What is the formula one should use?


Does ROUND(value,1) do the trick for you? If not, why not?