Rounding to nearest 250 by 125s
 

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

Rounding to nearest 250 by 125s
 

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

Rounding to nearest 250 by 125s
 

thank you

"Fred Smith" wrote:

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

Rounding to nearest 250 by 125s
 

Glad I could help. Thanks for the feedback.

Regards,
Fred

"tcek" wrote in message
...
thank you

"Fred Smith" wrote:

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