wrote in message
ups.com...
Teethless mama wrote:
=ROUNDUP(A1,-2)

That rounds up to the nearest __100__, not nearest 500 except by
coincidence. It works with the OP's example (525446).

But roundup(525321,-2) is 525300, not 525500.

It actually gives 525400, but we know what you mean. :-)
--
David Biddulph