Question

excel你为此函数输入的参数太多

=IF(E3=6,"自我""新潮",IF(AND(E3>=4,E3<=5),"自我"),IF(AND(E3>=7,E3<=8),"中庸""自我""新潮"),IF(E3=9,"新潮""暖男""中庸",IF(E3=10,"暖男""中庸""新潮",IF(E3=11,"中庸""暖男",IF(E3>12,"暖男"))))))

Answer 1

你这样写肯定不对，你要表达的是什么意思？

如果带风险通过，但是C112=0，就显示通过，不然就是带风险通过么？

C112=0和前面几个条件是并列还是什么关系。

是想表达这么意思么=IF(AND(C113>11,C114>20,C115>11,C112/C111>60%),"不通过",IF(C112=0,"通过","带风险通过"))

Answer 2

修改公式为：
=IF(E3<=5,"自我",IF(E3=6,"自我新潮",IF(E3<=8,"中庸自我新潮",IF(E3=9,"新潮暖男中庸",IF(E3=10,"暖男中庸新潮",IF(E3=11,"中庸暖男","暖男"))))))
或用公式：
=LOOKUP(E3,{4,6,7,9,10,11,12},{"自我","自我新潮","中庸自我新潮","新潮暖男中庸","暖男中庸新潮","中庸暖男","暖男"})