æ¬ç¯å°ä½¿ç¨
IFå½æ°å¤æåå
æ ¼æ¯å¦ä¸ºç©ºæ¥è§£å³ä¹åä¾åæçä¸çé®é¢ãè¦æ³çææ¬ç¯å¯è½éè¦å
å»çä¸ä¹åçå ç¯æç« ï¼æ¯ç«ç¯å¹
æéï¼ä¸å¯è½ä¸ä¸å°±è¯´å®ææä¸è¥¿ã
0Excelä¸ä½¿ç¨é»è¾IFå½æ°å¤ææ绩æ¯å¦åæ ¼0Excelä¸ä½¿ç¨
VLOOKUPå½æ°æ¥è¯¢å¦çä¿¡æ¯0Excelä¸å¯ä»¥ä½¿ç¨IFERRORå½æ°è®¾ç½®åºéæé
å·¥å
·/åæ
Office Excel2013çæ¬
æ¹æ³/æ¥éª¤
1
å¨ä¹åçIFERRORå½æ°ä½¿ç¨çä¾åè¿åï¼åæäºæ°çé®é¢ï¼å½
å¦å·ä¸ºç©ºï¼ä¸æ¥è¯¢æ¶ï¼ä¹æ¾ç¤ºâ没æè¿ä¸ªå¦å·âï¼è®©ä¸æ¯è®¾è®¡äºè¡¨æ ¼ç人çäºå¤´ä¸åºç°é®å·ã
为解å³è¿ä¸ªé®é¢ï¼æ们å¯ä»¥ä½¿ç¨IFå½æ°æ¥å¤æåå
æ ¼æ¯å¦ä¸ºç©ºï¼ä¸ºç©ºçè¯ï¼è¿å空å¼ï¼ä¸ä¸ºç©ºï¼åå»æ§è¡IFRRORå½æ°ã
2
æ们åå¨åæ¥å½æ°çåºç¡ä¸
å¥å¨ââæå¤å±ä½¿ç¨IFå½æ°åµå¥ã
å
¶å®å¾ç®åï¼ä½¿ç¨C3=""使ç¨æ¡ä»¶å¤æC3åå
æ ¼æ¯å¦ä¸ºç©ºï¼ä¸ºç©ºå°±è¿åââ空å¼ï¼ä¸ä¸ºç©ºåå»æ§è¡ä¹åIFERRORå½æ°ã
å
¬å¼å¦ä¸
=IF(C3="","",IFERROR(VLOOKUP($C$3,$E$2:$K$12,2,0),"没æè¿ä¸ªå¦å·"))
3
å®æä¹åï¼å¯ä»¥çå°ï¼å½å¦å·ä¸ºç©ºæ¶ï¼å®ä¸ä¼æ示任ä½é误信æ¯ã
4
èå½è¾å
¥æ£ç¡®å¦å·æ¶ï¼å®ä¹è½è·åæ£ç¡®çæ°æ®ã
5
å½è¾å
¥é误çå¦å·æ¶ï¼å®åæ¯ä¼æ示ã没æè¿ä¸ªå¦å·ãå¦å·çä¸å产çäºä¸åçç»æï¼è¿è®¾è®¡ææ¯åççã
6
å¨å½æ°çåµå¥ä¸å¤§å®¶è¦è®°ä½ææ符å·ä¸è¦ç¨
ä¸æ符å·ï¼å¹¶ä¸è®°å¾æ¯ä¸ä¸ªå½æ°çååæ¬å·è¦è¡¥å
**ã