还是我,哈哈 =IF(E3=0,"",F3-E3+C3) 如果F3,C3,E3有任意一个数据为空,就不显示结果,改怎样改公式?

2025-01-24 06:37:17
推荐回答(2个)
回答1:

=IF(OR(E3="",C3="",F3=""),"",F3-E3+C3)

回答2:

套哪儿呢?出错显示空白?IFERROR(IF(((E3=N3)*(D3=K3)*((J3=03)*(O3=0))),"相等","不相等"),"")