View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Holly Holly is offline
external usenet poster
 
Posts: 94
Default if function with rounding

I need to set up a function that rounds numbers up to the nearest whole
number if the decimal is greater than .5 and the number is odd, and rounds
down to the nearest whole number if the decimal is less than .5 with an odd
integer or if it is even no matter what the decimal is. Does anyone know if
there is a way to set this up?? I am trying to help out a co-worker, and I
hit a wall with this spreadsheet.

Thanks