春分花雨 发表于 2021-10-16 10:39:00

按条件判断是否同时满足两个条件

各位大佬好，具体要求详见附件，感谢了~~~

九唔搭八 发表于 2021-11-5 04:19:35

=IF(AND(A3<0,B3<0.5%),"是","")

十二十二 发表于 2021-11-10 17:59:30

=IF(AND(A2<0,B2<0.5%),"是","")

流馨雨 发表于 2021-11-23 10:20:28

=IF((A2<0)*(B2<0.5%),"是","")

卯时有兔 发表于 2021-12-1 01:57:11

=IF(AND(SIGN(A2)=-1,B2<0.5%),"是","")

灵感乍现 发表于 2022-1-21 01:26:17

=IF(AND(A2<0,B2<0.5),"是","不是")
页: [1]
查看完整版本: 按条件判断是否同时满足两个条件