Multiple references in IF statement

[L Crites]

I've posted this also in Technet, but have not received a
response. Can anyone help?

I'm trying to use an IF statement to perform a
calculation based on the value in a cell being equal to
any of three values. I have =IF(A2="28819",SUM(E2*-
1),"0") I want to be able to say that if A2="28819"
or "28827" or "27583", sum(E2*-1),"0") but it won't
allow me to do or. I've used In() in Access, but it
won't work in Excel either. Any ideas?

 

[Peo Sjoblom]

One way

=IF(OR(A2={28819;28827;27583}),E2*-1,0)

note that the sum function is redundant in this case

 

[Hoang Han]

Try it:
if(or(or(A2="28819",A2="28827"),A2="27583"),sum(E2*-
1),"0")

 

[Biff]

Hi L,

Try this:

=IF(OR(A2=28819,A2=28827,A2=27583),E2*-1,0)

Biff

 

[L Crites]

Thanks a bunch! I appreciate it. This has been bugging
me for a month!
L