更新时间2019-03-24 23:14:54
提示错误
=IF(AND(B2<3,F2<1.6),"1.1",OR(AND(B2>3,F2>1.6),"1.2","1"))
改为:
=IF(AND(B2<3,F2<1.6),"1.1",IF(AND(B2>3,F2>1.6),"1.2","1"))
逻辑关系为:
当B2<3及F2<1.6时:返回字符串"1.1"【非数值】;
当B2>3及F2>1.6时:返回字符串"1.2"【非数值】;
以上不成立时:均返回字符"1"【非数值】。
固定值怎么能用在OR条件里面