如何在Excel中设置舍入精度

最新推荐文章于 2020-12-12 12:35:14 发布

culinxia2707

最新推荐文章于 2020-12-12 12:35:14 发布

阅读量955

点赞数 1

文章标签： excel python java 大数据 linux

原文链接：https://www.howtogeek.com/401844/how-to-set-the-rounding-precision-in-excel/

版权

Setting the rounding precision forces Excel to always round numeric values to a specified number of digits following the decimal, saving you from having to use the ROUND function on each formula. Here’s how it works.

设置舍入精度会强制Excel始终将数值四舍五入到小数点后的指定位数，从而使您不必在每个公式上使用ROUND函数。运作方式如下。

Note that setting Excel’s rounding precision can save time, but be certain you want to round all values before you enable this feature. When Excel is set to round numbers, it deletes the extra data following the precision point you set, permanently affecting the accuracy of the numbers in your workbook. This means, for example, that if a value like “12.7851698” is displayed with two digits after the decimal point, then Excel will permanently delete the “51698” and leave only the “12.76” remaining.

请注意，设置Excel的舍入精度可以节省时间，但是在启用此功能之前，请确定要舍入所有值。将Excel设置为四舍五入后，它将删除您设置的精度点之后的多余数据，从而永久影响工作簿中数字的准确性。例如，这意味着，如果显示的值如“ 12.7851698”，小数点后两位，则Excel将永久删除“ 51698”，仅保留“ 12.76”。

This feature also works on a per-workbook basis, meaning you can enable it for some workbooks and not others. You must enable it for an entire workbook, though; you can’t enable it only for specific sheets within a workbook.

此功能还适用于每个工作簿，这意味着您可以为某些工作簿而不是其他工作簿启用它。但是，您必须为整个工作簿启用它。您不能仅对工作簿中的特定工作表启用它。

在哪里可以找到“设置显示的精度”选项 (Where to Find the “Set Precision As Displayed” Option)

Navigate to the “File” menu.

导航到“文件”菜单。

Select the “Options” menu.

选择“选项”菜单。

In the Excel Options window that appears, click the “Advanced” category on the left.

在出现的“ Excel选项”窗口中，单击左侧的“高级”类别。

On the right, scroll all the way to the bottom. You’ll find the “Set Precision As Displayed” option in the “When Calculating This Workbook” section. You can select different currently-opened workbooks using the drop-down.

在右侧，一直滚动到底部。您将在“计算此工作簿时”部分中找到“设置显示的精度”选项。您可以使用下拉菜单选择当前打开的其他工作簿。

enable the set precision as displayed check box

When you select the check box, Excel displays a warning letting you know that the data in the workbook will permanently lose accuracy. Click the “OK” button.

当您选中该复选框时，Excel将显示一条警告，告知您工作簿中的数据将永久失去准确性。点击“确定”按钮。