Thread: Round to nearest 5000?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
  
Posts: 284
Default Round to nearest 5000?
Hi,

I have a column of values that I want to round up or down to the nearest 5000.
Is there a function for this?

Examples:
Orig Rounded
167,200 165,000
165,764 165,000
159,812 165,000
192,116 190,000
189,253 190,000


--
-Kim
Reply With QuoteReply With Quote