If-Statement中的“参数太多”

Question

下面的if语句报告“参数太多”

=IF(AND(G4="Other Revenue",(E4>200000)),("Pass"),IF(AND(G4="Trading Revenue",(E4>200000)),("Pass")),IF(AND(G4="NII",(E4>200000)),("Pass"),("Fail")))

知道为什么吗？

Answer 1

=IF(AND(G4="Other Revenue",E4>200000),"Pass", IF(AND(G4="Trading Revenue",E4>200000),"Pass",IF(AND(G4="NII",E4>200000),"Pass","Fail")))

另外，请不要使用这么多不必要的括号。您不需要在括号中包含简单的字符串表达式...

Answer 2

在第二个"pass“之后有一个额外的括号，这会导致函数提前终止。试着这样做：

=IF(AND(G4="Other Revenue",(E4>200000)),"Pass",IF(AND(G4="Trading Revenue",(E4>200000)),"Pass",IF(AND(G4="NII",(E4>200000)),"Pass","Fail")))

你的公式有问题：

=IF(AND(G4="Other Revenue",(E4>200000)),("Pass"),IF(AND(G4="Trading Revenue",(E4>200000)),("Pass")),IF(AND(G4="NII",(E4>200000)),("Pass"),("Fail")))
                                                                                                  ^
                                                                                                  |
                                                                                              This fella.