A1是数字,B列有NMT,如果当B列是N时,C列等于A1数字加3,B列是M时,C列等于A1加5,B列是T时,C列A1加7
A1是数字,B列有NMT,如果当B列是N时,C列等于A1数字加3,B列是M时,C列等于A1加5,B列是T时,C列A1加7,求公式
赞 xjtu263net 幼苗
共回答了23个问题采纳率：87% 举报
C1公式
=IF(SUM(COUNTIF(B1,{"M","N","T"})),$A$1+LOOKUP(B1,{"M","N","T"},{5,3,7}),"")
或
=IF(B1="N",$A$1+3,IF(B1="M",$A$1+5,IF(B1="T",$A$1+7,"")))
=IF(SUM(COUNTIF(B1,{"M","N","T"})),$A$1+LOOKUP(B1,{"M","N","T"},{5,3,7}),"")
或
=IF(B1="N",$A$1+3,IF(B1="M",$A$1+5,IF(B1="T",$A$1+7,"")))
1年前
1
可能相似的问题
你能帮帮他们吗