表格计算时如果其中一个为空值则返回结果也为空

2025-04-07 06:13:58
推荐回答(1个)
回答1:

在C2中输入或复制粘贴下列公式
=IF(OR(A2="",B2=""),"",A2-B2)

=IF(OR(A2=0,B2=0),"",A2-B2)

=IF(AND(A2<>"",B2<>""),A2-B2,"")

=IF(COUNTBLANK(A2:B2)=0,A2-B2,"")

=IF(COUNTBLANK(A2:B2)>0,"",A2-B2)
下拉填充