excel中的if和and使用问题
发布网友
发布时间：2022-04-23 14:58
共4个回答
热心网友
时间：2022-07-12 03:26
=IF(AND(B3=0.5,I3>=3),0.0953,IF(AND(B3=0.5,I3<3),0.1307,IF(AND(B3=0.6,I3>=3),0.1431,IF(AND(B3=0.6,I3<3),0.1723,""))))
看看这个是否符合你的要求。主要是你的括号问题。
if语句的格式应为if(条件，结果1，结果2）条件成立返回结果1，否则，为结果2.
热心网友
时间：2022-07-12 03:26
=IF(AND(B3=0.5,I3>=3),0.0953),IF(AND(B3=0.5,I3<3),0.1307),IF(AND(B3=0.6,I3>=3,0.1431),IF(AND(B3=0.6,I3<3),0.1723,""))
热心网友
时间：2022-07-12 03:27
少了一个),在0.1431的逗号前,改为如下:
=IF(AND(B3=0.5,I3>=3),0.0953),IF(AND(B3=0.5,I3<3),0.1307),IF(AND(B3=0.6,I3>=3),0.1431),IF(AND(B3=0.6,I3<3),0.1723))
热心网友
时间：2022-07-12 03:27
=IF(AND(B3=0.5,I3>=3),0.0953,IF(AND(B3=0.5,I3<3),0.1307,IF(AND(B3=0.6,I3>=3),0.1431,IF(AND(B3=0.6,I3<3),0.1723))))
这样就对了
