MATCH(1,H9:M9)
å¨H9è³M9åå
æ ¼åºåæ¥æ¾å°äºæçäº1çåå
æ ¼å
容å¨ç¬¬å å.å¦å¾ä¸æ¯å¨Jååè¿åå¼ä¸ºç¬¬ä¸åå³3(ä»Håå°Jåæ¯ä¸å)
(3-1)*2=4
=IF(ISNA((MATCH(1,H9:M9)-1)*2),"",MATCH(1,H9:M9)-1)*2
æ´ä¸ªå
¬å¼ææ为å½(MATCH(1,H9:M9)-1)*2)å¾åºçå¼ä¸ºéè¯¯å¼ #N/A(å³å¨H9:M9åå
æ ¼åºåä¸æ¾ä¸å°å¹é
å¼æ¶,å
¬å¼è¿å空å¼åä¹ä»¥2(è¿æ ·å°±å¾åºäº#VALUE!çé误å¼) ,å¦æ(MATCH(1,H9:M9)-1)*2)è¿åå¼ä¸æ¯é误å¼#N/A,åå
¬å¼è®¡ç®MATCH(1,H9:M9)-1çç»æ并ä¹ä»¥2
å
¬å¼æ好æ¹æ
=IF(ISNA((MATCH(1,H9:M9)-1)*2),"",(MATCH(1,H9:M9)-1)*2)
è¿æ ·å°±ä¸ä¼åºç°#VALUE!çé误å¼
æè
æ¹æ
=IF(COUNTIF(H9:M9,1),(MATCH(1,H9:M9)-1)*2,"")
ææ为å¨H9:M9åå
æ ¼åºåæ¥æ¾1,å¦ææ1就计ç®(MATCH(1,H9:M9)-1)*2,没æ1å°±è¿å空å¼
å¦æå°äºçäº1çä¹ç®å¨å
åå
¬å¼åæ
=IF(COUNTIF(H9:M9,"<=1"),(MATCH(1,H9:M9)-1)*2,"")
温馨提示:答案为网友推荐,仅供参考