excle表格中怎么设置公式,A列数据满足某些条件,然后自动填充到B列,具 ...答:使用IF嵌套即可,公式:=IF(AND(LEFT(A1,1)="1",OR(MID(A1,LEN(A1)-7,2)="H5",MID(A1,LEN(A1)-7,2)="J5")),"CON",IF(AND(LEFT(A1,1)="5",MID(A1,LEN(A1)-6,2)="UL"),"MKC",IF(AND(LEFT(A1,1)="5",MID(A1,LEN(A1)-6,2)="EL"),"NAV",)))效果:...
在excel中,如何利用函数公式将:A列数值中只要满足大于0,就将B列中...答:这个用辅助列可以处理,但一个公式不行。D列做公式,D2: =IF(B2>0,C2," ")E列做公式,E3:=D2&"、"&D3 E4:=E3&"、"&D4,从E4开始下拉 最后提取到一个单元格E9:=IF(RIGHT(SUBSTITUTE(E8," 、",""))=" ",MID(SUBSTITUTE(E8," 、",""),1,LEN(SUBSTITUTE(E8," 、","...