excel中A列为供货商,B列为客户,A列有数据,C列显示进货,B列有数据,C列显示出货,函数怎么表达?谢谢

2025-03-11 09:39:37
推荐回答(2个)
回答1:

C2公式下拉:

=IF(A2="","出货","进货")

或者:

=IF(B2="","进货","出货")

以下公式加入当A列与B列同时为空白时,公式也返回空白:

=IF(A2&B2="","",IF(A2="","出货","进货"))

回答2:

=if(isblank(a1),"出货","进货")