excel怎么设置自动减法
比如一盒十包,库存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列就可以自动减
相关标签:excel
热门标签: