请å¨D4ä¸è¾å
¥å
¬å¼ï¼
=IF(C4="ä¸çº§","40%",IF(C4="è·¨é¨é¨åäº","20%",""))
å
¬å¼è¯´æï¼
å¦æC4å¡«ä¸çº§ï¼åD4æ¾ç¤º40%
å¦æC4å¡«è·¨é¨é¨åäºï¼åD4æ¾ç¤º20%
ä¸æ»¡è¶³ä»¥ä¸ä¸¤ä¸ªæ¡ä»¶æ¶ï¼D4æ¾ç¤ºä¸ºç©ºã
注æï¼
ä½ çé®é¢ä¸å¯è½åéåäºï¼å°åºæ¯ è·¨é¨ä»¬åäº è¿æ¯è·¨é¨é¨åäºï¼å°åºæ¯ä»¬è¿æ¯é¨ï¼ä½ è¦å¼æ¸
æ¥ã
å
¬å¼ä¸ç40%å20%è¦æå¼å·ï¼å¦æä¸æå¼å·ï¼æ¾ç¤ºåºç»ææ¥ä¼åæ0.4å0.2ã
å¦æä¸æå¼å·ï¼éè¦è®¾ç½®åå
æ ¼æ ¼å¼ä¸ºç¾åæ¯æ ¼å¼ï¼æä¼æ¾ç¤ºä¸º40%å20%
温馨提示:答案为网友推荐,仅供参考