You can use the MROUND() function. It is part of the Analysis ToolPak, so
you'll need to make sure that is installed. (Tools--Add-Ins...--Check
"Analysis ToolPak"--OK)

=MROUND(A1,250)

HTH,
Elkar


"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