EXCEL中A1,B1,C1,D1四个单元格,其中A1,B1,C1三单元格的值为0-9的整数...答:d1=IF(OR(SUM(SMALL(A1:C1,{1,2,3})*{100,10,1})=19,(MEDIAN(A1:C1)=MIN(A1:C1)+1)+(MEDIAN(A1:C1)=MAX(A1:C1)-1)=2),"三连号",IF(OR(MAX(A1:C1)-MIN(A1:C1)=9,MEDIAN(A1:C1)=MIN(A1:C1)+1)+(MEDIAN(A1:C1)=MAX(A1:C1)-1),"二连号","无连号"))按 lee...
EXCEL中当A1单元格为1 B1单元格为2 C1单元格为3 D1单元格为4 E1单元...答:=LOOKUP(D24,{0,1,2,3,4},{"显示1","显示2","显示3","显示4","显示5"})自己替换显示1-5的内容 你的题目是什么意思 能讲明白点吗 =IF(OR(A1=1,B1=2,C1=3,D1=4,E1=5),"好","")