Spreadsheet Function

[Dave]

I need a function that will round my answer up to a number divisible by 500.
I am using EXCEL 2002

 

[Don Guillett]

MROUND

 

[Mike H]

Try

=CEILING(your_formula,500)

Mike