Roundup to nearest 250

H

Hall

I have list of numbers that need to be rounded up to the nearest 250.

For example:
1033->1250
600->750
25->250
2600->2750
1000->1000

What's a formula for that?
 
B

Bob Phillips

=CEILING(A10,250)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top