嵌套的IF语句(Nested IF statement)

下面是我的一些研究之后，已经尝试嵌套的IF的但它仅给出了声明，而不是其余的第一部分预期的结果，任何人都可以解释为什么还是我需要不同类型的功能？

=if(h4="basic","basic",if(g17>=500,"Standard",if(h4="standard","Standard",if(g17>=750,"Standard+",if(g17<=500,"Basic",if(h4="Standard+","standard+",If(g17<=750,"Standard",if(g17>=850,"Platinum",if(h4="Platinum","Platinum",if(g17<=850,"Standard+","Platinum"))))))))))

谢谢你的协助。

Answer 1:

你有一个，如果

if(g17>=500

后来你有

if(g17>=750

最后一个条件将永远不会被“满意”，因为如果它实际上是真实的，它不会被用于测试，因为第一if(g17>=500将是True 。

我不知道什么是“预期效果”，“语句的第一部分”，或“剩余”，但希望这有助于。

Answer 2:

你可以试试这个

=IFERROR( INDEX({"basic","Standard","Standard+","Platinum"},MATCH(H4,{"basic","Standard","Standard+","Platinum"},0)),IF(G17>850,"Platinum",IF(G17>750,"Standard+",IF(G17>500,"Standard","Basic"))))

Answer 3:

谢谢你的建议，我不认为我解释我自己太清楚，但与一些建议最终能够解决它在这里完成的公式：

=IF(AND(H4="Basic",G17<450),"Basic",IF(AND(H4="Basic",G17>=450),"Standard",IF(AND(H4="Standard",G17<450),"Basic",IF(AND(H4="Standard",G17>449,G17<700),"Standard",IF(AND(H4="Standard",G17>=700),"Standard+",IF(AND(H4="Standard+",G17>699,G17<800),"Standard+",IF(AND(H4="Standard+",G17<700),"Standard",IF(AND(H4="Standard+",G17>=800),"Platinum",IF(AND(H4="Platinum",G17<800),"Standard+","Platinum")))))))))

文章来源: Nested IF statement