Excel IF函数大于x但小于y [英] Excel IF function greater than x but less than y

问题描述

我正在尝试安排一个专栏，以便我可以基本上得分结果。我正在寻找一个公式，如果大于100000但小于110000 = 10，如果大于90000但小于99999 = 9等等。有人可以帮忙吗？

I'm trying to arrange a column so that I can essentially "score" results.. I am looking for a formula that will go "If greater than 100000 but less than 110000 = 10, if greater than 90000 but less than 99999 = 9, etc etc.. can someone help?

推荐答案

我们可以使用LOOKUP范围：

We can use LOOKUP with ranges:

=LOOKUP(A2,{0,90000,100000,110000,120000},{"0-89999","90000-99999","100000-109999","110000-119999","120000-Inf"})

我使用查找输出作为范围来显示正在尝试执行的查找，在您的情况下使用以下内容：

I used lookup output as ranges to show what lookup is trying to do, in your case use below:

=LOOKUP(A2,{0,90000,100000,110000,120000},{8,9,10,11,12})

这篇关于Excel IF函数大于x但小于y的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！