if函数并列满足多个条件

更新时间：2021-03-27 06:36:32 111次访问

如A1<15,B1<12,C1<0.75,D1<0.625满足该条件则为“1”
   A1<15,B1<12,C1<0.75,D1>0.625同时<1满足该条件则为“2”
A1>15<18,B1>12<14,C1>0.75<8,D1<0.625满足该条件则为“3”
不满足任意一个为“0”

=IF(AND(A1<15,B1<12,C1<0.75,D1<0.625),1,IF(AND(A1<15,B1<12,C1<0.75,D1>0.625,D1<1),2,IF(AND(AND(A1>15,A1<18),AND(B1>12,B1<14),AND(C1>0.75,C1<8),D1<0.625),3,0)))