software

Hi,

I have the following (partial list) on column A

A1: Count(R14_completeness_BAL_AMT)
A2: Count(R500_consistency_BAL_LIMIT_AMOUNT)
A3: Count(R501_conformity_LIMIT_AMT)
A4: Count(R127_integrity_AVAIL_BAL_AMT_BAL_AMT)
A5: Count(R538_accuracy_srce_sys)
etcI would like to have the following quot;ifquot; statement in B1, with the
following 5 conditions:

if A1 contains quot;Completenessquot; then quot;incquot;;
if A1 contains quot;Consistencyquot; then quot;incquot;;
if A1 contains quot;Conformityquot; then quot;nonquot;;
if A1 contains quot;Integrityquot; then quot;badquot;;
if A1 contains quot;Accuracyquot; then quot;inaquot;;

Thanks!--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=526116
Try the following:
I used an quot;IF/ORquot; because you have 2 conditions which can equal quot;incquot;
The last item quot;CHECKquot; can be anything you want, this will quot;flagquot; you if
your cell contains anything other than the 5 conditions.
=IF(OR(A1=quot;Completenessquot;,A1=quot;Consistencyquot;),quot;Incquot;,I F(A1=quot;Integrityquot;,quot;badquot;,IF(A1=quot;Accuracyquot;,quot;inaquot;,IF(A 1=quot;Conformityquot;,quot;nonquot;,quot;Checkquot;))))--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=526116Are these literal strings in A1:A5 or part of formulas.

If literal strings, then look at the Search function in Excel VBA help.

But if you have more than 5 strings you are looking for, it might be better
to create a contingency table and use a lookup formula.

However, since it isn't clear what you actually have, it would be better if
your clarify.

--
Regards,
Tom Ogilvyquot;Portugaquot; wrote:

gt;
gt; Hi,
gt;
gt; I have the following (partial list) on column A
gt;
gt; A1: Count(R14_completeness_BAL_AMT)
gt; A2: Count(R500_consistency_BAL_LIMIT_AMOUNT)
gt; A3: Count(R501_conformity_LIMIT_AMT)
gt; A4: Count(R127_integrity_AVAIL_BAL_AMT_BAL_AMT)
gt; A5: Count(R538_accuracy_srce_sys)
gt; etc
gt;
gt;
gt; I would like to have the following quot;ifquot; statement in B1, with the
gt; following 5 conditions:
gt;
gt; if A1 contains quot;Completenessquot; then quot;incquot;;
gt; if A1 contains quot;Consistencyquot; then quot;incquot;;
gt; if A1 contains quot;Conformityquot; then quot;nonquot;;
gt; if A1 contains quot;Integrityquot; then quot;badquot;;
gt; if A1 contains quot;Accuracyquot; then quot;inaquot;;
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; Portuga
gt; ------------------------------------------------------------------------
gt; Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
gt; View this thread: www.excelforum.com/showthread...hreadid=526116
gt;
gt;