Rounding to nearest 250 by 125s

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
 
F

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.
 
T

tcek

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding problems 6
Rounding up to a set of specific numbers? 6
Rounding Time to Nearest 5 Minutes 1
Round Function 5
Rounding to Nearest 250 6
Alternate Rounding Up & Down of .50 in a column 5
Round Question 3
rounding figures to nearest thousand 3

Top