excel怎么设置自动减法5

潮汐_764 |浏览427次
收藏|2021/07/18 21:10

满意回答

2021/07/18 21:36

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列就可以自动减

四分之一桶水

其他回答(0)
0人关注该问题
+1

 加载中...