我知道出现这个“#DIV/0!”是由于数组中某些某些数把0做为了除数,在一个数组中这是难免的,但是这样就使得数出结果很难看,如何让这个东东不显示呢?
#DIV/0é误å¼
该é误å¼ä¸è¬æ¯ç±å
¬å¼çè¿ç®äº§çï¼å设æ°æ®æ¯éè¿åå
¬å¼äº§çï¼
åå
¬å¼ï¼
=A1/B1
ç°ä¿®æ¹ä¸ºï¼
=IF(COUNT(A1/B1),A1/B1,"")
æï¼
=IF(ISNUMBER(A1/B1),A1/B1,"")
åæï¼
=IF(ISERR(A1/B1),"",A1/B1)
å¦æç¨çæ¯EXCEL 2003以ä¸ççæ¬ï¼å
¬å¼ç²¾ç®äºï¼
=IFERROR(A1/B1,"")
åµå¥ä¸ä¸ªIFå½æ°å¨å¤é¢å°±è¡äºï¼
å设åæ¥çå ¬å¼æ¯ï¼
=IRR(A1:A2,-10%)
åä¿®æ¹ä¸ºï¼
=IF(ISERR(IRR(A1:A2,-10%)),"",IRR(A1:A2,-10%))
å¦æç¨çæ¯EXCEL 2003以ä¸ççæ¬ï¼å
¬å¼ç²¾ç®äºï¼
=IFERROR(IRR(A1:A2,-10%),"")