maybe for both positive and negative rounded to 500.

=SIGN(A1)*CEILING(ABS(A1),500)



"David Biddulph" wrote:

Yes, I'll call you crazy!

=CEILING(A1,500)
--
David Biddulph

"Heather" wrote in message
...
Call me crazy, but I have read every rounding question and answer and I
cannot get Excel to round up to the nearest 500.

IE: 525446 needs to be 525500

Can anyone help! Heather