在一个公式中超越更多条件？

Question

我能把这些条件放在一个公式里吗？

1. If the price (D2) is <= 20 and ROI (J2) is <= 10 then true or false.
2. If the price (D2) is between 20 and 60 and ROI (J2) is <= 5 then true or false.
3. If the price (D2) is between 60 and 150 and ROI (J2) is <= 4 then true or false.
4. If the price (D2) is between 150 and 500 and ROI (J2) is <= 3 then true or false.
5. If the price (D2) is >= 500 and ROI (J2) is <= 2.5 then true or false.

Answer 1

根据您在此处提出的问题，公式如下：

=IF(AND(D2<=20,ROI(J2)<=10),"Output1",IF(AND(D2<60,ROI(J2)<=5),"Output2",IF(AND(D2<150,ROI(J2)<=4),"Output3",IF(AND(D2<500,ROI(J2)<=3),"Output4",IF(AND(D2>=500,ROI(J2)<=2.5),"Output5",FALSE)))))

Answer 2

下面的代码略短一些，更易于阅读：

=IFERROR(“输出”&MATCH(1，(D2>={0,20,60,150,500})(D2<={20,60,150,500,99999})(J2<={10,5,4,3,2.5}),0)，FALSE)