- ·上一篇：excel表格怎么设随机数
- ·下一篇：excel表格怎么做锯齿状曲线
excel表格预付款怎么做
2024-07-04 10:59:55
1.请大神指教Excel怎么设置?当“发货”“退货”“预付款”为空时,
F2=IF(AND(C2="",D2="",E2=""),"",SUM(E$2:E2)-SUM(C$2:C2)+SUM(D$2:D2))
或者=IF(AND(C2="",D2="",E2=""),"",SUMPRODUCT(E$2:E2+D$2:D2-C$2:C2))
向下复制