当A11=A/B/C/D时 B11=1
当A11=E/F/G/H时 B11=2
当A11=I/J/K/L时 B11=3
当A11=M/N/O/P时 B11=4
......
经过自己的研究得出正确结果,供大家参考:
B11中输入=IF(OR(A11=A,A11=B,A11=C,A11=D),"1",IF(OR(A11=E,A11=F,A11=G,A11=H),"2",IF(OR(A11=I,A11=J,A11=K,A11=L),"3",IF(OR(A11=M,A11=N,A11=O,A11=P),"4",""))))