Formula For If & Or Condition
 

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


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

=IF(OR(E7="A";E7="B");"";"FOUND")

HTH
--
AP

"anandmr65" a écrit
dans le message de
...

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


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

=IF(AND(E7<"A",E7<"B",E7<""),"found","")

--

anandmr65 Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

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

Formula For If & Or Condition
 

tHANKS A LOT FOR THE HELP

REGARDS
ANAND


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

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

--

Ken Johnson Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

Hi Bryan,

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

Ken Johnson

Formula For If & Or Condition
 

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 :)

--

Ken Johnson Wrote:
Hi Bryan,

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

Ken Johnson


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533366

Formula For If & Or Condition
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anandmr65" wrote
in message ...

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


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=533366