Formula For If & Or Condition

  • Thread starter Thread starter anandmr65
  • Start date Start date
A

anandmr65

Hi,
I am having a column with different values in different cells. I want
to populate the adjacent cell with either blank or a value for
eg."Found". So if the cell has the values "A" or "B" then populate the
adjacent cell with blank else if the values or anything other than "A"
and "B" then populate it with "Found". I tried this formula
IF(E7<>"A",IF(E7<>"B","FOUND","")), but this does not work.
Could somebody help me with this formula.

Thanks & REgards
Anand
 
=IF(AND(E7<>"A",E7<>"B",E7<>""),"found","")

--
Hi,
I am having a column with different values in different cells. I want
to populate the adjacent cell with either blank or a value for
eg."Found". So if the cell has the values "A" or "B" then populate the
adjacent cell with blank else if the values or anything other than "A"
and "B" then populate it with "Found". I tried this formula
IF(E7<>"A",IF(E7<>"B","FOUND","")), but this does not work.
Could somebody help me with this formula.

Thanks & REgards
Anand
Click to expand...
 
Hi Arnand,

The only thing you did wrong was leave out the second condition for the
first IF.
IF(E7<>"A",IF(E7<>"B""FOUND",""),"") works. However, Ardus' solution is
a simpler and easier to follow solution.

Ken Johnson
 
Hi Ken,

unfortunately it reports 'FOUND' for blanks, as does your version, I
would think that where E7 were blank the 'found' should not be
displayed.

Hope this helps

--
 
Hi Bryan,

My "stuff up" frequency with Boolean is very high.
Thanks for helping me monitor it:-/

Ken Johnson
 
Ken,

I can write as badly as anyone, but this was just:

If( cond , 'found' , blank)

where condition was that E7 be not equal to 'A', and not equal to 'B'
and not blank.

I like the simple things, then I can get involved :)

--
 
=IF(AND(E7<>"A",E7<>"B"),"FOUND","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

Help needed 0
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Conditional Formatting help 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula - Is it possible to... 3
if(isna(match formula 8
IF formulas 3
Formula to help with Date funtion 4

Back
Top