=IF(D10="男",IF(G10=0,0,IF(G10<INDEX(评分标准!$C$7:$G$42,MATCH(F10,评分标准!$B$7:$B$42),1),"下",IF(G10<=INDEX(评分标准!$C$7:$G$42,MATCH(F10,评分标准!$B$7:$B$42),2),"中下",IF(G10<=INDEX(评分标准!$C$7:$G$42,MATCH(F10,评分标准!$B$7:$B$42),3),"中",IF(G10<=INDEX(评分标准!$C$7:$G$42,MATCH(F10,评分标准!$B$7:$B$42),4),"中上",IF(G10>=INDEX(评分标准!$C$7:$G$42,MATCH(F10,评分标准!$B$7:$B$42),5),"上")))))),IF(D10="女",IF(G10=0,0,IF(G10<INDEX(评分标准!$C$50:$G$85,MATCH(F10,评分标准!$B$50:$B$85),1),"下",IF(G10<=INDEX(评分标准!$C$50:$G$85,MATCH(F10,评分标准!$B$50:$B$85),2),"中下",IF(G10<=INDEX(评分标准!$C$50:$G$85,MATCH(F10,评分标准!$B$50:$B$85),3),"中",IF(G10<=INDEX(评分标准!$C$50:$G$85,MATCH(F10,评分标准!$B$50:$B$85),4),"中上",IF(G10>=INDEX(评分标准!$C$50:$G$85,MATCH(F10,评分标准!$B$50:$B$85),5),"上"))))))
因为我是初学者!请问怎样用if()的两种情况,分段?能帮我写出来吗?还有怎样用lookup()?谢谢!
追答另存一下,删掉敏感信息(姓名、电话、账号。。。),传文件好分析。联系方式 见我的个人信息
请问怎样用呢?能帮我写出来吗?谢谢!