IF函数连接没有次数限制，IF函数嵌套有次数限制。
IF函数也可用数组，如：
=If(A={条件1,条件2,条件3,条件4,条件5,...},{结果1,结果2,结果3,结果4,结果5,...},)
======================================
继续加“&If(,,)”没有问题
=======================================
=if(>5,if(>10,,if(>9,,if(>8,,if(>7,,if(>6,,))))),if(>4,,if(>3,,if(>2,,if(>1,,)))))
先分段,就可以多几层了,如很多就用其它,vlookup()
如:=IF(A1>5,IF(A1>10,"J",IF(A1>9,"I",IF(A1>8,"H",IF(A1>7,"G",IF(A1>6,"F","E"))))),IF(A1>4,"D",IF(A1>3,"C",IF(A1>2,"B",IF(A1>1,"A",0)))))
内容全部来源于网络收集，如有侵权，请联系网站删除！