本文介绍了Excel嵌套如果参数错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我试图为正相关值编写IF语句.该功能在下面给出.我遇到一个错误，它说了太多的论点.
I was trying to write an IF statement for Positive Correlation values. The function is given below. I am getting an error and it says too many arguments.
=IF(B16 = 1, "Perfect Positive Correlation" ,IF(AND(B16>= 0.9, B16< 1),"Very Strong Correlation" ,IF(AND(B16>=0.7, B16<0.9),"Strong Correlation" ,IF(B16>=0.4,B16<0.7),"Moderate Correlation" ,IF(AND(B16>=0.2, B16 <0.4),"Low Correlation" ,IF(AND(B16>0, B16 <0.2),"Very low Correlation" ,IF(B16 = 0, "No Correlation", "NA")))))))
请帮助.
谢谢
推荐答案
您可以使用具有索引/匹配功能的查找表.
You could use a lookup table with index/match functions.
这篇关于Excel嵌套如果参数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！