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