EXCEl请高手帮忙优化函数
我还有老七到十二，这样代码太长，请高手优化，谢谢
=IF(AND(I3>=10000,I3<=20000),"老大",IF(AND(I3>20000,I3<=30000),"老二",IF(AND(I3>30000,I3<=40000),"老三",IF(AND(I3>40000,I3<=50000),"老四",IF(AND(I3>50000,I3<=60000),"老五",IF(AND(I3>60000,I3<=70000),"老六",""))))))，
å°±æ¯æ ¹æ®I3çåºé´æ¥å¤æ称å·å§ï¼è¿åºè¯¥ä½¿ç¨VLOOKUPï¼æç®åå个ä¾åä½ ççï¼
=VLOOKUP(I3,{10000,"è大";20000,"èäº";30000,"èä¸"},2)
æ说以ä¸å½æ°çè§å¾ï¼æ¬ä¾ä¸VLOOKUPå½æ°æä¸ä¸ªåæ°ï¼ç¬¬ä¸ä¸ªæ¯I3ï¼æåä¸ä¸ªæ¯2ï¼è¿ä¸¤ä¸ªæ¯åºå®çï¼å ³é®æ¯ä¸é´çåæ°åæ³ï¼
{èµ·ç¹ï¼ç§°å·ï¼.....}
第äºä¸ªåæ°å¿ é¡»ç¨è±æ¬å·æ©èµ·æ¥ï¼ä¸å¯¹èµ·ç¹å称å·ä¹é´ç¨éå·åå¼ï¼å¤å¯¹ä¹é´ç¨åå·ï¼èµ·ç¹è¦ååºæåã
ä½ åå ¬å¼ä¸å¦æéå°é®é¢è¯·è¿½é®ã追é®
=VLOOKUP(I3,{10000,"è大";20000,"èäº";30000,"èä¸"},2)
æ说以ä¸å½æ°çè§å¾ï¼æ¬ä¾ä¸VLOOKUPå½æ°æä¸ä¸ªåæ°ï¼ç¬¬ä¸ä¸ªæ¯I3ï¼æåä¸ä¸ªæ¯2ï¼è¿ä¸¤ä¸ªæ¯åºå®çï¼å ³é®æ¯ä¸é´çåæ°åæ³ï¼
{èµ·ç¹ï¼ç§°å·ï¼.....}
第äºä¸ªåæ°å¿ é¡»ç¨è±æ¬å·æ©èµ·æ¥ï¼ä¸å¯¹èµ·ç¹å称å·ä¹é´ç¨éå·åå¼ï¼å¤å¯¹ä¹é´ç¨åå·ï¼èµ·ç¹è¦ååºæåã
ä½ åå ¬å¼ä¸å¦æéå°é®é¢è¯·è¿½é®ã追é®
谢谢ï¼è¿ä¸ªç®åå¤äºï¼ä¸è¿æä¹åçæ¯æ ¹æ®I3æ¯å¦æå¼èå³å®æ¾ç¤ºï¼ç¨ä½ 们è¿ä¸ªå ¬å¼å°±ä¼æ¾ç¤º#N/Aï¼è¯¥å¦ä½å¤çå¢ï¼
追çå¥ä¸ä¸ªIFERRORå¨å¤é¢ï¼æ ¼å¼ï¼
=IFERROR(VLOOKUP(...),"")
表示æNAæ¾ç¤ºä¸ºç©º
温馨提示：内容为网友见解，仅供参考
第1个回答 2016-09-04
=LOOKUP(I3,{10000,20001,30001,40001},{"老大","老二","老三","老四"})
相似回答
