i would like to know a formula on how to round a number to 500

[nsv]

Try the ROUNDM function.

 

[Ron Rosenfeld]

=ROUND(A1/500,0)*500


--ron