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))))
这样就对了