View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
trainer07 trainer07 is offline
external usenet poster
 
Posts: 42
Default How can I round a number in Excel to the nearest 5000?

I would like to round a number in Excel to the nearest 5000. For example, if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!