Question

EXCEL中的IF和AND OR怎么用?

Answer 1

注：以下公式输入完成后,一定要ctrl+shift+enter确定才能生效

"不符合条件"可以修改为任意值,如果单独的""表示一个空格,

D1=IF(OR(A1:C1=0,A1:C1=5),0,"不符合条件")

E1=IF(OR(A1:C1=1,A1:C1=6),1,"不符合条件")

F1=IF(OR(A1:C1=2,A1:C1=7),2,"不符合条件")

G1=IF(OR(A1:C1=3,A1:C1=8),3,"不符合条件")

H1=IF(OR(A1:C1=0,A1:C1=5),4,"不符合条件")