rounding a column to the nearest 1,000

[frosty3]

I am working on a spreadsheet for optional life insurance where I need to round to the nearest 1,000
eg. I have an employee who makes $51,320.00 annually and I need to round it to the nearest $1,000 (which would be $52,000.00) Can anyone help me figure out a calculation?

 

[shg]

=round(a1, -3) rounds

=ceiling(a1, 1000) gives the result in your example

 

[Scott Huish]

=roundup(a1,-3)

 

[frosty3]

Thank you so much!