A1单元格写入公式
=IF(B1="","",330382020&IF(B1="可控",1,2)&TEXT(ROW(A1),"!200000!0!0"))
或
=IF(B1="","",330382020&IF(B1="可控",1,2)&2&TEXT(ROW(A1),"00000")&"00")
下拉填充公式
你的B列是已知的吧,就是根据B列来生产A列?
系工作表sheet2中
a1=left(sheet1!a1,9)&if(b1="可控",1,2)&"2"&text(row()*100,"0000000")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024