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


I would like to have the following "if" statement in B1, with the
following 5 conditions:

if A1 contains "Completeness" then "inc";
if A1 contains "Consistency" then "inc";
if A1 contains "Conformity" then "non";
if A1 contains "Integrity" then "bad";
if A1 contains "Accuracy" then "ina";

Thanks!


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=526116