是这样。我这边的问题大概是上面的都是库存数量小于需发数量的,主要根据品项变化而变化单元格内容。
都是基于E2增加的,
到了7品的判断公式是
=IF(A16="","",A16&IF(C16=0,"无货","发"&B16&"有"&C16))&"."&IF(A17="","",A17&IF(C17=0,"无货","发"&B17&"有"&C17))&"."&IF(A18="","",A18&IF(C18=0,"无货","发"&B18&"有"&C18))&"."&IF(A19="","",A19&IF(C19=0,"无货","发"&B19&"有"&C19))&"."&IF(A20="","",A20&IF(C20=0,"无货","发"&B20&"有"&C20))&"."&IF(A21="","",A21&IF(C21=0,"无货","发"&B21&"有"&C21))&"."&IF(A22="","",A22&IF(C22=0,"无货"&TEXT(D22,"【mm-dd】"),"发"&B22&"有"&C22&TEXT(D22,"【mm-dd】")))
能不能优化下函数?谢谢大佬啦。