如果在AND中用AND或OR进行其他处理

debugcn 发表于 Dev

路易斯

我有以下格式的Excel数据：

severity    Type    Overview    Classification  Result
critical    defect  closed      Fix             Good
serious     enhance no change   no fix          Low
Medium      defect  no change   no fix          Low
Low         enhance closed      fix             Poor
critical    defect  Duplicate   fix             Good
Medium      defect  Duplicate   fix             Low
Low         defect  Duplicate                   Poor

我已经写了公式来计算结果，但是由于我在excel中的不良知识，我无法执行。任何帮助，将不胜感激。

条件如下：

 Severity           Type               Overview     Classifcation       Result
Citical/Serious     Defect/Enhance      Closed          Fix                 Good
                    Defect/Enhance      Closed          No fix              Poor
                    Defect/Enhance      Closed          Updated             Low
                    Defect/Enhance      Duplicate       No fix              poor


Medium/low          Defect/Enhance      closed          No fix              Low
                    Defect/Enhance      Duplicate       No fix              Poor

奥利格

假设您的数据位于范围A1：D8中，其中第一行是标题。您可以使用这个（丑陋的）公式来完成您在条件表中所描述的事情：

=IF(AND(OR(A2="Critical",A2="Serious"),OR(B2="Defect",B2="Enhance")),IF(C2="closed",IF(D2="Fix","Good",IF(D2="No fix","Poor",IF(D2="Updated","Low"))),IF(AND(C2="Duplicate",D2="No"),"poor","No match")),
IF(AND(OR(A2="Medium",A2="Low"),OR(B2="Defect",B2="Enhance")),IF(AND(C2="closed",D2="No fix"),"Low","No match"),IF(AND(C2="duplicate",D2="No fix"),"Poor")))

诀窍是将else条件用作elseif ..，并且当您遇到很多情况时，它真的很难阅读。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。