Excel中,A列等于某个数且B列和C列小于等于某个数,返回特定值?_百度...答:公式为:=IF(A1>1,"非绿色",IF(A1=1,IF(AND(B1>2,C1>2),"A",IF(AND(B1<=2,C1<=2),"AA","")),""))如图所示:
excel怎么用公式从A-B列,自动得到C-D列?答:D列公式=TRIM(MID(SUBSTITUTE(INDEX(B:B,SMALL(IF(LEN(B$2:B$4)-LEN(SUBSTITUTE(B$2:B$4," ",))+1>=COLUMN(A:J),ROW($2:$4),5),ROW(A1)))," ",REPT(" ",99)),1+99*(E2-1),99))在E列加了一个辅助列=(C2=C1)*E1+1,主要是A列有重复,实在想不起来咱们构建这个...