Rounding a cell value to the nearest thousand in excel

Question

I am trying to round a cell value up or down to the nearest thousand, but cannot make it work. I am trying to calculate my hourly rate based on the current exchange rate from US dollar to VND. But if the final total value is approximately 22,325, then it should round to 22,000, and also, if hundreds are 500 or more, this should round to 23,000

So, when the hourly rate says 527,325, it should round to 527,000. The cell already contains a formula for multiplying the current exchange rate by USD.

Answer 1

Using the ROUND function:

=ROUND(A1,-3)

Where A1 is the cell containing the number you want to round. A negative number indicates the digits on the left of the decimal point to replace with zeros (the number of zeros at the end of the number).

Same:

=ROUND( 34528, -3 ) = 35000

Regarding the OP example:

=ROUND( 22325, -3 ) = 22000

The OP also stated:

Similarly, if hundreds are 500 or more, it should round to 23,000

=ROUND( 22500, -3 ) = 23000

See ROUND Office Feature

Answer 2

You can also try the following:

 =MROUND(A1,1000) 

That should give you what you want.

Answer 3

You requested a specific formula, when it says 527 325, it should round to 527,000 '. To do this, you need the FLOOR¹ function or the ROUNDDOWN¹ function .

 =FLOOR(A1, 1000) =ROUNDDOWN(A1, -3) 

Only the number remains, but formatting with a user-defined format number 0, K , but this does not round. If the number were 527 501, it would display 528 K not 527 K

¹ _{FLOOR and ROUNDDOWN accompaniments include the CEILING function and the ROUNDUP function .}

Answer 4

Divide by 1000, then round, and then multiply by 1000.
The formula for rounding A1 as follows:

 =ROUND(A1/1000)*1000 

If the formula already exists in cell A1 , simply replace A1 with the new formula in the upper expression.