View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dd
 
Posts: n/a
Default In Excel, how do I look for the last number either 0 or 5

On our pricing sheet, we want to round up if the last number of a two decimal
place 5 or more and round down if less than 5 per cell. I know a if
statement should do it, but have not been able to complete one.