EXCEL怎么用函数查找同时满足
公式如下:
=IF(OR(E2="",F2=""),"",IF(AND(E2="JG22-30",F2=2。5),"I型",IF(AND(E2="JG22-30",F2=3。5),"Ⅱ型",IF(AND(E2="JG22-30",F2=4。 5),"Ⅲ型",IF(AND(E2="JG22-33",F2=3。5),"Ⅱ型",IF(AND(E2="JG22-33",F2=5。5),"Ⅲ型",))))))
请看附件。
公式如下:
=IF(OR(E2="",F2=""),"",IF(AND(E2="JG22-30",F2=2。5),"I型",IF(AND(E2="JG22-30",F2=3。5),"Ⅱ型",IF(AND(E2="JG22-30",F2=4。
5),"Ⅲ型",IF(AND(E2="JG22-33",F2=3。5),"Ⅱ型",IF(AND(E2="JG22-33",F2=5。5),"Ⅲ型",))))))
请看附件。收起