| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 NA NR/Enh Out EC YES Bug In Normal NA Bug Out Normal NA Takeover In Normal YES YES TIA |
|
#2
|
|||
|
|||
|
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: 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 |
|
#3
|
|||
|
|||
|
Dear Stefi,
Thanks for that can you help me how to run this program and use it "Stefi" wrote: 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: 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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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: Dear Stefi, Thanks for that can you help me how to run this program and use it "Stefi" wrote: 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: 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 |
|
#6
|
|||
|
|||
|
Thanks Thanks a lot Stefi ...
"Stefi" wrote: 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: Dear Stefi, Thanks for that can you help me how to run this program and use it "Stefi" wrote: 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
