本帖最后由 lijian8003 于 2015-2-24 05:12 编辑
下述4个条件,有且仅有1个正确,
当条件1正确时,则在单元格M5写入="0="&G5
当条件2正确时,则在单元格M5写入="1="&G5
当条件3正确时,则在单元格M5写入="2="&G5
当条件4正确时,则在单元格M5写入="3="&G5
如何将下述4个公式合并成一个,进行选择判断?
=IF(COUNT(MATCH(--MID(G4,ROW(INDIRECT("1:"&LEN(G4))),1),$C4:$E4,0))=0,"0="&G5)
=IF(COUNT(MATCH(--MID(G4,ROW(INDIRECT("1:"&LEN(G4))),1),$C4:$E4,0))=1,"1="&G5)
=IF(COUNT(MATCH(--MID(G4,ROW(INDIRECT("1:"&LEN(G4))),1),$C4:$E4,0))=2,"2="&G5)
=IF(COUNT(MATCH(--MID(G4,ROW(INDIRECT("1:"&LEN(G4))),1),$C4:$E4,0))=3,"3="&G5)
=COUNT(MATCH(--MID(G4,ROW(INDIRECT("1:"&LEN(G4))),1),$C4:$E4,0))&"="&G4
数组
|