Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have three statements:


But I want to do


how could this be accomplished in Excel?

or could I instead nest these two (which I have tried, but had no luck)

share|improve this question

migrated from Jun 22 '12 at 18:44

This question came from our site for professional and enthusiast programmers.

Not a programming question. Should be asked at Super User – brettdj Jun 21 '12 at 10:18
up vote 0 down vote accepted

Your question is not very clear, but that would include an or condition in the if statement:


note: in Excel2003, I am not sure that OR can take more than 2 arguments, in which case you can do OR(OR(x,y),z)

share|improve this answer

To shorten the formula you could use this version


....or even shorter using COUNT but it needs to be "array entered"

=IF(COUNT(SEARCH($ET$2:$ET$4,B2)),"","NA ")&B2

share|improve this answer

Not very readable, but:


should do it.

share|improve this answer

You must log in to answer this question.