Thread: Rounding to nearest 250 by 125s
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tcek tcek is offline
external usenet poster
  
Posts: 26
Default Rounding to nearest 250 by 125s
i would like to round a number to the nearest 250 in increments of 125.
(i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would
round to 1250)
pleas advise and thanks in advance
Reply With QuoteReply With Quote