关于EXCEL中的if函数,两个条件出三个结果

2025-03-23 00:15:03
推荐回答(1个)
回答(1):

=IF(OR(AND(A2="N",B2="Y",C2="A"),AND(A2="N",B2="Y",C2="B"),AND(A2="Y",B2="Y",C2="C")),"结果一",IF(OR(AND(A2="Y",B2="Y",C2="A"),AND(A2="Y",B2="Y",C2="B")),"结果二",""))