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

Question

如题所述

Answer 1

C2公式下拉：

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

或者：

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

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

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

Answer 2

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