在Excel中四舍五入的7种方法

It's not usually as obvious as the error in the screen shot below, but have you ever seen Excel adding things up incorrectly? No wonder some people take out a calculator, to check the totals! Your trusty old calculator wouldn't tell you that 2+2=5.

它通常不如下面的屏幕快照中的错误那么明显，但是您是否曾经看到Excel错误地添加了东西？ 难怪有人拿出一个计算器来检查总数！ 您可信赖的旧计算器不会告诉您2 + 2 = 5。

Excel错误 (Excel Is Wrong)

Yes, it certainly looks wrong, but sometimes 2+2 = 5 in Excel.

是的，它看起来确实不对，但是有时在Excel中为2 + 2 = 5。

Or, you could make things even more confusing, and show that 2+3=4.

或者，您可以使事情变得更加混乱，并显示2 + 3 = 4。

隐藏信息 (Hidden Information)

You might be able to guess why those totals look wrong. Even a simple spreadsheet like this one can have things going on below the surface.

您也许可以猜测为什么这些总数看起来不对。 即使是像这样的简单电子表格，也可以在表面下进行处理。

The problem with "incorrect" totals can occur if you use number formatting to make the numbers look rounded. Excel hides the decimals, but they're still stored as part of the number.

如果使用数字格式使数字看起来四舍五入，则可能会出现“总数不正确”的问题。 Excel隐藏小数，但它们仍作为数字的一部分存储。

In the first example, the numbers look like 2+2, but the actual numbers are 2.3 and 2.3, which add up to 4.6.

在第一个示例中，数字看起来像2 + 2，但实际数字是2.3和2.3，总计为4.6。

In the second example, the actual numbers are 1.54 and 2.54, which add up to 4.08.

在第二个示例中，实际数字为1.54和2.54，总计为4.08。

So, be careful if you're using number formatting that hides the decimals, or someone might question the accuracy of your spreadsheet!

因此，如果您使用隐藏小数位的数字格式，请当心，否则有人可能会质疑电子表格的准确性！

使用Excel函数进行舍入 (Use Excel Functions for Rounding)

In some cases, you might want to use a function to round the numbers, instead of just hiding the decimals.

在某些情况下，您可能想使用一个函数对数字进行四舍五入 ，而不仅仅是隐藏小数。

To help you get started, I've made this short slide show that shows 7 ways to round in Excel.

为了帮助您入门，我制作了此简短的幻灯片演示，其中显示了在Excel中四舍五入的7种方法。

It shows number formatting, and the problem it can cause.

它显示数字格式及其可能引起的问题。

There are also rounding examples that use the Excel functions ROUND, ROUNDDOWN, ROUNDUP, FLOOR, and CEILING.

还有一些使用Excel函数ROUND，ROUNDDOWN，ROUNDUP，FLOOR和CEILING的取整示例。

演示地址

在Excel中四舍五入的7种方法 (7 Ways to Round in Excel)

To see the details for the rounding examples in the slide show, go to the Excel Rounding Functions page on my Contextures website. There are workbooks to download too, so you can follow the examples.

若要在幻灯片中查看四舍五入示例的详细信息，请转到Contextures网站上的“ Excel四舍五入函数”页面 。 也有要下载的工作簿，因此您可以按照以下示例进行操作。

It also has an MROUND example, and looks at the variations for the FLOOR and CEILING functions.

它还有一个MROUND示例，并介绍了FLOOR和CEILING函数的变体。

翻译自: https://contexturesblog.com/archives/2017/04/20/7-ways-to-round-in-excel/