Formula

[kiran]

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

[Bob Phillips]

Guessing

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

--

HTH

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


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