可用if函数的嵌套
=IF(A1=B1,IF(C1=D1,"B","A"),IF(C1=D1,"C","D"))
意思为:
1、如果A1=B1,那么就看C1和D1是否相等,若C1=D1,则值为B,若C1<>D1,则值为B。否则返为IF(C1=D1,"C","D"),即A1<>B1的情况下:如果若C1=D1,则值为C,若C1<>D1,则值为D。
或者公式为:
=IF(AND(A1=B1,C1<>D1),"A",IF(AND(A1=B1,C1=D1),"B",IF(AND(A1<>B1,C1=D1),"C","D")))
都可以。
温馨提示:答案为网友推荐,仅供参考