Rounding to Nearest 250
=250*ROUND(A1/250,0)
"Scott G" wrote:
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
|