Formula

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

TIA

 

[Guest]

Hi Kiran,

This UDF gives the requested results, but watch out: it isn't clear wether
you gave all possible cases. The rules are not known, the results are given
by experience!

Public Function BOoutput(acol As String, bcol As String, ccol As String) As
String
If acol = "NR/Enh" Then
If bcol = "In" Then
BOoutput = "NA"
ElseIf ccol = "Normal" Or ccol = "EC" Then
BOoutput = "YES"
ElseIf ccol = "PI" Then
BOoutput = "NA"
Else
BOoutput = ""
End If
ElseIf acol = "Bug" Then
BOoutput = "NA"
ElseIf acol = "Takeover In" Then
BOoutput = "YES"
Else
BOoutput = ""
End If
End Function

Place it in a normal module, enter =BOoutput(A2,B2,C2) in cell D2 and fill
it down!

Regards,
Stefi

„kiran†ezt írta:

 

[Guest]

Dear Stefi,
Thanks for that can you help me how to run this program and use it

 

[Guest]

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

 

[Guest]

Hi Kiran,

First create a module: Tools->Macros->Visual Basic (or Alt-F11)
Right-click on VBAProject(your
filename)->Insert->Module
Paste here the code

In cell D2 enter: =BOoutput(A2,B2,C2)
Fill it down as necessary!

Nevertheless I agree with Eric, knowing the rules would be better!

Reegards,
Stefi



„kiran†ezt írta:

 

[Guest]

Thanks Thanks a lot Stefi ...

Hi Kiran,

First create a module: Tools->Macros->Visual Basic (or Alt-F11)
Right-click on VBAProject(your
filename)->Insert->Module
Paste here the code

In cell D2 enter: =BOoutput(A2,B2,C2)
Fill it down as necessary!

Nevertheless I agree with Eric, knowing the rules would be better!

Reegards,
Stefi



„kiran†ezt írta: