1、IF条件函数只能设置七个条件,需设置十个无法实现;
2、用&连接,数据检测不正确(IF(C7>=0.9,10,IF(C7>=0.89,9,IF(C7>=0.88,8,IF(C7>=0.87,7,IF(C7>=0.86,6,IF(C7>=0.85,5,""))))))&IF(C7>=0.84,4,IF(C7>=0.83,3,IF(C7>=0.82,2,IF(C7>=0.81,1,0)))),公式设置是否错误?
3用LOOKUP设置,数据检测仍不正确LOOKUP(C3,{0,0.81,0.82,0.83,0.84,0.85,0.86,0.87,0.88,0.89,0.9},{0,1,2,3,4,5,6,7,8,9,10})公式设置的也不对吗?
请高手帮忙,急谢谢