Scott G wrote in
8.18:

Scott G wrote in
8:

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.

Is there a way to round UP to the nearest 250 without using an IF
statement?

Thanks Again,
Scott

I found my own answer by using ROUNDUP. This forumla seems to work:

=250*ROUNDUP(A2/250,0)

Thanks for your help!