是同时为空,还是只要一个为空就显示缺货?同时为空=if(A1&B1&C1="","缺货","")只要一个为空=if(or(A1="",B1="",C1=""),"缺货","")
d1输入=if(and(a1="",b1="",c1=""),"缺货","")
D1=IF(Trim(A1&B1&C1)="","缺货","")
方便请截图。d1输入以下公式,然后向下填充公式=sum(a1:c1)