EXCEL中,如何利用函数表达下例子?如在B列中,若A列表包...答:回答:b2公式 =if(and(countif(a:a,"A"),countif(a:a,"B"),countif(a:a,"C")),6,if(and(countif(a:a,"D"),countif(a:a,"E"),countif(a:a,"E"),countif(a:a,"K)),9,"")) 上面公式是A列中包含A、B、C三个及D、E、F、K四个时的公式; 如果只要包含其中一个...
怎么从很多号码中把手机号码后四位为aabb abab abc aaab的筛选出来答:比如电话号码在A列,号码类别判断在B列,从第二行开始判断(B2)单元格。完整函数公式如下:=IF(AND(TEXT(MID(A2,8,1)+1,"#")=MID(A2,9,1),TEXT(MID(A2,9,1)+1,"#")=MID(A2,10,1),TEXT(MID(A2,10,1)+1,"#")=MID(A2,11,1)),"ABCD",IF(AND(MID(A2,8,1)=MID(A2,9...