View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trichey trichey is offline
external usenet poster
 
Posts: 1
Default Rounding in Excel

I am trying to round a cell either up to the nearest 500 or down to the
nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500).
Help?