Formula For If & Or Condition

[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

[Bryan Hessey]

=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

[Ardus Petus]

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

HTH
--
AP

"anandmr65" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> 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
>

[Ken Johnson]

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

[anandmr65]

tHANKS A LOT FOR THE HELP

REGARDS
ANAND

[Bryan Hessey]

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

[Ken Johnson]

Hi Bryan,

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

Ken Johnson

[Bryan Hessey]

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

--

Hi Bryan,

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

Ken Johnson

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anandmr65" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>