Rounding to Nearest 250
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.
Without requiring the ATP, you could use
=ROUND(x/250,0)*250
|