EXCEL IF多条件函数，怎么算都只得出一个值，急急急急急！！！！帮忙给看看吧

Question

a＜75%,0 75%≤a＜90%,0.5 90%≤a＜110%,1 110%≤a＜150%,1.5 a≥150%,2
我设的公式：IF(F11<75%,0,IF(75%<=F11<90%,0.5,IF(90%<=F11<110%,1,IF(110<=F11<150%,1.5,2))))，我不知道问题在哪，最后结果都是2，急死了，求助！！！

Answer 1

改成如下形式就可以了
=IF(F11<75%,0,IF(F11<90%,0.5,IF(F11<110%,1,IF(F11<150%,1.5,2))))
试试吧

Answer 2

IF(F11<75%,0,IF(and(f11>=75%,F11<90%),0.5,IF(and(f11>=90%,F11<110%),1,IF(and(f11>=110%,F11<150%),1.5,2))))