Rounding to nearest 250 by 125s

[tcek]

i would like to round a number to the nearest 250 in increments of 125.
(i.e.: 1100 would round to 1000, , 1125 would round to 1000, 1150 would
round to 1250)
pleas advise and thanks in advance

 

[Fred Smith]

Rounding to the nearest 250 would automatically be in increments of 125.

Try:
=mround(a1,250)

If you get a #Name error, install the Analysis Toolpak

Regards,
Fred.

 

[tcek]

thank you

Rounding to the nearest 250 would automatically be in increments of 125.

Try:
=mround(a1,250)

If you get a #Name error, install the Analysis Toolpak

Regards,
Fred.

 

[Fred Smith]

Glad I could help. Thanks for the feedback.

Regards,
Fred