函数如下：
=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个，因为除了专业课还有别的分类，如选修课、体育课等等，请问该用哪个函数，
=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个，因为除了专业课还有别的分类，如选修课、体育课等等，请问该用哪个函数，
岁月无情
