如果a2=空,则空,否则 [ 如果 COUNTIF($C2:$H2,L$1)等于L1,则等于L1,否则为空 ]
公式“=IF($A2="","",IF(COUNTIF($C2:$H2,L$1),L$1,
1个回答
相关问题
-
在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:
-
公式“=IF($A2="","",IF($J2=AT$1,AT$1,""))什么意思
-
=IF(COUNTIF(表1!A:A,A2)>0,"是","否") 这句话怎么理解?
-
=DA">
if公式,以下公式是啥意思,=IF(COUNTIF(I114,"*VISA ONLY*"),IF(OR(M114>=DA
-
在excel中SUMPRODUCT((COUNTIF($G2:$L2,$B2:$D2)>0)*1)
-
英语小CASE(1)will l fail my tast if l do that?(2)l thought you
-
=90,"AB",IF(C2>=80,"B",IF(C2>=70,">
IF函数问题=IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,
-
若l a+1l+l b-2l+l c+3l=0,则(a-1)(b+2)(c-2)的值是
-
杠杆公式变形F1L1=F2L2那F2=?F1=?L1=?L2=?
-
=IF(B2=MAX(IF(A$2:A$582=A2,B$2:B$582)),"MAX","1")这个公式有问题吗?