Roundup to nearest 250

[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?

[Bob Phillips]

=CEILING(A10,250)

--

HTH

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


"Hall" <hall@garp.org> wrote in message
news:eGGPR8x3FHA.700@TK2MSFTNGP15.phx.gbl...
> 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?
>
>