View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott G
 
Posts: n/a
Default Rounding to Nearest 250

I am want to round entries in a spreadsheet to the nearest 250. For
example, 510 would be rounded to 500; 3,810 would be rounded to 3,750,
etcetera.

Do I use the Rounding function or a series of IF statements?

Thank you for your help!!!

Scott