Formula
 

Dear All,
I want my out put to be as follows can any one help me on this
it should check the condition A,B,C & out put in D as follows
A B C
D
Change Request Status Change Type BO Approval
NR/Enh In Normal NA
NR/Enh Out Normal YES
NR/Enh In PI NA
NR/Enh Out PI NA
NR/Enh In EC YES
NR/Enh Out EC YES
Bug In Normal NA
Bug Out Normal NA
Takeover In Normal YES

TIA

Guessing

=IF(A2="NR Enh",IF(B2="In","NA","Yes"),"NA")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kiran" wrote in message
...
Dear All,
I want my out put to be as follows can any one help me on this
it should check the condition A,B,C & out put in D as follows
A B C
D
Change Request Status Change Type BO Approval
NR/Enh In Normal NA
NR/Enh Out Normal YES
NR/Enh In PI NA
NR/Enh Out PI NA
NR/Enh In EC YES
NR/Enh Out EC YES
Bug In Normal NA
Bug Out Normal NA
Takeover In Normal YES

TIA