Excel如何设置进退货次数自动提醒
1、打开文档
3、输入公式输入公式：=IF(C2>0,"第"&SUM(($A$2:A2=A2)*($C$2:潮贾篡绐C2>0))&"次进",IF(C2<0,"第"&SUM(($A$2:A2=A2)*($C$2:C2<0))&"次退",""))
1、打开文档
3、输入公式输入公式：=IF(C2>0,"第"&SUM(($A$2:A2=A2)*($C$2:潮贾篡绐C2>0))&"次进",IF(C2<0,"第"&SUM(($A$2:A2=A2)*($C$2:C2<0))&"次退",""))