你要的公式可以写成
=IF(OR(A1=A2,A2=A3),IF(B2="某值1","A",IF(B2="某值2","B","")),IF(B2="某值1","C",IF(B2="某值2","D","")))
或
=IF(OR(A1=A2,A2=A3),IF(B2="某值1","A","B"),IF(B2="某值1","C","D"))
不明白你的意思呀，有心无力，你把文件或搞个图片出嘛，
=IF(A1=A2,IF(B2="某值","1","2"),IF(A2=A3,IF(B2="某值","1","2"),2))
你要用什么语言输出
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024