在excel中将单元格值四舍五入到最近的千

I have been trying to round a cell value up or down to the nearest thousand but can't get it to work. I'm trying to calculate my hourly rate based on the current exchange rate from USD to VND But if the resulting total is something like 22,325 then it should round down to 22,000 and likewise if the hundreds are 500 or more it should round up to 23,000

我一直试着把一个细胞的价值提高到最近的千分之一，但却不能让它发挥作用。我试着根据当前的汇率从美元到VND来计算我的时薪，但是如果结果总数是22325，那么它应该四舍五入到22000，同样的，如果百位是500或更多，它应该四舍五入到23000

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

因此，每小时的税率是527,325，应该是527000。该单元已经包含一个公式，可以将当前的汇率乘以美元。

4 个解决方案

#1

Using the ROUND function:

使用圆的函数:

=ROUND(A1,-3)

=圆(A1,3)

Where A1 is the cell containing the number you wish to round. The negative number specifies digits to the left of the decimal point to replace with zeros (the number of zeros at the end of the number).

其中A1为单元格，包含您希望四舍五入的数字。负数将小数点左边的数字指定为0(数字末尾的0)。

Like so:

像这样:

=ROUND( 34528, -3 ) = 35000

=圆(34528，-3)= 35000

As for the OP's example:

关于OP的例子:

=ROUND( 22325, -3 ) = 22000

= 22325， -3 = 22000

The OP also stated:

OP也说:

likewise if the hundreds are 500 or more it should round up to 23,000

同样，如果百位是500或更多，则应该是23,000

=ROUND( 22500, -3 ) = 23000

=ROUND(22500， -3) = 23000。

See ROUND Function Office support

参见功能办公室支持。

#2

You can also try this:

你也可以试试:

=MROUND(A1,1000)

This should give you what you want.

这会给你想要的。

#3

You've asked specifically for a formula that when it 'says 527,325 it should round down to 527,000'. For this you would need the FLOOR¹ function or ROUNDDOWN¹ function.

你特别要求一个公式，当它说527,325时，应该四舍五入到527,000。这个你需要地板¹函数或ROUNDDOWN¹函数。

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

There is also leaving the number alone but formatting with a custom number format of 0, K but this does not round down. If the number was 527,501 it would display 528 K not 527 K.

也有保留数字，但格式化自定义数字格式为0,K，但这并不是四舍五入。如果数字是527,501，它将显示528 K而不是527 K。

      

      

¹ _{The counterparts to FLOOR and ROUNDDOWN are the CEILING function and ROUNDUP function.}

¹相对应的地板和ROUNDDOWN天花板和综述功能函数。

#4

Divide by 1000, then round, then multiply by 1000.
The formula for rounding A1 in this way would be:

除以1000，再圆，再乘以1000。以这种方式将A1四舍五入的公式是:

=ROUND(A1/1000)*1000

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

如果一个公式已经存在于A1单元中，只需将A1替换为上面表达式中的新公式。