EXCEL怎么忽略文字计算公式
怎么忽略E列表中的文字和F列表中的RMB/,然后E*F=G怎么自动计算
可以这样:
G34:
=IF(SUBSTITUTE(E34,"美金:","")="","",ROUND(SUBSTITUTE(E34,"美金:","")*SUBSTITUTE(F34,"RMB/",""),2))
下拉复制即可;
见附图:
实用IFERROR函数=IFERROR(G34,"")
下一篇:高考报名
热门标签:
怎么忽略E列表中的文字和F列表中的RMB/,然后E*F=G怎么自动计算
可以这样:
G34:
=IF(SUBSTITUTE(E34,"美金:","")="","",ROUND(SUBSTITUTE(E34,"美金:","")*SUBSTITUTE(F34,"RMB/",""),2))
下拉复制即可;
见附图:
实用IFERROR函数=IFERROR(G34,"")
下一篇:高考报名