Multiple references in IF statement

L

Liz Crites

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?
 
G

Guest

Not sure i understand. Try this and see if it works:

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

Johnb3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple references in IF statement 4
Page numbering with Merged Document and IF statements 1
Same forumula returns both 0 & N/A 2
Insert columns and values programmatically with IF statement 9
Sum of values in column A based on 0/1 of column B 2
Conditional sum, when condition has multiple values 3
HELP! I need to make an IF Statement comparing date/time fields.. 2
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1

Top