excel区域内只要有大于等于2的数就算做一个答:假设在A、B、C三列,则在D1中输入公式:=IF(ISERROR((COUNTIF(A:A,">=2"))),0,IF(COUNTIF(A:A,">=2")>0,1,0))+IF(ISERROR((COUNTIF(B:B,">=2"))),0,IF(COUNTIF(B:B,">=2")>0,1,0))+IF(ISERROR((COUNTIF(C:C,">=2")))...
excel,用VLOOKUP和大于小于等于两个公式合并起来设一个公式答:输入 =IF(VLOOKUP(E3,K:L,2,0)=0,VLOOKUP(E3,A:C,2,0),VLOOKUP(E3,K:L,2,0))
excel表中 a1单元格数值在大于2小于等于4则为5,大于4小于等于6则为10...答:=IF(AND(A1>2,A1<=4),5,IF(AND(A1>4,A1<=6),10,IF(AND(A1>6,A1<=8),15,IF(AND(A1>10,A1<=12),25,IF(AND(A1>12,A1<=24),30,"")))