excel四舍五入计算_在Excel中四舍五入

excel四舍五入计算

If you’ve been following the Canadian news (and who isn’t?), you know that the penny has been eliminated from circulation. To honour the occasion, Google made a special doodle for google.ca on February 4, 2013.

如果您一直在关注加拿大新闻(谁不是？)，您会知道一分钱都被取消了发行。 为了庆祝这一盛事，Google在2013年2月4日为google.ca做了一个特殊的涂鸦。

舍入准则 (Rounding Guidelines)

If you’re shopping with cash now, the final amount will be rounded up or down, to the nearest nickel. There are guidelines posted on the Royal Canadian Mint’s website: Eliminating the Penny: Rounding

如果您现在用现金购物，最终金额将四舍五入至最接近的整数。 加拿大皇家铸币局网站上发布了一些准则： 消除竹enny：四舍五入

四舍五入到最近的美分 (Rounding to the Nearest Cent)

As an example, the Mint’s website shows the purchase of coffee and a sandwich, with tax, for a grand total of $4.86.

例如，造币厂的网站显示购买咖啡和三明治(含税)，总计$ 4.86。

The tax department says to round the tax to the nearest cent, so you can use Excel’s ROUND function for to calculate the HST. Just multiply the subtotal by the tax rate, and round to 2 decimal places. Here is the formula in cell B6:

税务部门表示将税收四舍五入到最接近的一分，因此您可以使用Excel的ROUND函数计算HST。 只需将小计乘以税率，然后四舍五入到小数点后两位。 这是单元格B6中的公式：

=ROUND(B5*D6,2)

=圆(B5 * D6,2)

四舍五入到最近的镍 (Rounding to the Nearest Nickel)

With the HST, the grand total for the lunch is $4.86. We don’t have pennies now, so the cash payment will be rounded to the nearest nickel. Excel’s ROUND function can’t help with that.

使用HST，午餐的总费用为$ 4.86。 我们现在没有便士，因此现金付款将四舍五入到最接近的整数。 Excel的ROUND函数对此无济于事。

Fortunately, there is another rounding function – MROUND – that can round to a specified amount. The MROUND function has two arguments – the number, and the multiple.

幸运的是，还有另一个舍入函数MROUND可以舍入到指定的数量。 MROUND函数具有两个参数–数字和倍数。

In this example, we want to round the grand total, which is in cell B7. We’ll enter the multiple in cell B9, to show how the cash payment was rounded. Here is the cash payment rounding formula in cell B10:

在此示例中，我们要对总计总计进行四舍五入，该总计位于单元格B7中。 我们将在单元格B9中输入倍数，以显示现金付款的取整方式。 这是单元格B10中的现金支付取整公式：

=MROUND($B$7,$B$9)

= MROUND($ B $ 7，$ B $ 9)

测试MROUND公式 (Test the MROUND Formula)

A nickel is worth 5 cents, so what happens if you enter a 5 in cell B9, to use as the multiple?

镍的价值为5美分，那么，如果在B9单元格中输入5作为倍数，会发生什么呢？

Oops! That rounds the amount to 5 dollars, instead of the nearest nickel.

糟糕！ 取整后的金额取整为5美元，而不是最近的镍。

Change the amount in cell B9 to 0.05, which is the way that you’d enter a nickel amount in a worksheet.

将单元格B9中的数量更改为0.05，这是在工作表中输入镍量的方式。

Perfect! With the MROUND function, and a multiple of 0.05, you can round those sales totals to the nearest nickel.

完善！ 使用MROUND函数和0.05的倍数，您可以将这些销售总额四舍五入到最接近的整数。

翻译自: https://contexturesblog.com/archives/2013/02/14/round-to-a-nickel-in-excel/

excel四舍五入计算