é¢ç®ä¸æ¯ä¸æ¯åéäºï¼é¤Bæ¯4Mï¼å ¶ä½å ¨æ¯2Mçï¼ç°æ¹ä¸ºA=2MãB=4MãC=6MãD=8Mã
=IF(C2="","",MATCH(C2,{"A","B","C","D"})*2&"M")
å¦æé¢ææ¯æ²¡éçï¼å ¬å¼åæ¹ä¸ºè¿æ ·ï¼
=IF(C2="","",IF(C2="B","4M","2M"))
æææä»¶ä¼ ä¸æ¥ï¼è¯·ç¹å»è¿åçå³ä¸è§ç»¿è²çâç¹å»ä¸è½½âæé®ï¼ä¸è½½æ件ççææã
é常æè°¢æ¨çæç¹ï¼åæè¯äºä¸ä¸å¯ä»¥å¦~
è½å¦å追é®ä¸ä¸ï¼
å¦æ Cåæ¾ç¤º"A" å¨Dåæ¾ç¤º"1M"
Cåæ¾ç¤º"B" å¨Dåæ¾ç¤º"4M"
Cåæ¾ç¤º"C" å¨Dåæ¾ç¤º"2M"
Cåæ¾ç¤º"D" å¨Dåæ¾ç¤º"3M"
è¿ç§æ
åµæ¯å¦ä½è®¾ç½®å¢ï¼ ä¸æ¯ifããããor notããåçåååºè¯¥å¦ä½è®¾ç½®å¢ ï¼
以ä¸çå
¬å¼æ¹ä¸ºè¿æ ·å°±è¡äºï¼
=IF(C2="","",MATCH(C2,{"A","C","D","B"},)&"M")
å¦æä¸å®è¦ç¨IFå½æ°æ¥åï¼å
¬å¼å为è¿æ ·ï¼
=IF(C2="A",1,IF(C2="B",4,IF(C2="C",2,IF(C2="D",3))))&"M"
è¿å¯ä»¥è¿æ ·åï¼
=IF(C2="","",MAX(({"A";"C";"D";"B"}=C2)*{1;2;3;4})&"M")