157字元
=IF(COUNTIF(B2:D2,"<4"),"","小")&IF(SUM(COUNTIF(B2:D2,{4,5,6})),"","中")&IF(COUNTIF(B2:D2,">6"),IF(COUNTIF(B2:D2,"<4")*SUM(COUNTIF(B2:D2,{4,5,6})),"无",""),"大")
133字元
=SUBSTITUTE(TEXT(IF(COUNTIF(B2:D2,"<4"),0,"小")&IF(SUM(COUNTIF(B2:D2,{4,5,6})),0,"中")&IF(COUNTIF(B2:D2,">6"),0,"大"),"[=000]无;;;@"),0,)
133字元
=CHOOSE(MMULT(--ISNUMBER(FIND({1,2,3},SUM(SUBSTITUTE(INT((B2:D2+2)/3),0,1)*10^COLUMN(A:C)))),{1;2;4}),"中大","小大","大","小中","中","小","无")
129字元
=SUBSTITUTE(TEXT(IF(COUNTIF(B2:D2,"<4"),"","小")&IF(SUM(COUNTIF(B2:D2,{4,5,6})),"","中")&IF(COUNTIF(B2:D2,">6"),0,"大"),";;无;@"),0,)
128字元
=TRIM(MID("中大小大大 小中中 小 无 ",2*MMULT(--ISNUMBER(FIND({1,2,3},SUM(SUBSTITUTE(INT((B2:D2+2)/3),0,1)*10^COLUMN(A:C)))),{1;2;4})-1,2))
128字元
=TRIM(MID("中大小大大 小中中 小 无 ",2*MMULT(--ISNUMBER(FIND({1,2,3},MMULT(--SUBSTITUTE(INT((B2:D2+2)/3),0,1),{1;10;100}))),{1;2;4})-1,2))
124字元
=TRIM(MID("中大小大大 小中中 小 无 ",2*MMULT(--ISNUMBER(FIND({1,2,3},SUM(SUBSTITUTE(INT((B2:D2+2)/3),0,1)*10^{1,2,3}))),{1;2;4})-1,2))
116字元
=TRIM(MID("无 小 中 小中大 小大中大",2*((COUNTIF(B2:D2,"<4")=0)*1+(SUM(-(B2:D2={4;5;6}))=0)*2+(COUNTIF(B2:D2,">6")=0)*4)+1,2))
116字元
=TRIM(MID("无 小 中 小中大 小大中大",MMULT(--(FIND({1,2,3},MMULT(INT(IF(B2:D2,B2:D2+2,3)/3),10^{2;1;0})&123)>3),{2;4;8})+1,2))
110字元
=TRIM(MID("无 小 中 小中大 小大中大",2*(MMULT(--(COUNTIF(B2:D2,{"<4",">6"})=0),{1;4})+(SUM(-(B2:D2={4;5;6}))=0)*2)+1,2))
108字元
=TRIM(MID("无 小 中 小中大 小大中大",2*MMULT(--(COUNTIF(B2:D2,{"<4",">6"})=0),{1;4})+4*(SUM(-(B2:D2={4;5;6}))=0)+1,2))
106字元
=TRIM(MID("无 小 中 小中大 小大中大",MMULT(--(COUNTIF(B2:D2,{"<4",">6"})=0),{2;8})+4*(SUM(-(B2:D2={4;5;6}))=0)+1,2))
105字元
=TRIM(MID("无 小 中 小中大 小大中大",MMULT(N(COUNTIF(B2:D2,{"<4",">6"})=0),{2;8})+4*(SUM(-(B2:D2={4;5;6}))=0)+1,2))
[ 本帖最后由 piny 于 2010-8-30 19:20 编辑 ] |