Excel计算为舍入数值，但更改为最后增加9.99 [英] Excel calculation to roundup number but change to add 9.99 at end

问题描述

是否可以使用Excel计算一列数据以将数字四舍五入但将其四舍五入到总是以9.99结尾

Is it possible with Excel to calculate a column of data to round the number up but round it up to always end in 9.99

• £123.12
• 54.68英镑
• £227.24
• 614.92英镑
• 307.12英镑
• 170.32英镑
• 1,569.82英镑
• £272.84
• 68.40英镑
• 34.19英镑
• 225.72英镑
• 33.44英镑
• 101.84英镑
• 112.86英镑
• £272.84

• £123.12
• £54.68
• £227.24
• £614.92
• £307.12
• £170.32
• £1,569.82
• £272.84
• £68.40
• £34.19
• £225.72
• £33.44
• £101.84
• £112.86
• £272.84

例如，上面是一个列，例如"D"，我想获取该列的数据，所以例如:

The above for example is a column for example "D" and I want to take the data of that column and around off so would be like this for example

• 129.99英镑
• 59.99英镑
• 229.99英镑
• 619.99英镑
• 309.99英镑
• 170.32英镑
• 1,569.99英镑
• 279.99英镑
• 69.99英镑
• 39.99英镑
• 229.99英镑
• 33.44英镑
• 109.99英镑
• 119.99英镑
• 279.99英镑

• £129.99
• £59.99
• £229.99
• £619.99
• £309.99
• £170.32
• £1,569.99
• £279.99
• £69.99
• £39.99
• £229.99
• £33.44
• £109.99
• £119.99
• £279.99

推荐答案

在A1中具有原始值，请根据需要使用此公式进行舍入

With original value in A1 use this formula to Round up as required

=ROUNDUP(A1+0.01,-1)-0.01

这篇关于Excel计算为舍入数值，但更改为最后增加9.99的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！