éæ©Båï¼å»ºç«æ¡ä»¶æ ¼å¼ï¼å¹¶å¨è§åä¸è¾å ¥ä»¥ä¸å ¬å¼
=OR(AND(A1="a",B1<>1),AND(A1="b",B1<>2),AND(A1="c",B1<>3))
详è§éå¾
追é®æ¨å¥½ï¼ä¸å¥½ææï¼æ没说æ¸
æ¥ãææ°ä¸æ¡æ°æ®ãææ³æ 示åºæè
æ¾ç¤ºå¨EFåå¦ä¸ï¼
b 2
b 1
c 3
c 1
é常æè°¢ï¼ï¼ï¼