é£æ¯
ORå½æ°æ²¡æä½ç¨ã
IFå½æ°è¿æ¯ä¼éå°é误å¼ï¼ä»èç»æè¿åé误å¼ã
建议å
¬å¼æ¹ä¸º:
=IFERROR(IF((I4-'13ç§æ»è®¢å'!U4)=0,"",(I4-'13ç§æ»è®¢å'!U4)),"")
å¦æä¸è½ç¨IFERRORå½æ°ï¼å°±æ¹æï¼
=IF(ISERROR(IF((I4-'13ç§æ»è®¢å'!U4)=0,"",(I4-'13ç§æ»è®¢å'!U4))),"",IF((I4-'13ç§æ»è®¢å'!U4)=0,"",(I4-'13ç§æ»è®¢å'!U4)))