函数如下：
=IF(AND(I3="专业课",H3<=29),0.9,IF(AND(I3="专业课",H3<=58),1,IF(AND(I3="专业课",H3<=68),1.02,IF(AND(I3="专业课",H3<=78),1.04,IF(AND(I3="专业课",H3<=88),1.06,IF(AND(I3="专业课",H3<=98),1.07,IF(AND(I3="专业课",H3<=108),1.08)))))))
如图，红框为函数单元格，要求先判断班级类和人数，才能出来最终的系数。所以用if(and()),但是再往下写就会出错，原因为if嵌套超过7个，因为除了专业课还有别的分类，如选修课、体育课等等，请问该用哪个函数，

switch

=IF(I3="专业课",LOOKUP(H3,{0;30;59;69;79;89;99},{0.9;1;1.02;1.04;1.06;1.07;1.08}))

继续用if。但要调整下顺序