How to round numbers to the nearest 250

[Malthus101]

Hello

I'm dealing with quite large numbers and need the "number of contracts bought or sold" rounded to the nearest 250.

So:

10112 would be rounded to 10000
10220 would be rounded to 10250
10650 would be rounded to 10750

and so on. rounded up or down, it doesn't matter. precision only necessary to whole numbers, no decimals.

In the future, I may change this to the nearest 500.

Thanks.

 

[Fluff]

How about

=MROUND(A2,250)

 

[Malthus101]

How about

=MROUND(A2,250)

This seems to be simple and good! Give me a couple of days to try it but I think it's the one! Thanks.

 

[Fluff]

Glad to help & thanks for the feedback.