excel - 复数中频公式

Question

我正在尝试构建if公式，该公式基本上会重复自身，每个实例上只有2个单元格会更改值。

=IF(AND(J12<50,J12<>””,K12=”Z02”,Q12=”Z3”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z02”,Q12=”Z4”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z05”,Q12=”Z3”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z05”,Q12=”Z4”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z06”,Q12=”Z3”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z06”,Q12=”Z4”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z07”,Q12=”Z3”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z07”,Q12=”Z4”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z08”,Q12=”Z3”),”Repl. Type does not match Planner”,
IF(AND(J12<50,J12<>””,K12=”Z08”,Q12=”Z4”),”Repl. Type does not match Planner”,
""))))))))))

我对此收到 #Name?错误。

有人可以帮忙吗？

Answer 1

=IF(AND(J12<50,J12<>"",K12="Z02",Q12="Z3"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z02",Q12="Z4"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z05",Q12="Z3"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z05",Q12="Z4"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z06",Q12="Z3"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z06",Q12="Z4"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z07",Q12="Z3"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z07",Q12="Z4"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z08",Q12="Z3"),"Repl. Type does not match Planner",IF(AND(J12<50,J12<>"",K12="Z08",Q12="Z4"),"Repl. Type does not match Planner",""))))))))))