Rounding

[Repoort]

So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is....
5250 goes to 5000
6380 goes to 6500
7750 goes to 7500

any help is appreciated.

 

[Tetra201]

Maybe

=MROUND(A1-0.000001,500)

 

[Repoort]

thank you Tetra201.