Thread: how can i round a dollar amount to the nearest thousand?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
  
Posts: 447
Default how can i round a dollar amount to the nearest thousand?
I'm trying to set up a spreadsheet and one of my columns I want to have
rounded to the nearest dollar amount. I want, if the amount is 18575.00 to
round to 19000.00 and if the amount is 18475.00 to round to 18000.00. How can
I do this?
Reply With QuoteReply With Quote