Excel公式，再次 [英] Excel formula, again
问题描述
大家好。
如果有人可以帮我解决以下公式。
我正在使用MS Excel，Office 2003.
I30的最低值是1.
重要的参数，公式在J30：
如果I30<或= = 1.6比J30为1;
如果I30> 1.6比J30为2;
如果I30<或者= = 2.6比J30是2;
如果I30> 2.6比J30为3;
如果I30<或= = 3.6比J30为3;
如果I30> 3.6比J30为4;
并且一直向上，增量为1，最后一个参数为：
如果I30> 14.6比J30是15;
---------------------
真实例子：
I30 = 12.67，J30的值应为13.
I30 = 17.11。 J30的价值应该是15.
-------------------
谢谢你的支持时间和帮助。
Hello all.
If someone could please help me with the following formula.
I''m using MS Excel, Office 2003.
Lowest value for I30 is 1.
Arguments that are important, formula is in J30:
If I30 < or = 1.6 than J30 is 1;
If I30 > 1.6 than J30 is 2;
If I30 < or = 2.6 than J30 is 2;
If I30 > 2.6 than J30 is 3;
If I30 < or = 3.6 than J30 is 3;
If I30 > 3.6 than J30 is 4;
and all the way up, in increments of 1, with last argument being:
If I30 < or = 14.6 than J30 is 14;
If I30 > 14.6 than J30 is 15;
---------------------
Real example:
I30 = 12.67, J30 should have value of 13.
I30 = 17.11. J30 should have value of 15.
-------------------
Thank you for your time and help.
推荐答案
您应该寻找共同模式并推广结果。各个数字都以相同的方式处理 - 如果低于n.61则向下舍入，如果超过则向上舍入。
您需要做的就是使用正常的舍入公式 - 在I30上的值小于0.5的标记上的小数值和下面的小数值 - 但小于0.11 （将舍入阈值设置为0.61而不是0.5）：
在J30中放置简单的公式
You should be looking for the common pattern and generalising the result. The individual numbers are all treated in the same way - rounded down if below n.61, rounded up if above.
All you need to do is to use the normal rounding formula - which rounds up on decimal values above the 0.5 mark and down on those below - on the value in I30, but less 0.11 (to set the rounding threshold to 0.61 instead of 0.5):
In J30 place the simple formula
谢谢Stewart。
赞赏。
Thank you Stewart.
Appreciated.
我对Excel的了解非常有限。
这不是家庭作业，这是我正在运行的一些练习，试试学习一些Excel功能并自动完成我的一些工作。
这就是我为J30& amp;它不起作用：
= ROUND（
My knowledge of Excel is very limited.
This is not homework, it is some exercise that I am running, trying to learn some Excel functions and automate some of my work.
This is what I came up with for J30 & it is not working:
=ROUND(
这篇关于Excel公式，再次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
