Need some help with OR function

[Sean15]

Hi:

I want Excel to return 0 if value in A2 is equal to 1310 or 1425 or 6756, if not return value in F2. This formula is returning error #value.

IF(OR(A2=1310, A2=1425, A2=6756,””),F2)

Could you help please?

Regards,

Sean

 

[Fluff]

Try
=IF(OR(A2={1310,1425,6756}),0,F2)

 

[mumps]

Maybe: =IF(OR(A2=1310, A2=1425, A2=6756),"",F2)

 

[Scott Huish]

Also:
=F2*AND(A2<>{1310,1425,6756})

 

[Sean15]

Man I am careless.

Thank you very much.

Sean

 

[Fluff]

You're welcome & thanks for the feedback