当A1,A2,A3,A4大于0.5时，输出A10对应的1显示在A6位置

adsfawger · 发表于 2023-6-15 19:13

yfan17 · 发表于 2023-6-15 20:45

=IF(COUNTIF(A$1:A$4,">0.5")=4,A$10,"")

复制代码

=IF(COUNTIF(B$1:B$4,"<0.5")=4,B$10,"")

复制代码

橒♂蝣 · 发表于 2023-6-15 21:20

=IF(SUM(1*(A1:A4>0.5))=4,A10,"")

安若浅笑 · 发表于 2023-6-15 21:31

=IFERROR(VLOOKUP(A10,{1,0.571428571428571;1,0.6;1,0.666666666666667;1,0.857142857142857},1,1),"")
=IFERROR(VLOOKUP(B10,{2,0.3;2,0.35;2,0.333333333333333;2,0.2},1,1),"")

安若浅笑 · 发表于 2023-6-15 21:37

橒♂蝣发表于 2023-6-15 21:20
=IF(SUM(1*(A1:A4>0.5))=4,A10,"")

不懂就问，if套sum时为何是数组了

quqiyuan · 发表于 2023-6-15 21:41

=IF(AND(A1:A4>0.5),A10,"")

安若浅笑 · 发表于 2023-6-15 21:49

=IF(COUNTIF(A1:A4,">0.5")=4,A10,"")

安若浅笑 · 发表于 2023-6-16 06:58

安若浅笑发表于 2023-6-15 21:49
=IF(COUNTIF(A1:A4,">0.5")=4,A10,"")

对您有帮助请给朵花。数组：Ctrl+shift+enter

jivy1212 · 发表于 2023-6-16 08:01

=IF(MIN(A1:A4)>0.5,A10,"")

复制代码

		自动登录	找回密码
密码			免费注册

[求助] 当A1,A2,A3,A4大于0.5时，输出A10对应的1显示在A6位置