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))&"次退",""))
Excel如何设置进退货次数自动提醒
时间：2024-11-18 13:23:481、打开文档
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))&"次退",""))