Rounding to nearest 250 by 125s

  • Thread starter Thread starter tcek
  • Start date Start date
T

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
 
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.
 
thank you

Fred Smith said:
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.
Click to expand...
 
Back
Top