software

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.quot;Foundquot;. So if the cell has the values quot;Aquot; or quot;Bquot; then populate the
adjacent cell with blank else if the values or anything other than quot;Aquot;
and quot;Bquot; then populate it with quot;Foundquot;. I tried this formula
IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;,quot;FOUNDquot;,quot;quot;)), but this does not work.
Could somebody help me with this formula.

Thanks amp; REgards
Anand--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: www.excelforum.com/member.php...oamp;userid=30728
View this thread: www.excelforum.com/showthread...hreadid=533366=IF(OR(E7=quot;Aquot;;E7=quot;Bquot;);quot;quot;;quot;FOUNDquot;)

HTH
--
AP

quot;anandmr65quot; gt; a écrit
dans le message de
...
gt;
gt; Hi,
gt; I am having a column with different values in different cells. I want
gt; to populate the adjacent cell with either blank or a value for
gt; eg.quot;Foundquot;. So if the cell has the values quot;Aquot; or quot;Bquot; then populate the
gt; adjacent cell with blank else if the values or anything other than quot;Aquot;
gt; and quot;Bquot; then populate it with quot;Foundquot;. I tried this formula
gt; IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;,quot;FOUNDquot;,quot;quot;)), but this does not work.
gt; Could somebody help me with this formula.
gt;
gt; Thanks amp; REgards
gt; Anand
gt;
gt;
gt; --
gt; anandmr65
gt; ------------------------------------------------------------------------
gt; anandmr65's Profile:
www.excelforum.com/member.php...oamp;userid=30728
gt; View this thread: www.excelforum.com/showthread...hreadid=533366
gt;

=IF(AND(E7lt;gt;quot;Aquot;,E7lt;gt;quot;Bquot;,E7lt;gt;quot;quot;),quot;foundquot;,quot;quot;)

--

anandmr65 Wrote:
gt; Hi,
gt; I am having a column with different values in different cells. I want
gt; to populate the adjacent cell with either blank or a value for
gt; eg.quot;Foundquot;. So if the cell has the values quot;Aquot; or quot;Bquot; then populate the
gt; adjacent cell with blank else if the values or anything other than quot;Aquot;
gt; and quot;Bquot; then populate it with quot;Foundquot;. I tried this formula
gt; IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;,quot;FOUNDquot;,quot;quot;)), but this does not work.
gt; Could somebody help me with this formula.
gt;
gt; Thanks amp; REgards
gt; Anand--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533366Hi Arnand,

The only thing you did wrong was leave out the second condition for the
first IF.
IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;quot;FOUNDquot;,quot;quot;),quot;quot;) works. However, Ardus' solution is
a simpler and easier to follow solution.

Ken Johnson
tHANKS A LOT FOR THE HELP

REGARDS
ANAND--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: www.excelforum.com/member.php...oamp;userid=30728
View this thread: www.excelforum.com/showthread...hreadid=533366
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:
gt; Hi Arnand,
gt;
gt; The only thing you did wrong was leave out the second condition for
gt; the
gt; first IF.
gt; IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;quot;FOUNDquot;,quot;quot;),quot;quot;) works. However, Ardus' solution
gt; is
gt; a simpler and easier to follow solution.
gt;
gt; Ken Johnson--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533366Hi Bryan,

My quot;stuff upquot; 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

--

Ken Johnson Wrote:
gt; Hi Bryan,
gt;
gt; My quot;stuff upquot; frequency with Boolean is very high.
gt; Thanks for helping me monitor it:-/
gt;
gt; Ken Johnson--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533366=IF(AND(E7lt;gt;quot;Aquot;,E7lt;gt;quot;Bquot;),quot;FOUNDquot;,quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;anandmr65quot; gt; wrote
in message ...
gt;
gt; Hi,
gt; I am having a column with different values in different cells. I want
gt; to populate the adjacent cell with either blank or a value for
gt; eg.quot;Foundquot;. So if the cell has the values quot;Aquot; or quot;Bquot; then populate the
gt; adjacent cell with blank else if the values or anything other than quot;Aquot;
gt; and quot;Bquot; then populate it with quot;Foundquot;. I tried this formula
gt; IF(E7lt;gt;quot;Aquot;,IF(E7lt;gt;quot;Bquot;,quot;FOUNDquot;,quot;quot;)), but this does not work.
gt; Could somebody help me with this formula.
gt;
gt; Thanks amp; REgards
gt; Anand
gt;
gt;
gt; --
gt; anandmr65
gt; ------------------------------------------------------------------------
gt; anandmr65's Profile:
www.excelforum.com/member.php...oamp;userid=30728
gt; View this thread: www.excelforum.com/showthread...hreadid=533366
gt;