how can i round a dollar amount to the nearest thousand?
 

I'm trying to set up a spreadsheet and one of my columns I want to have
rounded to the nearest dollar amount. I want, if the amount is 18575.00 to
round to 19000.00 and if the amount is 18475.00 to round to 18000.00. How can
I do this?

how can i round a dollar amount to the nearest thousand?
 

karen wrote:
I'm trying to set up a spreadsheet and one of my columns I want to have
rounded to the nearest dollar amount. I want, if the amount is 18575.00 to
round to 19000.00 and if the amount is 18475.00 to round to 18000.00.
How can I do this?

=round(A1, -3)

where A1 contains the dollar amount.