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

what we are looking for is to round to the nearest 900. Example: if you have
$100,500 we want it rounded to $100,900. If we have $100,200 we want it
rounded to $99,900. Any help would be appreciated.
Thanks!