how do I convert numbers to the nearest 1000

[Brian]

how do I convert numbers to the nearest 1000

 

[daddylonglegs]

=round(a1,-3)

 

[Fred Smith]

One way is to use MRound:

=Mround(a1,1000)

This requires the Analysis ToolPak to be installed.

Or:

=int(a1/1000)*1000