Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top