View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default Round up or down by set variable

Is there a way to have a number round up or down based on a threshhold it
hits between the two number? I want a number when it hits .8 to round up,
otherwise round down.

For example 1.8 would round up to 2 but 1.79 would round down to 1
2.8 would round up to 3 but 2.79 would round down to 2, etc.