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" wrote in message
...
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