EXCEL条件语句AND和OR函数同时应用

Question

单元格A1,B1,C1，D1
当A1=白色时，
且B1=无卤或者C1=BBD时，
单元格D1=WP,否则=空值。

注意：只要满足A1=白色，B1和C1满足一个即可

Answer 1

=IF（or(and(a1="白色",b1="无卤"）,c1="BBD"),"WP","")
应该这样就可以了

Answer 2

=IF(AND(A1="白色",OR(B1="无卤“,C1=""BBD")),"WP","")本回答被提问者和网友采纳

Answer 3

D1中用公式 =IF(AND(A1="白色",OR(B1="无卤",C1="BBD")),"WP","")

Answer 4

=IF(AND(A1="白色",OR(B1="无卤",C1="BBD")),"WP","")

或者：=IF((A1="白色")*((B1="无卤")+(C1="BBD")),"WP","")

Answer 5

=if (and(A1="白色", or(B1="无卤",C1="BBD")),d1="WP","")