EXCEL中,单元格B1的内容包括A1,则在C1显示"正确“,如A1为”一三“,B1...答:可以用组合公式:=IF(ISERROR(SUMPRODUCT(FIND(MID(A2,{1,2,3},1),B2))),"","正确")如果字符不止3个,可以增加{1,2,3,4,5,6} 半角逗号隔开。
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,"")))