Try this:

=ROUNDUP(A1/500,0)*500

HTH,
Elkar


"Heather" wrote:

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