Thread: rounding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
egarcia egarcia is offline
external usenet poster
 
Posts: 13
Default rounding

I'm trying to round resources down if they are less than .5, up if greater
than a .5, and also equal to 1 if less than .5. For example 1.2 = 1, & 1.6 =
2, .4 = 1. My formula is = round(AB23/AB36,0), but less than .5 = 0