Kiran,

If you tell us what the rules for BO Approval are, we could probably provide
a formula that would do it without using Visual Basic.

Eric


"kiran" wrote:

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 NA
NR/Enh Out EC YES
Bug In Normal NA
Bug Out Normal NA
Takeover In Normal YES YES

TIA