excel怎么设置自动减法

更新时间2021-07-20 04:59:09

比如一盒十包，库存5盒1包，卖出3包，剩余4盒8包这种excel可以自动减吗

J3=IF(E3&G3="","",TEXT(INT(IF(J2="",0,J2)-E3+(IF(K2="",0,K2)-G3)/10),"0;;;!0"))

K3=IF(E3&G3="","",TEXT(RIGHT((IF(J2="",0,J2)-E3)*10+IF(K2="",0,K2)-G3,1),"0;;;!0"))

公式下拉足够远，只填E、G列就可以自动减